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(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.443 / Virus Database: 248 - Release Date: 1/10/2003
| 