ViewClimateHomeAction.java is the java file, the point at which the database is called. We use direct SQL. The same application is working in JBoss 4. but it is not working in JBoss 5.1.0.

Other than copying the postgres-ds.xml file to server/default/deploy folder and added postgresql-8.4-702.jdbc4.jar to server/default/lib folder, is there any steps to configure the databse?

I have attached the postgres-ds.xml file also.

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

<!-- ===================================================================== -->

<!-- -->

<!-- JBoss Server Configuration -->

<!-- -->

<!-- ===================================================================== -->

<!-- See http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource -->

<!-- $Id: postgres-ds.xml 88948 2009-05-15 14:09:08Z jesper.pedersen $ -->

<!-- ==================================================================== -->

<!-- Datasource config for Postgres -->

<!-- ==================================================================== -->

<datasources>

<local-tx-datasource>

<jndi-name>CLIMATEPARLIAMENT_APP_DS</jndi-name>

<connection-url>jdbc:postgresql://localhost:5432/cparl</connection-url>

<driver-class>org.postgresql.Driver</driver-class>

<user-name>postgres</user-name>

<password></password>

<!-- sql to call when connection is created. Can be anything, select 1 is valid for PostgreSQL

<new-connection-sql>select 1</new-connection-sql>

-->

<!-- sql to call on an existing pooled connection when it is obtained from pool. Can be anything, select 1 is valid for PostgreSQL

<check-valid-connection-sql>select 1</check-valid-connection-sql>

-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<metadata>

<type-mapping>PostgreSQL 8.0</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>