We are in the process of migrating an existing 5x broker integration which uses a 4.2 Sybase Intelligent adapter to IS v6.5 which uses the JDBC 6.0.3 adapters. This integration calls a stored procedure which inserts and updates various tables within the Sybase database. The procedure does contain multiple Begin and End transaction blocks, however, no changes have been made to the procedure recently and it has been working successfully when called by the Enterprise Intelligent Sybase adapter. When valid data is passed to the stored procedure, we are not seeing consistent results. Sometimes the data is populated correctly, other times the data does not appear in the correct tables. When the data is not there, no errors are generated within the Sybase database or from the JDBC adapter. Since no errors are generated, the webMethods flow continues on as if everything was successful.
We are connecting to a version 12.5.3 Sybase database, using the JConnect 6.0.5 JDBC thin drivers provided by Sybase. The webMethods JDBC adapter is version 6.0.3 with FP 1 applied along with FP1_Fix11. The adapter transaction type is set to “NO_TRANSACTION”. Within the Sybase database we have set the procedure’s transaction mode to “anymode” with no change in the behavior.
Are there any known issues or fixes available that deal with interaction with Sybase databases and specifically stored procedures?
Any assistance is greatly appreciated. At this point this issue does not directly impact our production environment, but it is part of our on-going migration project which has a production go-live date schedule for the middle of June. If we cannot find a resolution or work-around to this issue, that date will be in serious jeopardy.