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

Hi,

You are using the wrong  JDBC Driver.
Try to change that to: org.postgresql.Driver
Application Config file, should have:
   DatabaseManager.DB.simpledb.JdbcDriver = "org.postgresql.Driver"

Alberto

damar thapa wrote:

> 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(Unknown 
> 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.HttpPresentationServlet.changeToRunningState(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.ensureAppIsRunning(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.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(Unknown 
> 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.loadLogicalDatabase(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(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.sql.postgresql.PostgreSQLLogicalDatabase.<init>(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.loadLogicalDatabase(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(Unknown 
> 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.HttpPresentationServlet.changeToRunningState(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.ensureAppIsRunning(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.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(Unknown 
> 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(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.sql.postgresql.PostgreSQLLogicalDatabase.<init>(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(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.sql.postgresql.PostgreSQLLogicalDatabase.<init>(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.sql.StandardDatabaseManager.loadLogicalDatabase(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(Unknown 
> 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.HttpPresentationServlet.changeToRunningState(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.ensureAppIsRunning(Unknown 
> Source)
> 2003.02.05 23:51:01: Multiserver,ERROR+     at 
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.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(Unknown 
> 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