Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Josue Nelson
Greenhorn
Posts: 11
IBM DB2 Java MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
kona krishnakumar
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Josue Nelson,

Kindly clarify, why we will socket timeout parameter and how it effects at websphere and datasource level.
 
Josue Nelson
Greenhorn
Posts: 11
IBM DB2 Java MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 11
IBM DB2 Java MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic