RE: enhydra5.0 and postgresql-7.2 -- how to connect?

I am using Enhydra 3.1 and the class name for my PostgreSQL JDBC driver
is org.postgresql.Driver

Cheers,

Claudio 

-----Original Message-----
From: damar thapa [mailto:damar@xxxxxxxxxxxxxx] 
Sent: Wednesday, February 05, 2003 11:09 AM
To: enhydra@xxxxxxxxxxx
Subject: Enhydra: enhydra5.0 and postgresql-7.2 -- how to connect?


Hi,

This is my first time, trying enhydra5.0 and to connect posgrsql7.2. I
followed the tutorial from the site for postgresql connection and 
managed to compile, but on running ./run, I got the following error
messages:


2003.02.05 23:50:58: Multiserver,INFO: Starting Enhydra Multiserver
2003.02.05 23:50:59: Multiserver,INFO: HTTP listening on port: 8002
2003.02.05 23:50:59: Multiserver,INFO: Starting servlet/application
simpleDB 
2003.02.05 23:50:59: Multiserver,INFO: Application simpleDB has url
prefix "".
2003.02.05 23:51:00: simpleDB,INFO: simpleDB: init
2003.02.05 23:51:00: SimpleDB,INFO: Enhydra Java Application Server
2003.02.05 23:51:00: SimpleDB,INFO: Enhydra 5.0
2003.02.05 23:51:00: SimpleDB,INFO: Together the Workgroup 2002
2003.02.05 23:51:01: Multiserver,ERROR: Unable to change application to
running state: Could not create logical database simpledb: can't load
JDBC driver class: postgresql.Driver: Could not create logical database
simpledb: can't load JDBC driver class: postgresql.Driver
2003.02.05 23:51:01: Multiserver,ERROR+
com.lutris.appserver.server.ApplicationException: Could not create
logical database simpledb: can't load JDBC driver class:
postgresql.Driver: Could not create logical database simpledb: can't
load JDBC driver class: postgresql.Driver
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.StandardApplication.createDatabaseManager(Un
known Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.StandardApplication.startup(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
simpledb.SimpleDB.startup(SimpleDB.java:27)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.changeToRunningState(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.ensureAppIsRunning(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.init(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper$2.method(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper.handleInvocation(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper.loadServlet(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.Context.loadServlets(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.Context.setupLoadableServlet(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.servletManager.ServletManager.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.servletManager.ServletManager.startAllContexts(Unkno
wn Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.ServletContainer.readConfigFile(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.ServletContainer.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.multiServer.MultiServer.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.multiServer.MultiServer.main(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+ Caused by:
com.lutris.appserver.server.sql.DatabaseManagerException: Could not
create logical database simpledb: can't load JDBC driver class:
postgresql.Driver
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.StandardDatabaseManager.loadLogicalDatab
ase(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.StandardDatabaseManager.<init>(Unknown
Source)
2003.02.05 23:51:01: Multiserver,ERROR+         ... 17 more
2003.02.05 23:51:01: Multiserver,ERROR+ Caused by:
java.sql.SQLException: can't load JDBC driver class: postgresql.Driver
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.init(Un
known Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.postgresql.PostgreSQLLogicalDatabase.<in
it>(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         ... 19 more
2003.02.05 23:51:01: Multiserver,ERROR+ *** Caused by:
2003.02.05 23:51:01: Multiserver,ERROR+
com.lutris.appserver.server.sql.DatabaseManagerException: Could not
create logical database simpledb: can't load JDBC driver class:
postgresql.Driver
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.StandardDatabaseManager.loadLogicalDatab
ase(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.StandardDatabaseManager.<init>(Unknown
Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.StandardApplication.createDatabaseManager(Un
known Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.StandardApplication.startup(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
simpledb.SimpleDB.startup(SimpleDB.java:27)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.changeToRunningState(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.ensureAppIsRunning(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.init(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper$2.method(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper.handleInvocation(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper.loadServlet(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.Context.loadServlets(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.Context.setupLoadableServlet(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.servletManager.ServletManager.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.servletManager.ServletManager.startAllContexts(Unkno
wn Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.ServletContainer.readConfigFile(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.ServletContainer.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.multiServer.MultiServer.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.multiServer.MultiServer.main(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+ Caused by:
java.sql.SQLException: can't load JDBC driver class: postgresql.Driver
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.init(Un
known Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.postgresql.PostgreSQLLogicalDatabase.<in
it>(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         ... 19 more
2003.02.05 23:51:01: Multiserver,ERROR+ *** Caused by:
2003.02.05 23:51:01: Multiserver,ERROR+ java.sql.SQLException: can't
load JDBC driver class: postgresql.Driver
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.init(Un
known Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.postgresql.PostgreSQLLogicalDatabase.<in
it>(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.StandardDatabaseManager.loadLogicalDatab
ase(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.sql.StandardDatabaseManager.<init>(Unknown
Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.StandardApplication.createDatabaseManager(Un
known Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.StandardApplication.startup(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
simpledb.SimpleDB.startup(SimpleDB.java:27)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.changeToRunningState(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.ensureAppIsRunning(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationSer
vlet.init(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper$2.method(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper.handleInvocation(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.ServletWrapper.loadServlet(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.Context.loadServlets(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.apache.tomcat.core.Context.setupLoadableServlet(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.servletManager.ServletManager.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.servletManager.ServletManager.startAllContexts(Unkno
wn Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.ServletContainer.readConfigFile(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
org.enhydra.servlet.ServletContainer.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.multiServer.MultiServer.start(Unknown Source)
2003.02.05 23:51:01: Multiserver,ERROR+         at
com.lutris.multiServer.MultiServer.main(Unknown Source)
2003.02.05 23:51:01: simpleDB,ERROR: cannot load servlet name: simpleDB

Almost at the top of the error message, it is indicating that it can not
load the driver -- I am using pg72jdbc2.jar, and is in my CLASSPATH.

I am running this under debian3.0 and j2sdk1.4.1_01.

Any pointers would be highly appreciated.

Damar


_______________________________________________
Enhydra mailing list
Enhydra@xxxxxxxxxxx
http://www.enhydra.org/mailman/listinfo.cgi/enhydra