I should not answer messages so late at night.

What I meant to say was...

 
-- if there is a managed TRANSACTION, autocommit is off (obviously)

-- if there is no managed TRANSACTION, autocommit is on.



Managed transaction being one controlled by the app server/transaction
manager rather than your client code.

I think if the transaction mode is NEVER then autocommit will be on since
there is no managed transaction.


Sorry for the confusion

david jencks

On 2002.06.05 03:17:20 -0400 Vesco Claudio wrote:
> 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 
> > 
> > On 2002.06.05 00:08:34 -0400 Corby Page wrote:
> > >   I have had great success using JBoss 2.4.x with our Sybase 12
> > database.
> > > 
> > > But when I attempted to migrate our production system to JBoss 3.0.0,
> I 
> > > immediately had problems. On server startup, several of my MBeans
> > attempt
> > > to 
> > > run queries against the database. Whenever they call
> Connection.close(),
> > > the 
> > > code blows up with a SQLException (the text of the exception is "SET
> > > CHAINED 
> > > IS NOT ALLOWED IN MULTISTATEMENT TRANSACTIONS").
> > > 
> > >   The offending code is in LocalManagedConnection.java:
> > > 
> > > void checkTransaction() throws SQLException
> > > {
> > >   if (inManagedTransaction)
> > >   {
> > >     return;
> > >   } // end of if ()
> > >   //Not in managed transaction.
> > >   //Should we autocommit?
> > >   if (jdbcAutoCommit && !con.getAutoCommit())
> > >   {
> > >     CON.SETAUTOCOMMIT(TRUE);  // Emphasis Added
> > >     return;
> > >   } // end of if ()
> > >   //Autocommit should be off, is it?
> > >   if (con.getAutoCommit())
> > >   {
> > >     con.setAutoCommit(false);
> > >   } // end of if ()
> > > }
> > > 
> > >   The emphasized line is the one which throws the SQLException. If I
> > > comment 
> > > out the line, then my entire application is able to run just fine on
> > 3.0.
> > > 
> > >   LocalManagedConnection.java seems to be a rather awkward piece of
> > code.
> > > It 
> > > hardcodes the initial value of jdbcAutoCommit, and then it
> continually 
> > > attempts to override the connection's autocommit settings, regardless
> of
> > > how 
> > > the user specifies autocommit in the RAR configuration. Sybase is
> > barfing
> > > 
> > > when LocalManagedConnection attempts to forcibly override the
> autocommit
> > 
> > > settings again, even though Sybase thinks it should be managing the 
> > > transactional scope.
> > > 
> > >   While commenting out the offending line works for me, it wouldn't
> > > surprise 
> > > me if that introduced concerns for other users. I hope that we can
> find
> > > an 
> > > elegant patch that will allow Sybase users to take advantage of JBoss
> > > 3.0.
> > > 
> > > Thanks,
> > > Corby
> > > 
> > > 
> > > _________________________________________________________________
> > > Join the world's largest e-mail service with MSN Hotmail. 
> > > http://www.hotmail.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
> > > 
> > > 
> > 
> > _______________________________________________________________
> > 
> > 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
> 
> _______________________________________________________________
> 
> 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
> 
> 

_______________________________________________________________

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

Reply via email to