Invalid Datasource / No suitable driver found for....

Exceptions that look like

Caused by: javax.servlet.jsp.JspException: Invalid Datasource
at org.srs.web.base.db.ConnectionManager.getConnection(ConnectionManager.java:69)
 at org.srs.web.base.db.ConnectionManager.getConnection(ConnectionManager.java:49)
 at org.srs.web.base.filters.modeswitcher.ModeSwitcherFilter.init(ModeSwitcherFilter.java:121)
 ... 39 more
 Caused by: java.sql.SQLException: No suitable driver found for jdbc/config-srs

are due to the fact that the specified resource (jdbc/config-srs in this example) is not defined.

Please refer to Data Sources in Tomcat for instructions on how to define data sources in tomcat.

Cannot load JDBC oracle.jdbc.driver.OracleDriver

Exceptions like the following

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
         at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
         at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
         at org.srs.web.base.db.ConnectionManager.getConnection(ConnectionManager.java:65)
         ... 29 more
 Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

are due to the fact that the Oracle driver (jar file) has not been loaded in the tomcat installation. Add documentation on how to do it.

Column SOME_COLUMN does not exist

If you get exceptions complaining that a table column does not exist and you are absolutely poistive that this column actually exists..... if this column is a Timestamp, then your tomcat might need to be configured according to these instructions .

  • No labels