Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <jdbc-connection-pool connection-validation-method="auto-commit" driver-classname="org.postgresql.Driver" res-type="java.sql.Driver" name="poolname" is-connection-validation-required="true" connection-creation-retry-attempts="3" validate-atmost-once-period-in-seconds="60">
- <property name="URL" value="jdbc:postgresql://localhost:5432/dbname"></property>
- <property name="user" value="dbuser"></property>
- <property name="password" value="dbpassword"></property>
- </jdbc-connection-pool>
- <jdbc-resource pool-name="poolname" jndi-name="jdbc/poolname"></jdbc-resource>
- <resource-ref ref="jdbc/poolname"></resource-ref>
- java -cp "/opt/jdbc/postgresql.jar:/opt/payara/micro.jar" fish.payara.micro.PayaraMicro --deploy webapp.war --domainConfig microdomain.xml
- <data-source>
- <name>java:global/ExampleDataSource</name>
- <class-name>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</class-name>
- <server-name>localhost</server-name>
- <port-number>3306</port-number>
- <database-name>mysql</database-name>
- <user>root</user>
- <password>root</password>
- <!-- Example of how to use a Payara specific custom connection pool setting -->
- <property>
- <name>fish.payara.sql-trace-listeners</name>
- <value>com.sun.gjc.util.SQLTraceLogger</value>
- </property>
- </data-source>
- java -jar payara-micro.jar --deploy myApp.war --domainConfig mydomain.xml
- setAlternateDomainXML(File alternateDomainXML)
- <!-- db1 -->
- <jdbc-connection-pool
- datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" name="db1"
- res-type="javax.sql.DataSource"
- steady-pool-size="1"
- is-connection-validation-required="true"
- connection-validation-method="meta-data"
- max-pool-size="10">
- <property name="password" value="icoder_pwd"/>
- <property name="user" value="icoder_user"/>
- <property name="databaseName" value="icoder_db"/>
- <property name="serverName" value="localhost"/>
- <property name="portNumber" value="3310"/>
- <property name="zeroDateTimeBehavior" value="convertToNull"/>
- </jdbc-connection-pool>
- <jdbc-resource pool-name="db1" jndi-name="jdbc/db1"/>
- <!-- db2 -->
- <jdbc-connection-pool
- datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" name="db2"
- res-type="javax.sql.DataSource"
- steady-pool-size="1"
- is-connection-validation-required="true"
- connection-validation-method="meta-data"
- max-pool-size="10">
- <property name="password" value="icoder_pwd"/>
- <property name="user" value="icoder_user"/>
- <property name="databaseName" value="icoder_db"/>
- <property name="serverName" value="localhost"/>
- <property name="portNumber" value="3311"/>
- <property name="zeroDateTimeBehavior" value="convertToNull"/>
- </jdbc-connection-pool>
- <jdbc-resource pool-name="db2" jndi-name="jdbc/db2"/>
- </resources>
Add Comment
Please, Sign In to add comment