Which version of JBoss AS you are using?

You cannot use *-ds.xml file in JBoss 6

For Configuring JDBC driver and datasource follow the below steps:

Step 1: Deploy your jdbc driver (postgresql-9.1-902.jdbc4.jar) under JBoss_6_Home\modules\org\postgresql\main  directory (if such directory doesn't exists create one)

Step 2: P

<module xmlns="urn:jboss:module:1.1" name="org.postgresql">
<resources>
<resource-root path="postgresql-9.1-902.jdbc4.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>

Step 3: Configure your datasource standalone.xml

Find the datasource tag in the standalone.xml file and configure as

<datasources>
<datasource jndi-name="java:jboss/PostgresDS" pool-name="PostgresDS">
<connection-url>jdbc:postgresql://localhost:5432/postgresdb</connection-url>
<driver>postgresql</driver>
<security>
<user-name>admin</user-nam e>
<password>admin</password>
</security>
<validation>
<valid-connection-checker classname="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker>
<exception-sorter classname="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter">
</exception-sorter>
</validation>
</datasource>
<drivers>
<driver name="postgresql" module="org.postgresql">
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>

Replace connection url according to your application, the above procedure might work...

Regards,

Madhu

Hi Maimur, we have had the same issue twice yesterday, using jboss 6.1. Do you happen to have a solution/reason for the issue?

Regards,

Joep Vaes