Skip site navigation (1) Skip section navigation (2)

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

From: kevinc <kevinc(at)elp(dot)rr(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: jboss to postgresql connections fail. Failed to register driver
Date: 2004-04-20 20:12:32
Message-ID: Qufhc.4195$NR5.3044@fe1.texas.rr.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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>


In response to

pgsql-jdbc by date

Next:From: Ron St-PierreDate: 2004-04-20 21:26:15
Subject: Re: Make not working (on RHE)
Previous:From: JimDate: 2004-04-20 17:04:12
Subject: jboss to postgresql connections fail. Failed to register driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group