\/bin\/jbosscli.sh<\/p>\n
Add postgres library<\/p>\n
module add –name=org.postgres –resources=\/home\/inventory\/postgresql-9.4-1206-jdbc41.jar –dependencies=javax.api,javax.transaction.api <\/p>\n
add subsystem.<\/p>\n
\/subsystem=datasources\/jdbc-driver=postgres:add(driver-name=”postgres”,driver-module-name=”org.postgres”,driver-class-name=org.postgresql.Driver)<\/p>\n
\/subsystem=datasources:installed-drivers-list<\/p>\n
\/subsystem=datasources\/jdbc-driver=postgres:add(driver-name=”postgres”,driver-module-name=”org.postgres”,driver-class-name=org.postgresql.Driver)<\/p>\n
data-source add \\
\n –name=mydatabaseDS \\
\n –jndi-name=java:\/mydatabaseDS \\
\n –use-java-context=true \\
\n –use-ccm=true \\
\n –connection-url=jdbc:postgresql:\/\/${postgresql.db.host}:${postgresql.db.port}\/${postgresql.db.name} \\
\n –driver-name=postgresql \\
\n –user-name=${postgresql.db.username} \\
\n –password=${postgresql.db.password} \\
\n –check-valid-connection-sql=”SELECT 1″ \\
\n –background-validation=true \\
\n –background-validation-millis=60000 \\
\n –flush-strategy=IdleConnections \\
\n –min-pool-size=10 \\
\n –max-pool-size=50 \\
\n \u2014pool-prefill=false<\/p>\n
data-source add \\
\n –name=inventoryDS \\
\n –jndi-name=java:\/inventoryDS \\
\n –use-java-context=true \\
\n –use-ccm=true \\
\n –connection-url=jdbc:postgresql:\/\/localhost\/postgres \\
\n –driver-name=postgres \\
\n –user-name=postgres \\
\n –password=123456 \\
\n –check-valid-connection-sql=”SELECT 1″ \\
\n –background-validation=true \\
\n –background-validation-millis=60000 \\
\n –flush-strategy=IdleConnections \\
\n –min-pool-size=10 \\
\n –max-pool-size=50 \\
\n \u2014pool-prefill=false<\/p>\n