Member Avatar for hemanth.balaji
hemanth.balaji 0 Newbie Poster

Hi,
I get the following error when I connect to the Sybase database from my web-app. I put Set chained off in the procedure and nothing happenend. There seems to be a probelm in the Java Side.

Exception :
------------

com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'p_inter_status_dz' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

Note: My Stored Procedure call is surrounded with a try/catch/finally, always closing the connection in the finally.

Regards,
Hemanth
http://www.javaprogrammingworld.com

  • 1 Contributor
  • 0 Replies
  • 84 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.