How to set the socket timeout for a DB2 Universal JDBC Driver?

3
votes

How to set the socket timeout for a DB2 (9.7) Universal JDBC Driver DataSource on WebSphere Application Server 6.1? I've tried adding the blockingReadConnectionTimeout property as this IBM Technote says, but the problem is still there. Is there another way to set this property? Should I set it within the Java application code?

Any help is appreciated.

1
javajdbcdb2settimeoutwebsphere-6.1

1 Answers

0
votes

Try changing the timeout on the Connection pool setting through the Admin Console. 

Data sources > Default > Connection pools

Specifically, there is a property called Connection timeout. We have ours set to 60.