problem in configure jboss with postgres

[kwiyi]

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

[yasudazzz]

Kwiyi,

I think your configuration still uses DefaultDS with hsqldb.

there are two ways to solve.

- do not remove $JBOSS_HOME/server/default/deploy/hsqldb-ds.xml

or

- remove $JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc2-service.xml,
and
copy $JBOSS_HOME/docs/examples/jms/postgres-jdbc2-service.xml into
$JBOSS_HOME/server/default/deploy/jms/

good luck.

[sharky44]

I don't know if this is your problem, but I belive the correct datasource mapping is:

<datasource-mapping>PostgreSQL</datasource-mapping>

You can find out for sure if you scroll down quite a ways in standardjbosscmp-jdbc.xml and look for it.