Hi Chuck,
> Which context.xml? The global one in the conf directory, or an
> app-specific one in its META-INF directory?
>
The global one in the conf directory.
> > we modified this line in catalina.config
>
> I presume you mean catalina.properties in the above statment.
>
Yep, typo, sorry :)
> > common.loader=${catalina.home}/lib,${catalina.home}/lib/*.jar,*
> > ${catalina.base}/lib,${catalina.base}/lib/*.jar*
>
> Did you add the extra asterisks, or is that an artifact of your copy &
> paste?
>
C&P artifact. In my sent items folder on Gmail, I'm not seeing them.
> > Unfortunately when we use -Dcatalina.config to specify
> > catalina.properties.development, the postgres.jar file
> > is no longer found when Tomcat attempts to create a connection.
>
> Evidence to support that assertion? (I.e., post the stack trace.)
>
When we use catalina.properties (and omit the -Dcatalina.config option),
everything works. When we attempt to use catalina.properties.development
(file diff shows no differences) by specifying the -Dcatalina.config
property, this is what happens:
DataSource ds = (DataSource) new
InitialContext().lookup("java:comp/env/jdbc/postgres");
ds.getConnection();
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver
class 'org.postgresql.Driver'
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
Thanks guys, really appreciate the help!
Rob
