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