Re: jboss to postgresql connections fail. Failed to register driver

You're getting a ClassNotFoundException. The postgress driver classes
could not be found on the classpath. Put your postgresql.jar into
$JBOSS_HOME/server/all| default | minimal/lib

Jim wrote:
> 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>