Hi Vesco, I encountered the problem when running regular queries against the Sybase database, not stored procedures. It happened whether or not I ran it inside an explicitly declared JBoss transaction.
Since the problem first hits me with queries that are being executed by my MBeans's startService() method, I do not have the option of tweaking EJB Container settings to workaround this. Thanks, Corby >From: Vesco Claudio <[EMAIL PROTECTED]> >To: "'[EMAIL PROTECTED]'" ><[EMAIL PROTECTED]> >CC: "'Corby Page'" <[EMAIL PROTECTED]> >Subject: RE: [JBoss-dev] LocalManagedConnection.java Breaks Sybase >Date: Wed, 5 Jun 2002 09:17:20 +0200 > >Hi alls! > >This problem is triggered when it is called a stored procedure in sybase. >The stored procedure must be defined with "chained transaction mode" or >"anymode" > ><sql> >sp_procxmode <stored procedure name>, 'anymode' ></sql> > >If the sp is called in transaction (autocommit = false), the mode must be >"anymode". >I think that if the transaction mode for the method of EJB is "Never" the >autocommit mode is setted to false. >I have read the code which is written by David, but I have no tested this. > >David, you say that if there is a managed connection the autocommit is off, >is it right? > >Is this valid when we have a managed connection without transaction? Or we >have a autocommit = on? > > Claudio > > > -----Original Message----- > > From: David Jencks [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, June 05, 2002 6:48 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [JBoss-dev] LocalManagedConnection.java Breaks Sybase > > > > Someone already reported this problem and I think found a solution. As >I > > recall it was in the jca forum, which I hope will be back tomorrow. > > > > There is no autocommit setting in the rar configuration, the wrapper > > implements the jca required behavior of > > > > -- if there is a managed connection, autocommit is off (obviously) > > > > -- if there is no managed connection, autocommit is on. > > > > Since jdbc has the bad taste to use autocommit settings rather than > > explicitly starting local transactions, a good deal of jumping through > > hoops seems to be necessary. If you have a simpler way to implement >this > > behavior I'd like to see it. > > > > david jencks _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
