0 Replies Latest reply on Oct 17, 2003 10:27 AM by urban011

    Apparently wrong driver class specified for URL:class:org.po

    urban011 Newbie

      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!