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>
