jboss to postgresql connections fail. Failed to register driver - Mailing list pgsql-jdbc
From | pick@jimblish.com (Jim) |
---|---|
Subject | jboss to postgresql connections fail. Failed to register driver |
Date | |
Msg-id | edc212f8.0404200904.690fa4fe@posting.google.com Whole thread Raw |
List | 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>
pgsql-jdbc by date: