Re: Why is the container managing the autocommit state in BMTs?

[Per Newgro]

Hi David,

i downloaded the new version and added "Unmanaged true" to "openejb.conf".
But i get the exception anyway.

     [java] Caused by: java.sql.SQLException: Method not supported. Commit is 
managed automatically by container provider
     [java]     at 
org.apache.openejb.resource.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:106)

in my code i do the following
/**
 * Get connection
 * @param ctx context to get connection for
 * @return Connection connection to database
 * @throws SQLException if error occured (see message)
 */
public static Connection getConnection(ConnectionContext ctx) throws 
SQLException {
  Connection conn = ctx.run();
  if (!ctx.isTransactional()) {
    conn.setAutoCommit(false);
  }
  return conn;
}

The isTransactional of the connection context is false for MYDBnoTx. Thats the 
datasource i want to access. I've tested this all, so that i can be sure.
     [java] Grund: [EMAIL PROTECTED]; datasource: 
[EMAIL PROTECTED]; transactional: 
false

So my conclusion is: Nope the new version is not soliving the problem :-)

As a hint: The physical database for both datasources (defined in 
openejb.conf) is the same! Only the access differs.

Cheers
Per