2 Replies Latest reply on Dec 9, 2001 8:41 AM by ndecker

    Still having problems with Postgresql

    ndecker

      I am trying to use PostgreSQL as datasource. Jboss always stops with
      [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS

      I have seen some postings on the usenet, but they suggested setting a password, but i have a password.

      I have checked:
      - Postgres is listening
      - I can connect to postgres with a simple jdbc prog
      - Jboss is not sending any network packets to
      postgres before hanging

      I have tryed rearranging the entries in jboss.jcml without success.

      My entries in jboss.jcml are:

      org.postgresql.Driver





      DefaultDS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl


      jdbc:postgresql:jboss
      jboss
      jboss

      1200000
      10
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0



      Does anyone have a idea?

      Thany you
      Nils

      PS: I have tried jdbc7.0-1.1.jar and jdbc7.1-1.2.jar from the Postgresql distribution. Do you know wich one i should use?

        • 1. Re: Still having problems with Postgresql

          Hi,

          I've seen the same problem with Hypersonic.
          It happens when I start JBoss under a normal profile.
          When I start JBoss from root it works.
          Must be an authority/configuration problem.
          If you locate the config change let me know.

          Regards,
          Adrian

          • 2. Re: Still having problems with Postgresql
            ndecker

            Stupid me!!!

            I have found my mistake. I thought, adding the postgres jar to my CLASSPATH was enough. I found that adding the jdbc** .jar to the lib/ext directory solved my problem.

            Such an easy solution, but i was not expecting something like the classpath. A class not found error would have helped much.

            Thanks for listening

            Nils