PostgreSQL Datasource in JBoss AS7

First add a postgresql module to your modules folder as described in my former post. Then open standalone.xml and insert a datasource and the postgresql driver. Search for subsystem xmlns=”urn:jboss:domain:datasources:1.0″ and insert the datasource. <datasource jndi-name=”java:jboss/datasources/TestDS” pool-name=”TESTDS” enabled=”true” jta=”true” use-java-context=”true” use-ccm=”true”> <connection-url> jdbc:postgresql:test </connection-url> <driver> org.postgresql </driver> <pool> <min-pool-size> 5 </min-pool-size> <max-pool-size> 25 </max-pool-size> <prefill> …

PostgreSQL Datasource in JBoss AS7 Read More »

JBoss Postgresql Module

Just download the latest jdbc4 driver and place it into JBOSS_HOME/modules/org/postgresql/main. Then create a file module.xml in the same folder with the following content (replace filename if necessary): <?xml version=”1.0″ encoding=”UTF-8″?> <module xmlns=”urn:jboss:module:1.0″ name=”org.postgresql”> <resources> <resource-root path=”postgresql-9.1-901.jdbc4.jar”/> </resources> <dependencies> <module name=”javax.api”/> <module name=”javax.transaction.api”/> </dependencies> </module>