Re: Enhydra: Can't load Postgresql JDBC driver

["Darius Katz" <darius.katz@xxxxxxxxxx>]

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