Multiple result sets from Sybase

, ,
1

Hi WmUsers,
I have created a stored proc (getProc) which returns multiple result sets from sybase database. I specified two result sets in the ResultSet tab (resultSetA, resultSetB).
Also in the Input/Output tab the output shows a document getProcOutput which has two document lists resultSetA and resultSetB.

When I invoke the adapter service from webMethods the pipeline shows results for only one result set (resultSetA) in the output.

It returns multiple resultsets when executed in a sql client outside of webMethods.

WM IS Version 8.2
Sybase ver 15.0
JDBC Adapter 6.5

Does JDBC adapter 6.5 support multiple result sets with Sybase database?

Thanks,
Suresh

2

Does JDBC adapter 6.5 support multiple result sets with Sybase database?
Did anyone try this before? Any suggestions?

I dont see any errors but it not returning more than one result set.

Thanks,
Suresh

3

Found that there is a JDBC adapter fix for the same on empower. Installed it and the adapter service now returns multiple result sets from sybase.

Thanks,
Suresh