3 Replies Latest reply on Mar 30, 2004 3:00 AM by YASUDAzzz

    JBOSS + Postgresql

    George -.IO.- Newbie

      Hi All,
      I am trying to use the Postgresql as my back-end database.
      So I created a psql-ds.xml file :

      <?xml version="1.0" encoding="UTF-8"?>

      <local-tx-datasource>
      <jndi-name>DefaultDS</jndi-name>
      <connection-url>jdbc:postgresql://server.ip/mydatabase</connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
      <user-name>user</user-name>
      pswd
      </local-tx-datasource>

      and I placed in the relative /deploy directory.

      Also I placed the JDBC driver (.jar file) to the corresponding lib/ directory..

      But when I started the JBOSS i get an error in the console

      org.postgresql.util.PSQLException: ERROR: relation "jms_messages" does not exist

      Why JBOSS tries to find the "jms_messages" relation ?
      How can I avoid this error message ?

      Thanks in advance
      George