 |
AppletTalk.com
Java discussions newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
hemanthjava via JavaKB.co
Guest
|
 Posted: Mon Jan 16, 2006 9:40 am Post subject: Probelm Containing to Sybase Database frrom J2EE Web Applica |
 |
|
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.aspx/java-databases/200601/1
|
|
| Back to top |
|
 |
joeNOSPAM@BEA.com
Guest
|
| Posted: Mon Jan 16, 2006 3:56 pm Post subject: Re: Probelm Containing to Sybase Database frrom J2EE Web App |
|
|
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
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
