TOMCAT的Cannot load JDBC driver class 'null'错误
我用TOMCAT 4.2,我利用tomcat的管理工具创建了datasource,而且把sybase的jdbc驱动类库复制到了%CATALINA_HOME%/common/lib/下了。
可是还是报
java.sql.SQLException: Cannot load JDBC driver class 'null'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
at testdb.SimpleSample.doGet(SimpleSample.java:42)
不知道是什么原因。
server.xml
<Resource name="jdbc/Sybase230" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/Sybase230">
<parameter>
<name>validationQuery</name>
<value>select count(*) from dbo.sysobjects</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>password</name>
<value>dongsong</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:sybase:Tds:10.10.10.230:4100/linux230</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>dongsong</value>
</parameter>
</ResourceParams>