My solution:
Copy the Oracle/ora92/jdbc/lib/classes12.jar package from the oracle root directory to the/sshproject/webroot/WEB-INF/lib directory.
Reference scheme:
Catch sqlexception when trying to get connection from datasource
Org. Apache. tomcat. DBCP. DBCP. sqlnestedexception: cannot load JDBC Driver Class 'oracle. JDBC. Driver. oracledriver'
The class12.jar package has not been loaded in Tomcat. You can obtain the package from Oracle/ora92/jdbc/lib/classes12.zip In the oracle root directory. decompress the package and place it in the Tomcat root directory Lib.
Org. Apache. tomcat. DBCP. DBCP. sqlnestedexception: cannot create poolableconnec
Because
<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 "/>
The URL in is not changed yet.