aspose file tools*
The moose likes JDBC and the fly likes DB2 V9.1 for z/OS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 V9.1 for z/OS" Watch "DB2 V9.1 for z/OS" New topic
Author

DB2 V9.1 for z/OS

Swamy Kumar
Greenhorn

Joined: May 25, 2008
Posts: 24
I observe the following error when i try to access DB2 V9.1 for z/OS from my existing application


The exception which was received is com.ibm.websphere.ce.cm.StaleConnectionException: [ibm][db2][jcc][t4][2055][11259] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
The command requested could not be completed because of a permanent error condition detected at the target system.


This error occurs when i use the overloaded prepareStatement method


However, when use the below statement, the application works fine.


I use Type 4 jcc driver to connect to DB2.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

Well, not all queries can be made scrollable by the database server. But still, I wouldn't expect that sort of error message to appear for non-scrollable queries.

Do you really need a scrollable query?
Swamy Kumar
Greenhorn

Joined: May 25, 2008
Posts: 24
Do you really need a scrollable query?

This query is part of an application that was working fine in DB2 V8 - the exception began to surface only after we migrated to DB2 V9. We have used the new set of drivers (3 of them).

But still, I wouldn't expect that sort of error message to appear for non-scrollable queries.

Thats true - may be this is something to do with the driver and not much about connectivity as such. Since some of the other queries work fine.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: DB2 V9.1 for z/OS