jboss to postgresql connections fail. Failed to register driver

Поиск
Список
Период
Сортировка
От pick@jimblish.com (Jim)
Тема jboss to postgresql connections fail. Failed to register driver
Дата
Msg-id edc212f8.0404200904.690fa4fe@posting.google.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Freddy Villalba Arias"
Дата:
Сообщение: default_with_oid
Следующее
От: Edoardo Ceccarelli
Дата:
Сообщение: Re: looking for brave souls to test postgres java procedural