Re: jboss to postgresql connections fail. Failed to register driver
От | kevinc |
---|---|
Тема | Re: jboss to postgresql connections fail. Failed to register driver |
Дата | |
Msg-id | Qufhc.4195$NR5.3044@fe1.texas.rr.com обсуждение исходный текст |
Список | 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>
В списке pgsql-jdbc по дате отправления: