Perhaps " select 1" is the simplest & lightest weight.
On Jul 12, 2010, at 11:04 AM, David kerber wrote:
On 7/12/2010 10:50 AM, Pid wrote:
On 12/07/2010 15:15, Ashish Kulkarni wrote:
Hi
Where do i specify data source factory? i have following setup
<Resource name="jdbc/mydev"
auth="Container"
type="javax.sql.DataSource"
maxActive="2"
maxIdle="2"
maxWait="3000"
username="user"
password="password"
driverClassName="com.ibm.as400.access.AS400JDBCDriver"
url="jdbc:as400://myip;date format=iso;time
format=iso;errors=basic;trace=false;"
validationQuery="select * from
myschema.mytable" />
Is that the most lightweight validation query you can use?
Yeah, you might add a "WHERE true = false" to it, so you don't make
the db actually do any work.
D
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
