How do I set the socket timeout for a DB2 (9.7) Universal JDBC Driver DataSource on WebSphere Application Server 6.1? I've tried adding the 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?
Kindly clarify, why we will socket timeout parameter and how it effects at websphere and datasource level.
The fact here is that I'm trying to set the socket timeout at WebSphere level because it is very important to a specified scenario we must prove. If we could not set the timeout at this level, how can we set it up?
The property is set on the datasource and should therefore affect the JDBC driver - am I right?
Can you somehow from your application access the properties of the connection you obtain from the datasource? (The idea is to independently verify that the property has been set. I tried to find this out, but I dont't do DB2 and I didn't easily find a JavaDoc that would describe how to do it.)
Are you using the latest version of the driver? It is possible that older versions of the driver might not recognize the property.