1 Reply Latest reply on Feb 12, 2002 5:43 PM by David Jencks

    non-transactional JDBC connections

    Wes Gere Newbie

      Some SQL statements in my app need to be executed in autocommit mode. However, I would still like to take advantage of JBoss connection pooling for these connections.

      Another way of stating this is: I would like to have a Data Source where the connections do not participate in (are not registered with) the current transaction.

      Is there any way to do this? Is there some configuration of properties for a Data Source in jboss.jcml that does this? Or, can I just call connection.setAutocommit(true)?

      Also, please state what version (2.4.4 or 3.0) will support the solution.

      Thanks in advance,
      -wes