jboss to postgresql connections fail. Failed to register driver

From: pick(at)jimblish(dot)com (Jim)
To: pgsql-jdbc(at)postgresql(dot)org
Subject: jboss to postgresql connections fail. Failed to register driver
Date: 2004-04-20 17:04:12
Message-ID: edc212f8.0404200904.690fa4fe@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Sorry I am a complete newbie to the JAVA world and not ultra clear on
JBOSS but am trying to set up WFMopen (workflow engine) for some
workflow tests and cannot connect to the pastgresql server. Can
someone point me to what I have done incorrectly?

what I have done is move the files
$JBOSS_HOME/docs/examples/jms/postgres-jdbc2-service.xml
$JBOSS_HOME/docs/examples/jca/postgres-ds.xml
to
$JBOSS_HOME/server/default/deploy/jms/postgres-jdbc2-service.xml
$JBOSS_HOME/server/default/deploy/postgres-ds.xml
removed the files: (the postgres-jdbc2-service.xml file says to remove
them)
$JBOSS_HOME/server/default/deploy/hsqldb-ds.xml
$JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc2-service.xml
$JBOSS_HOME/server/all/deploy/hsqldb-ds.xml
$JBOSS_HOME/server/all/deploy/jms/hsqldb-jdbc2-service.xml

I then edit the postgres-ds.xml to be
<connection-url>jdbc:postgresql://localhost:5432/database</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>user</user-name>
<password>pass</password>

I also put my postgresql.jar file into
$JBOSS_HOME/lib/postgresql.jar

I have change the pg_hba.conf to
local all trust

to make sure that passwords were not the problem

however when running jboss with the run.sh command I get the
following.

looks like it loads:
10:21:56,370 INFO [MainDeployer] Starting deployment of package:
file:/wf/jboss-3.2.3/server/default/deploy/postgres-ds.xml
10:21:56,698 INFO [MainDeployer] Deployed package:
file:/wf/jboss-3.2.3/server/default/deploy/postgres-ds.xml
10:21:58,558 INFO [MainDeployer] Starting deployment of package:
file:/wf/jboss-3.2.3/server/default/deploy/jms/postgres-jdbc2-service.xml
10:21:58,976 INFO [MainDeployer] Deployed package:
file:/wf/jboss-3.2.3/server/default/deploy/jms/postgres-jdbc2-service.xml

but then it tries to do something it fails:
org.jboss.resource.JBossResourceException: Could not create
connection; - nested throwable:
(org.jboss.resource.JBossResourceException: Failed to register driver
for: org.postgresql.Driver; - nested throwable: (java.lang.ClassNotFou
ndException: No ClassLoaders found for: org.postgresql.Driver))
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477)
<lots more at warnings>

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message kevinc 2004-04-20 20:12:32 Re: jboss to postgresql connections fail. Failed to register driver
Previous Message Dave Cramer 2004-04-20 16:53:43 looking for brave souls to test postgres java procedural language