Hi,
Looks to me like a problem with some Sybase TX setting,
rather than a jBoss transaction problem.
If you want to track transaction, you can set the trace
flag in src/main/org/jboss/tm/TxCapsule.java to true and
recompile.
Alternatively: Have you tried to give the JDBC connection
this "SET CHAINED OFF" command it seems to be asking for?
(Could be that Weblogic does that behind the scenes.)
Best Regards,
Ole Husgaard.
Samuel ROBERT wrote:
>
> Hi all,
>
> I want to call a stored procedure on a sybase system from a session bean.
> This procedure must *not* be inside a transaction, so I declare the method
> transaction type to be "NotSupported" (I tried also "Never"), (and verified
> it by
> putting some traces inside jboss implementation)
>
> But I always get this response :
>
> -->SQLException[Msg=Stored procedure 'GET_INFO_IMAGE_PAR_LT' may be run only
> in unchained transaction mode. The 'SET CHAINED OFF' command will cause the
> current session to use unchained transaction mode.
> , SQLState=ZZZZZ, ErrorCode=7713, ] texte:Can't
> getChronoImageInfos(EE000000000FR)
>
> Which indicates a transaction is started. !! ??
>
> Does someone experienced such a problem ?
> Note : my EJB works fine with Weblogic, and exactly the same database.
>
> Thanx,
> Samuel ROBERT
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
