SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' 解决办法
时间:2022-03-14 04:36
当跑jndi项目时抛出:org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class ‘‘ for connect URL ‘null‘异常
解决办法:
1、在Tomcat 6.0\lib下加入oracle驱动包ojdbc14_g-10.2.0.1.0.jar
2、在Tomcat 6.0\conf下的context.xml文件中加入
[javascript]- <Resource
- name="jdbc/aaa_db"
- type="javax.sql.DataSource"
- username="test"
- password="123456"
- driverClassName="oracle.jdbc.driver.OracleDriver"
- maxIdle="3"
- maxWait="5000"
- url="jdbc:oracle:thin:@192.168.30.99:1521:orcl"
- maxActive="10"/>
3、检查项目中web.xml里面的配置是否和context.xml实例名一样
[javascript]
- <resource-ref>
- <description>db connect</description>
- <res-ref-name>jdbc/aaa_db</res-ref-name>
- <res-type>javax.sql.DataSource</res-type>
- <res-auth>Container</res-auth>
- </resource-ref>