We have a stored procedure (on DB2 8.1 FP5) that returns multiple
result sets which we are calling from Java (WebSphere 5.0.2.8).
We can call the stored procedure from the DB2 command line
successfully.
When we call it from WebSphere, we get the following error:
Execution failed due to a distribution protocol error that caused
deallocation of the conversation. A DRDA Data Stream Syntax Error was
detected. Reason: 0xc.
We also see in the log SQLSTATE 58009 and error code -4,499.
We are using the DB2 Universal JDBC driver. Regular SQL access works
fine (non-sproc statements).
Has anyone come across this error before or have any ideas on what
might be causing it?
Any help is greatly appreciated,
Randy
