On Sep 3, 2008, at 5:46 AM, MichaelHaeublein wrote:
Well we use OpenJPA not Tranql...
Next problem is, I'm a beginner concerning Geronimo, EJB3.0 and
Transaction
stuff...
I don't really know how to debug through "foreign" code.
I recently found out, that if I only restart the connection pool in
the
Geronimo Admin Console,
the changes are also commited/written to database. So maybe the
connection
or transaction is not closed properly? But as we use container managed
entities this should happen autmaticaly, or did I get anything wrong
about
that?
Could It be a problem with the version of the OJDBC Driver?
Can you show your persistence.xml and any plans used to deploy a
datasource, along with which adapter you are using?
thanks
david jencks
djencks wrote:
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.
--
View this message in context:
http://www.nabble.com/Transactions-are-commited-only-when-Server-shuts-down.-tp19251568s134p19288501.html
Sent from the Apache Geronimo - Users mailing list archive at
Nabble.com.
