aspose file tools
The moose likes JDBC and Relational Databases 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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
Sheriff

Joined: Oct 14, 2005
Posts: 19659
    
  10

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
 
It's not a secret anymore!