cdtdx
发贴: 8
积分: 0
|
于 2004-10-18 17:23
请各位高手帮帮我,我弄不出来,急得要哭了。
出现的问题如下: getDataSource() error: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Mysql init error: java.lang.NullPointerException 出现问题的代码: private void getDataSource() { try { Context ctx = new InitialContext(); if (ctx == null) throw new Exception("Boom - No Context");
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/myDB");
if (ds != null) { conn = ds.getConnection(); } else System.out.println("can't look up jndi!");
} catch (Exception e) { System.err.println("getDataSource() error: " + e);
} }
web.xml如下: <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/myDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
server.xml如下: <Context path="/register" docBase="D:\downloads\chapter2\SimpleRegister\defaultroot" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/myDB" auth="Container" type="javax.sql.DataSource"> <ResourceParams name="jdbc/myDB"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value>root</value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>driverClassName</name> <value>com.mysql.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:mysql://202.115.30.220:3306/signup</value> </parameter> </ResourceParams> </Resource> </Context>
|