DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDB2 Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old October 5th, 2005, 07:16 PM
Zone Zone is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 37 Zone User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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!

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDB2 Development > Cancelling queries and more...


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway