4.tomcat配置数据源通过JNDI访问mysql数据库
Cannot create JDBC driver of class '' for connect URL 'null'错误
1.添加mysql jdbc驱动至build path,并复制到tomcat目录/lib下
2.在tomcat目录/conf/server.xml的之间添加
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="0." driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bbs?autoReconnect=true"/>
3.在工程的web-inf/web.xml中的之间添加
DB Connection
jdbc/bbs
javax.sql.DataSource
Container
4.创建测试jsp
测试mysql jndi test
DataSource ds = null;
try {
Context initCtx = new InitialContext();
if (initCtx == null)
throw new Exception("Initial Failed!");
Context ctx = (Context) initCtx.lookup("java:comp/env");
if (ctx != null)
ds = (DataSource) ctx.lookup("jdbc/bbs");
if (ds == null)
throw new Exception("Look up DataSource Failed!");
} catch (Exception e) {
System.out.println(e.getMessage());
}
%>
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from user");
while (rs.next()) {
%>
}
rs.close();
stmt.close();
conn.close();
%>
5.相关错误:
<1>Cannot create JDBC driver of class '' for connect URL 'null'
Tomcat先找到web.xml下的,然后再找server.xml下面的。如果没有找到,或者名字错了,则会报“Cannot create JDBC driver of class '' for connect URL 'null'”错误。
注意步骤2和3中jdbc/bbs处名称要相同,3处的url信息要正确
<2>Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
参加步骤1