Tech-Rapids

Rapid is a section of a river where the river bed has a relatively steep gradient causing an increase in water velocity and turbulence. This blog aims to tackle similar rapids for it's readers in field of software technology by presenting many aspects of tools languages latest trends tips and features of various technologies. Many of these articles are related to hands-on problems faced and solved during the course of my experience, which might also help another distressed soul.

Friday, May 11, 2012

Stored procedure may be run only in unchained transaction mode.

How many times have you got this error while executing a SP using jdbc

Stored procedure 'doSomething' may be run only in unchained transaction mode.

<><><>The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

Although there are some ways that you might find on the net below worked the best for me

just execute the below command on your database

sp_procxmode "{doSomething}", "anymode"

Oh yes for your reference below are the environment details

Database: Sybase
JDK : 1.4
Application Server: Weblogic 7.0

Tech-Rapids

Friday, May 11, 2012

Stored procedure may be run only in unchained transaction mode.

No comments:

Post a Comment