OK, good :-)

> -----Original Message-----
> From: David Jencks [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 05, 2002 1:39 PM
> To:   [EMAIL PROTECTED]
> Subject:      Re: [JBoss-dev] LocalManagedConnection.java Breaks Sybase
> 
> 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

_______________________________________________________________

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