I seem to be having some trouble getting JBoss to talk to my PostgreSQL server. I have deployed the following data source to the deploy dir and it seems to deploy without error:
<local-tx-datasource>
<jndi-name>PostgresDS</jndi-name>
<connection-url>jdbc:postgresql:///</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name></user-name>
</local-tx-datasource>
This same connection works fine when run from an Ant script for example, it even runs while debugging in the IDE, so I know that in principle, the connection can be made.
However, when I deploy my WAR to JBoss, I get the following error:
2003-10-17 10:49:54,868 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection:
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: org.postgresql.Driver, url: jdbc:postgresql:///)
Then a slew of errors stemming from the lack of a connection...
I have this same data source and same code running successfully on a Linux machine, I've just moved it to a Windows machine running JBoss with Jetty (The Linux server is also running Jetty). A colleague of mine had this exact same problem on his Linux box, but seems to have worked around it my using a JBoss with Tomcat instead, I'd rather not do this if I don't have to.)
Any suggestions? Thanks!