本人解决的方案:
把从oracle根目录下oracle/ora92/jdbc/lib/classes12.jar 包 拷到/SSHProject/WebRoot/WEB-INF/lib目录下。
参考方案:
catch SQLException when trying to get connection from DataSource
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
tomcat中尚未加载class12.jar包,该包可以从oracle根目录下oracle/ora92/jdbc/lib/classes12.zip得到..然后解压后放置于tomcat根目录lib下
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnec
是由于
<Resource name="jdbc/mydatasource" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:oracle.domain" username="cms" password="cms" maxActive="20" maxIdle="10" maxWait="100000"/>
中的url还没改过来的缘故