Hello,
please give follwing context definition a chance conf/Calalina/localhost/ROOT.xml
<Context reloadable="true" crossContext="true">
<Resource name="jdbc/postgres" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="whatver" password="whatver"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/whatever" scope="Shareable"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"/><Context>
Your are sure that you copy the postgres jar at common/lib?
Peter
Stuart Lewis schrieb:
Hi,
I've searched the archives and generally on google, and whilst people see the problem a lot, I've not found a definitive answer for how to configure dbcp in the root context.
E.g.
In server.xml I have:
<Context path="/DBTest" docBase="DBTest" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/postgres" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="whatver" password="whatver" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://127.0.0.1:5432/whatever" scope="Shareable" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"/>
</Context>
If I copy this, and have it the same, except:
<Context path="/" docBase="ROOT" debug="5" reloadable="true" crossContext="true">
then it fails, with:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
How should I be configuring my postgress connection for use in the root context?
Any help will be hugely appreciated, and will stop me from pulling any more of my hair out!
Thanks,
Stuart
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
