Programming Forums > Application Development > Java

hemanth.balaji · Jan 16th, 2006, 3:38 AM

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

Jan 16th, 2006, 3:38 AM	#1
hemanth.balaji Programmer Join Date: May 2005 Posts: 54 Rep Power: 0	Probelm Containing to Sybase Database frrom J2EE Web Application 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Java

Probelm Containing to Sybase Database frrom J2EE Web Application