Craig Ringer [
https://community.jboss.org/people/ringerc] commented on the document
"JBoss AS 7 - Datasource configuration for postgresql"
To view all comments on this document, visit:
https://community.jboss.org/docs/DOC-17064#comment-9848
--------------------------------------------------
Note that you may instead deploy the PostgreSQL JDBC driver as a module. That's the
only way you'll be able to use a -ds.xml file to define a datasource, as far as I can
tell anyway.
Create the directory modules/org/postgresql/main and place postgresql-9.1-901-1.jdbc4.jar
within it. Now create a module.xml file in the same place, with the content:
<module xmlns="urn:jboss:module:1.1" name="org.postgresql">
<!-- Load with jboss-cli command:
/subsystem=datasources/jdbc-driver=postgresql-driver:add(driver-name=postgresql-driver,
driver-class-name=org.postgresql.Driver, driver-module-name=org.postgresql)
-->
<resources>
<resource-root path="postgresql-9.1-901-1.jdbc4.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
Activate it as "postgresql-driver" with
jboss-cli.sh --connect
command="/subsystem=datasources/jdbc-driver=postgresql-driver:add(driver-name=postgresql-driver,
driver-class-name=org.postgresql.Driver, driver-module-name=org.postgresql"
You may now use this driver in -ds.xml files by specifying it as
"postgresql-driver", eg:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<datasource jndi-name="java:/datasources/some-ds" enabled="true"
use-java-context="true"
pool-name="some-ds-pool">
<connection-url>jdbc:postgresql:somedb</connection-url>
<driver>postgresql-driver</driver>
<security>
<user-name>user</user-name>
<password>pass</password>
</security>
</datasource>
</datasources>
Unlike explicitly naming the jdbc jar in a data-source create command, you can now update
PgJDBC without changing all your datasources.
--------------------------------------------------