Utilities Blog by JuCa Cruz
If it happened to me before, maybe what I've posted here will help you.
Showing posts with label
DB2
.
Show all posts
Showing posts with label
DB2
.
Show all posts
Thursday, September 30, 2010
Validation Query on WebSphere DataSource
Do you remember this?? (for those who have worked before with DBCP : validationQuery)
<dataSource type="DBCP"> <property name="driverClassName" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> <property name="initialSize" value="2"/> <property name="maxActive" value="10"/> <property name="maxIdle" value="2"/> <property name="maxWait" value="-1"/> <property name="removeAbandoned" value="true"/> <property name="removeAbandonedTimeout" value="300"/> <property name="logAbandoned" value="true"/> <property name="testWhileIdle" value="true"/> <property name="testOnReturn" value="true"/> <property name="testOnBorrow" value="true"/> <property name="validationQuery" value="${validationQuery}"/> </dataSource>
I was tired to look for this attribute in Websphere and I found it :P
Tip: On
DB2
the equivalent to SELECT 1 FROM DUAL is
SELECT 1 FROM SYSIBM.SYSDUMMY1
Older Posts
Home
Subscribe to:
Posts (Atom)