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? 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.
