Re: Can't load Postgresql JDBC driver

Anonther guess:
Maybe there's a typo in your config file
DatabaseManager.DB.nus_press.JdbcDriver = "postgresql.Driver"
AFAIK it should be "org.postgresql.Driver".

Regards,
Stefan

Am Die, 2003-01-14 um 07.24 schrieb Darius Katz:
> Here's a wild guess:
> 
> Maybe this line in the configuration file:
> DatabaseManager.DB.example.ClassType = "PostgreSQL"
> 
> should be like:
> DatabaseManager.DB.nus_press.ClassType = "PostgreSQL"
> 
> -- Darius
> 
> Lok Yek Soon wrote:
> > 
> > I am using Enydra5.0 and Postgresql 7.3 on Linux. I got the latest JDBC
> > driver, file is pg73jdbc3.jar and is located on /usr/local/pgsql/lib.
> > My classpath have also been set to point to the JDBC driver and exported.
> > 
> > While starting up the server using the "run" script, I encounter the
> > following error:
> > 
> > (Cut from multiserver.log)
> > ===
> > 2003.01.14 02:19:38: Multiserver,INFO: Starting Enhydra Multiserver
> > 2003.01.14 02:19:40: Multiserver,INFO: HTTP listening on port: 8002
> > 2003.01.14 02:19:40: Multiserver,INFO: Starting servlet/application 
> > nus_press
> > 2003.01.14 02:19:40: Multiserver,INFO: Application nus_press has url prefix 
> > "".
> > 2003.01.14 02:19:40: nus_press,INFO: nus_press: init
> > 2003.01.14 02:19:40: Nus_press,INFO: Enhydra Java Application Server
> > 2003.01.14 02:19:40: Nus_press,INFO: Enhydra 5.0
> > 2003.01.14 02:19:40: Nus_press,INFO: Together the Workgroup 2002
> > 2003.01.14 02:19:42: Multiserver,ERROR: Unable to change application to
> > running state: Could not create logical database nus_press: can't load JDBC
> > driver class: org.postgresql.Driver: Could not create logical database
> > nus_press: can't load JDBC driver class: org.postgresql.Driver
> > 2003.01.14 02:19:42: Multiserver,ERROR+
> > com.lutris.appserver.server.ApplicationException: Could not create logical
> > database nus_press: can't load JDBC driver class: org.postgresql.Driver:
> > Could not create logical database nus_press: can't load JDBC driver class:
> > org.postgresql.Driver
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > com.lutris.appserver.server.StandardApplication.createDatabaseManager(Unknown
> > Source)
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > com.lutris.appserver.server.StandardApplication.startup(Unknown Source)
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > nus_press.Nus_press.startup(Nus_press.java:29)
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.changeToRunningState(Unknown
> > Source)
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.ensureAppIsRunning(Unknown
> > Source)
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.init(Unknown
> > Source)
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > org.apache.tomcat.core.ServletWrapper$2.method(Unknown Source)
> > 2003.01.14 02:19:42: Multiserver,ERROR+         at
> > org.apache.tomcat.core.ServletWrapper.handleInvocation(Unknown Source)
> > <snip>
> > ====
> > 
> > And here's part of my configuration file  Database Manager Configuration
> > ========
> > #-----------------------------------------------------------------------------
> > #                   Database Manager Configuration
> > #-----------------------------------------------------------------------------
> > #
> > #
> > DatabaseManager.Databases[] = "nus_press"
> > #
> > # The default database used in this application.
> > #
> > DatabaseManager.DefaultDatabase = "nus_press"
> > #
> > # Turn on/off debugging for transactions or queries. Valid values
> > # are "true" or "false".
> > #
> > DatabaseManager.Debug = "true"
> > #
> > # The type of database. Normally this is "Standard".
> > #
> > DatabaseManager.DB.example.ClassType = "PostgreSQL"
> > #
> > # The jdbc driver to use.
> > #
> > DatabaseManager.DB.nus_press.JdbcDriver = "postgresql.Driver"
> > #
> > # Database url.
> > #
> > DatabaseManager.DB.nus_press.Connection.Url = "jdbc:postgresql:nus_press"
> > #
> > # Database user name.  All connection are allocated by this user.
> > #
> > DatabaseManager.DB.nus_press.Connection.User = "postgres"
> > #
> > # Database user password.
> > #
> > DatabaseManager.DB.nus_press.Connection.Password = "postgres"
> > #
> > # The maximum number of connections that a connection
> > # pool will hold.  If set to zero, then connections
> > # are allocated indefinitly or until the database
> > # refuses to allocate any new connections.
> > #
> > DatabaseManager.DB.nus_press.Connection.MaxPoolSize = 30
> > #
> > # Maximum amount of time that a thread will wait for
> > # a connection from the connection pool before an
> > # exception is thrown.  This will prevent possible dead
> > # locks.  The time out is in milliseconds.  If the
> > # time out is <= zero, the allocation of connections
> > # will wait indefinitely.
> > #
> > DatabaseManager.DB.nus_press.Connection.AllocationTimeout = 10000
> > #
> > # Used to log database (SQL) activity.
> > #
> > DatabaseManager.DB.nus_press.Connection.Logging = false
> > #
> > # The number of object identifiers that are allocated
> > # as a group and held in memory.  These identifiers
> > # are assigned to new data objects that are inserted
> > # into the database.
> > #
> > DatabaseManager.DB.nus_press.ObjectId.CacheSize = 20
> > DatabaseManager.DB.nus_press.ObjectId.MinValue = 1000000
> > DatabaseManager.ObjectIdColumnName = "ObjectId"
> > DatabaseManager.VersionColumnName = "ObjectVersion"
> > 
> > ====
> > 
> > Any suggestion what is the problem?
> > 
> > Thanks
> > YekSoon
> > 
> >   ------------------------------------------------------------------------
> > 
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.435 / Virus Database: 244 - Release Date: 12/30/2002
> _______________________________________________
> Enhydra mailing list
> Enhydra@xxxxxxxxxxx
> http://www.enhydra.org/mailman/listinfo.cgi/enhydra