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 .