In your database execute the following sql on your stored proc:
sp_procxmode sp_MyProc, 'anymode'
jim
----- Original Message -----
From: "Farooq Shaikh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 5:05 PM
Subject: Unchained Txion using Sybase
> Hi Folks
>
> Here is the scenario :
>
> Stateless Bean A (Bean Managed Transaction Control) calls Stateless Bean
> B(Container managed txion - TX_REQUIRED) multiple times in a loop.
>
> Bean B is calling two stored procedures on a Sybase Db - I am assuming the
> Connection is set to autocommit 'true' - both beans hold separate connection
> objects to the Db hence I assume that their transactions are independant of
> each other, hence 'Unchained' ??
>
> The exeception we get is Unchained Transaction not allowed using Sybase
> Stored Procedures.
>
> Appreciate your help
>
> Farooq
>
> ===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
