I really think the most likely explanation for this is that the commitBeforeAutocommit value you are supplying is not getting to the tranql connector. If I was investigating this I would debug through the tranql code to see if the code does try to commit.

thanks
david jencks

On Sep 2, 2008, at 10:55 PM, MichaelHaeublein wrote:


Hi,

We are using neither of them. We use a JDBC driver (ojdbc-14.jar) for the
connectionn pool.


Donald Woods-2 wrote:

Are you using the provided tranql-connector-oracle-local-1.3.rar or
tranql-connector-oracle-xa-1.3.rar for the server db connection pool?


-Donald

MichaelHaeublein wrote:
Hello,

Me any my colleauge are working on client-server-application,
which is using geronimo as an application server and an client
using Swing.

For Database Access we use Beans (EJB 3.0).
The problem is, all transactions (Updates, Inserts, Deletes)
are not commited to the database after the transaction is closed.
Only when shutting down the server all previously made changes
are commited to the database.

We allready found this thread here
http://www.nabble.com/transaction-behaviour-td2470965s134.html#a2470965

We tried to set the option CommitBeforeAutocommit to true as suggested
there,
but this didn't have any effect.



Some techniqual details about the project:

Server: Geronimo Version 2.1.1
Database: Oracle 9.1
Connection-Pool with: Oracle Thin Driver (oracle.jdbc.OracleDriver)

Here's one of the Methodes which is not beeing commited as expected.
---------------------------------------------------------------------
@Stateless
@Remote(AccessRemote.class)
@Local(Access.class)
public class AccessSessionBean implements Access {

 @PersistenceContext(unitName = "FMDBPU")
 EntityManager manager;

 @TransactionAttribute(TransactionAttributeType.REQUIRED)
 public void updateUserPassword(UserValueObject uservo)
   throws NotFoundException, Exception {
   UserBean bb = manager.find(UserBean.class, uservo.getUserId());
   bb.setPass(uservo.getPass());
   manager.flush();
 }
}
---------------------------------------------------------------------

Any ideas what's going wrong?




--
View this message in context: 
http://www.nabble.com/Transactions-are-commited-only-when-Server-shuts-down.-tp19251568s134p19283314.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.


Reply via email to