File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes How do I set the socket timeout for a DB2 Universal JDBC Driver DataSource on WAS 6.1? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "How do I set the socket timeout for a DB2 Universal JDBC Driver DataSource on WAS 6.1?" Watch "How do I set the socket timeout for a DB2 Universal JDBC Driver DataSource on WAS 6.1?" New topic
Author

How do I set the socket timeout for a DB2 Universal JDBC Driver DataSource on WAS 6.1?

Josue Nelson
Greenhorn

Joined: Nov 02, 2012
Posts: 11

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?

Any help is appreciated.

JN - SW Specialist
kona krishnakumar
Ranch Hand

Joined: Dec 03, 2011
Posts: 32
Hi Josue Nelson,

Kindly clarify, why we will socket timeout parameter and how it effects at websphere and datasource level.
Josue Nelson
Greenhorn

Joined: Nov 02, 2012
Posts: 11

kona krishnakumar wrote:Hi Josue Nelson,

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?

Thanks in advance.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3435
    
  47

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.
Josue Nelson
Greenhorn

Joined: Nov 02, 2012
Posts: 11

Martin Vajsar wrote:Are you using the latest version of the driver? It is possible that older versions of the driver might not recognize the property.


I am not using the latest version of the driver, the problem maybe there. I'm going to check this point and post back if find any solution!

Thanks.

JN
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How do I set the socket timeout for a DB2 Universal JDBC Driver DataSource on WAS 6.1?
 
Similar Threads
quick question on DB2 JDBC encoding
Connection Pooling in JBoss v5.0 with IBM DB2
Connection Pooling in JBoss v5.0 with IBM DB2
Error in DB2 connection Pooling
java.sql.SQLException: No suitable driver