Skip to content

Instantly share code, notes, and snippets.

/gist:a45b234661dad2864b64 Secret

Created August 14, 2015 20:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/a45b234661dad2864b64 to your computer and use it in GitHub Desktop.
Save anonymous/a45b234661dad2864b64 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
../instance1/context.xml
<Resource auth="Container" type="javax.sql.DataSource" name="jdbc/portal"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://db2.server.com:50000/PORTAL"
maxActive="50" maxIdle="25" minIdle="1" maxWait="10000"
initialSize="1" testOnBorrow="true" minEvictableIdleTimeMillis="1800000"
timeBetweenEvictionRunsMillis="1800000" testWhileIdle="true" testOnReturn="true"
username="user" password="yes"
validationQuery="SELECT COUNT(*) FROM SYSIBM.SYSTABLES"
removeAbandoned="true" removeAbandonedTimeout="600" />
<Resource auth="Container" type="javax.sql.DataSource" name="jdbc/load"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://db2.server.com:50000/LOAD"
maxActive="50" maxIdle="25" minIdle="1" maxWait="10000"
initialSize="1" testOnBorrow="true" minEvictableIdleTimeMillis="1800000"
timeBetweenEvictionRunsMillis="1800000" testWhileIdle="true" testOnReturn="true"
username="noone" password="no"
validationQuery="SELECT COUNT(*) FROM SYSIBM.SYSTABLES"
removeAbandoned="true" removeAbandonedTimeout="600" />
../instance2/context.xml
<Resource auth="Container" type="javax.sql.DataSource" name="jdbc/portal"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://db2.server.com:50000/PORTAL"
maxActive="50" maxIdle="25" minIdle="1" maxWait="10000"
initialSize="1" testOnBorrow="true" minEvictableIdleTimeMillis="1800000"
timeBetweenEvictionRunsMillis="1800000" testWhileIdle="true" testOnReturn="true"
username="user" password="yes"
validationQuery="SELECT COUNT(*) FROM SYSIBM.SYSTABLES"
removeAbandoned="true" removeAbandonedTimeout="600" />
<Resource auth="Container" type="javax.sql.DataSource" name="jdbc/other"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://db2.server.com:50000/OTHER"
maxActive="50" maxIdle="25" minIdle="1" maxWait="10000"
initialSize="1" testOnBorrow="true" minEvictableIdleTimeMillis="1800000"
timeBetweenEvictionRunsMillis="1800000" testWhileIdle="true" testOnReturn="true"
username="two" password="ok"
validationQuery="SELECT COUNT(*) FROM SYSIBM.SYSTABLES"
removeAbandoned="true" removeAbandonedTimeout="600" />
<Resource auth="Container" type="javax.sql.DataSource" name="jdbc/unload"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://db2.server.com:50000/UNLOAD"
maxActive="50" maxIdle="25" minIdle="1" maxWait="10000"
initialSize="1" testOnBorrow="true" minEvictableIdleTimeMillis="1800000"
timeBetweenEvictionRunsMillis="1800000" testWhileIdle="true" testOnReturn="true"
username="one" password="maybe"
validationQuery="SELECT COUNT(*) FROM SYSIBM.SYSTABLES"
removeAbandoned="true" removeAbandonedTimeout="600" />
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment