2 Replies Latest reply on Mar 26, 2004 4:44 PM by sharky44

    problem in configure jboss with postgres

    kwiyi Newbie

      Hi,
      I have a problem in configuring jboss with postgres.
      I use jboss 3.2.3 and postgres 7.4.1

      - I removed /JBOSS_HOME/server/default/deploy/hsqldb-ds.xml

      - I added /JBOSS_HOME/server/default/deploy/postgres-ds.xml
      - I added /JBOSS_HOME/server/default/lib/pg74jdbc3.jar

      I modified /JBOSS_HOME/server/default/conf/standardjbosscmp-jdbc.xml
      ------------------------------------------------------------------------------
      <jbosscmp-jdbc>


      java:/PostgresDS
      <datasource-mapping>postgres SQL</datasource-mapping>
      ------------------------------------------------------------------------------

      Then I start jboss. However, when I tried to connect to database, it is reported:
      [java] ScriptTool.init error: Connection is broken: Connection refused
      [java] java.sql.SQLException: Connection is broken: Connection refused
      [java] at org.hsqldb.Trace.getError(Unknown Source)
      [java] at org.hsqldb.Trace.error(Unknown Source)
      [java] at org.hsqldb.jdbcConnection.reconnectHSQL(Unknown Source)
      [java] at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
      [java] at org.hsqldb.jdbcConnection.(Unknown Source)
      [java] at org.hsqldb.jdbcDriver.connect(Unknown Source)
      [java] at java.sql.DriverManager.getConnection(DriverManager.java:512)
      [java] at java.sql.DriverManager.getConnection(DriverManager.java:171)
      [java] at org.hsqldb.util.ScriptTool.execute(Unknown Source)
      [java] at org.hsqldb.util.ScriptTool.main(Unknown Source)
      [java] Exception in thread "main" java.lang.NullPointerException
      [java] at org.hsqldb.util.ScriptTool.execute(Unknown Source)
      [java] at org.hsqldb.util.ScriptTool.main(Unknown Source)

      [java] Java Result: 1

      I think there must be other configuration I need to make. I just follow the instruction of how to config MySQL in "getting started tutorial". Is there any other thing I need to do?

      Thanks a lot.
      Kwiyi