
October 5th, 2005, 07:16 PM
|
|
Contributing User
|
|
Join Date: Jan 2005
Posts: 37
Time spent in forums: 1 Day 2 h 30 m 30 sec
Reputation Power: 4
|
|
|
Cancelling queries and more...
I am trying to develop a solution that requires high-availability / failover capability. My planned architecture is:
- two DB2 servers running 8.x - one active one standby
- HADR to keep things synched
- multiple clients written in Java, accessing the servers using Type 2 jdbc connections.
I am thinking about this plan because I want the clients to be able to seamlessly failover to the other server. By using a type 2 connection (going through the local client for db access), when the primary server fails, the client is configured to use the other server. This generally has been working well, except...
When a thread is actually executing a query when the failure happens, the thread hangs. I have tried using the setQueryTimeout() method, but it does not seem to be implemented in the DB2 driver. I have also tried asynchronously closing the connection or cancelling the statement. None of these seem to work.
I have looked into DataDirect, but they only offer Type 4 drivers. So... my questions are:
- Does anyone know why my setTimeout / close / cancel attempts don't work?
- Does anyone have experience with DataDirect?
- Is there another way to do this, maybe with a different architecture?
Thanks!
|