jsp 连接数据库出现异常!!!
我是用jsp页面调用javabean连接Oracle 10g, 单独测试javabean可以正常连接数据库,就是用jsp调用javabean时出现数据库异常!!!!
异常代码如下:
2009-6-9 13:20:00 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\jdk\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;E:\oracle\product\10.1.0\Db_3\bin;E:\oracle\product\10.1.0\Db_3\jre\1.4.2\bin\client;E:\oracle\product\10.1.0\Db_3\jre\1.4.2\bin;E:\oracle\product\10.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\WbemD:\jdk\bin;D:\jdk\jre\bin;C:\Program Files\Microsoft SQL Server\90\Tools\binn\
2009-6-9 13:20:01 org.apache.coyote.http11.Http11BaseProtocol init
信息: Initializing Coyote HTTP/1.1 on http-8083
2009-6-9 13:20:01 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 532 ms
2009-6-9 13:20:01 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2009-6-9 13:20:01 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/5.5.15
2009-6-9 13:20:01 org.apache.catalina.core.StandardHost start
信息: XML validation disabled
2009-6-9 13:20:01 org.apache.coyote.http11.Http11BaseProtocol start
信息: Starting Coyote HTTP/1.1 on http-8083
2009-6-9 13:20:01 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2009-6-9 13:20:01 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/47 config=null
2009-6-9 13:20:01 org.apache.catalina.storeconfig.StoreLoader load
信息: Find registry server-registry.xml at classpath resource
2009-6-9 13:20:01 org.apache.catalina.startup.Catalina start
信息: Server startup in 531 ms
加载驱动器类时出现异常
出现SQLException异常
jsp代码如下:
<%@ page contentType="text/html; charset=gb2312"%>
<jsp:useBean id="prince" scope="request" class="wangzhan.lond">
<jsp:setProperty name="prince" property="*"/>
</jsp:useBean>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>登录页面</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 60px
}
body {
background-color: #FFFFFF;
}
-->
</style>
<body>
<%!
int leixing=0;
%>
<%
try
{
prince.setID(3); //都是javabean中的方法
prince.setPASSWORD(123456);
leixing=prince.tolond();//这个方法连接数据库,在javabean中是成功的
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>