Probelm Containing to Sybase Database frrom J2EE Web Application

#1 01-16-2006, 04:41 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

--
Message posted via JavaKB.com
http://www.javakb.com/Uwe/Forums.asp...bases/200601/1

#2 01-16-2006, 10:57 AM

Show the code. You probably set autoCommit(false) to do a transaction.
That
turns chained mode back on. Sybase retains the odd behavior of only
allowing
procedures to run (by default) in the chained/unchained mode during
which they
were created. The real solution is to use Sybase's sp_procxmode() to
tell the
DBMS to allow your procedure(s) to run in anymode.
HTH,
Joe Weinstein at BEA Systems

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