采用DataSource连接数据库问题,为什么老是连不上?
我采用DataSource来获得对数据库连接,为什么连不上?
报如下异常
org.apache.jasper.JasperException: Cannot load JDBC driver class 'null'
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
........................
我的jsp源代码如下:
<HTML><HEAD>
<TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8"></HEAD>
<%@ page contentType="text/html" import="javax.sql.*,java.sql.*,javax.naming.*"%>
<BODY bgColor=#fffff0>
<p><font color=#333399 size=5>Users List</font></p>
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/yqJSCDataSource");
Connection conn = ds.getConnection(); //就是在这个地方出错,不能获得连接
try{
Statement statement = conn.createStatement();
String statementStr = "select * from JSC_USER";
ResultSet userResultSet=statement.executeQuery(statementStr);
while(userResultSet.next())
{
System.out.println("User_ID: "+userResultSet.getString("User_ID"));
}
}
catch(SQLException e)
{
System.out.println("Error in operation on Dababase");
}
%>
</BODY></HTML>
Server.xml 配置如下:
<Resource name="jdbc/yqJSCDataSource" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/yqJSCDataSource">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@127.0.0.1:1521:test5</value>
</parameter>
<parameter>
<name>username</name>
<value>yqSupportCenter</value>
</parameter>
<parameter>
<name>password</name>
<value>yqSupportCenter</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
web.xml 配置如下:
<resource-ref>
<description>Oracle Datasource</description>
<res-ref-name>jdbc/yqJSCDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
请教各位怎么回事啊?