Hi Guys: I am having problem when I am trying to call a store procedure through IBatis.
This is the exception I am getting, Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'proc_next_id' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. I am able to call this store proc using direct JDBC. I think it is something to do with Connection. Has anyone came across this problem Rgds, --Siva Jagadeesan ============================================================================== This message is for the sole use of the intended recipient. If you received this message in error please delete it and notify us. If this message was misdirected, CSFB does not waive any confidentiality or privilege. CSFB retains and monitors electronic communications sent through its network. Instructions transmitted over this system are not binding on CSFB until they are confirmed by us. Message transmission is not guaranteed to be secure. ==============================================================================
