Connection Pooling, application level transactions issues

[kundur]

Hi,

I am trying to use the ConnectionPool in JBOSS. I get a connection from JBOSS. This connection object works ok for database read operations. For update operations I am running into a problem with transactions. It throws SQLException with the following message:

"Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)"

If I get a connection using the DriverManager.getConnection, everything works OK.

In JDBC 2.0 Spec. I found the following:
"Because transaction boundaries are controlled by the middle-tier server, the application code may not call connection.commit() or connection.rollback() methods. These methods throw SQLException if called".

I am wondering if there is any to make the connection obtained from the connection pool in way similar to that obtained from DriverManager.

Many Thanks

Kundur

[foglesa]

You can have a look at the NoTransDS that comes with JBoss it is non transactional.

Al

[davidjencks]

Why are you trying to control transactions yourself in the first place? This is perhaps the largest strength of the ejb model. If you want to anyway, despite the advice of all experts, declare all your beans BMT and use the UserTransaction.