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

Reply via email to