Has anyone tried the JDBC adapter to invoke a sybase stored proc (doing select, update inside)? All the stored procs we have in sybase are in the unchained mode but once the JDBC adapter is trying to call a stored proc it will receive an exception “may be run only in unchained transaction mode…” For varies reasons, we can’t change the mode to anymore. And the problem I know because the JDBC adapter is doing auto-commit inside which does not work well with unchained stored proc. Has anyone encountered something like that? Is this a JDBC adapter bug or Sybase bug?
Thanks.