Mailing-List: contact beehive-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Beehive Developers" <beehive-dev@incubator.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Problem using transactions with JDBC control
Date: Thu, 12 May 2005 13:03:20 -0600
Message-ID: <A33EF4FD8AF1EC48A62CD576DFB75AD5011FA74C@usboex01.amer.bea.com>
Thread-Topic: Problem using transactions with JDBC control
Thread-Index: AcVXGnJE4IAkOGEvS2OL2X5JtKjgoQAClr+Q
From: "Chad Schoettger" <cschoett@bea.com>
To: "Beehive Developers" <beehive-dev@incubator.apache.org>

Hi Scott,

The drts for the jdbcontrol include a few unit tests for transactions --
they are not currently failing.

Other than the move from controlhaus to beehive nothing has changed in
the jdbccontrol code.


In the code sample below why is the connection.commit() call commented
out?  Does it work for you if it is uncommented? =20


  - Chad


-----Original Message-----
From: Scott Semyan=20
Sent: Thursday, May 12, 2005 11:46 AM
To: Beehive Developers
Subject: Problem using transactions with JDBC control

I have a new error in the PetStore web sample. I have a section of code
that uses a transaction to add something to the database. I initially
enabled this with the following code:
=20
 public int addOrder(Order order, Cart cart)
 {
  try {
   java.sql.Connection connection =3D _dbControl.getConnection();
   connection.setAutoCommit( false );
  =20
   // Add order to DB
   // Add the cart items and update the quantities in the DB
   //connection.commit();

  } catch (SQLException e) {

            _logger.error( "Unexpected DAO exception", e );
   throw new DataStoreException("unexpected database exception");

  }

  return orderId;
}

=20
This used to work fine. Now when I do it, the order is added correctly,
but the subsequent call to the database (to read the contents of the
order just entered) generates the following:
=20
Exception: org.apache.beehive.controls.api.ControlException: SQL
Exception while attempting to close database connection.[Invalid
transaction state.]
caused by : SQL Exception: Invalid transaction state.=20
=20
=20
Did anything change recently? Is this the proper way to do transactions
with the JDBC control?
=20
Scott Semyan