Re: Can't load Postgresql JDBC driver

I am wondering if this line

DatabaseManager.DB.nus_press.JdbcDriver = "postgresql.Driver"

should not be

DatabaseManager.DB.nus_press.JdbcDriver = "org.postgresql.Driver"


just a thought.

----- Original Message -----
From: "Lok Yek Soon" <yeksoon@xxxxxxxxxxxxx>
To: <enhydra@xxxxxxxxxxx>
Sent: Thursday, January 16, 2003 1:15 AM
Subject: Re: Enhydra: Can't load Postgresql JDBC driver


> I have corrected the mistakes in the conf file as suggested by Darius and
> Stefan. But I still got the same error messages.
> I have also use a standalone program from
> http://www.fankhausers.com/postgresql/jdbc/ to test the JDBC connection
> with PostgreSQL and it works fine (JDBC to Postgresql works fine).
>
> What else could be causing this?
>
> Thanks
> YekSoon
>
> At 08:28 AM 1/14/2003 +0100, you wrote:
>
> >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(Unknow
n
> > > > 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.443 / Virus Database: 248 - Release Date: 1/10/2003
>