Hi Vikram,
Vikram Rai wrote:
Hi,
We are running an OJB enabled web-application which has been running in the production environment for some time now. The environment details are :
--SunOne application server --Oracle 8i database --Datasource created on the app-server and connections obtained from it (managed environment)
We have been facing some problems regarding the consistency of transaction handling during saving of records. The typical problems we face are that sometimes database transactions are not committed or sometimes committed too often(even before tansaction.commit() is called).
hmm, never heard about such a problem. Sounds as OJB does not participate in the JTA-tx.
Did you follow the instructions http://db.apache.org/ojb/docu/guides/deployment.html#Deployment+in+EJB+based+applications
If you don't use EJB but you want to integrate OJB in the JTA-tx of the appServer you need the same settings. In addition when using this settings it is not allowed to use the tx demarcation of the OJB api's (e.g. broker.beginTransaction, ...) only the use of JTA is allowed (e.g. UserTransaction or container-managed- or bm-tx).
Nevertheless in OJB 1.0.x release branch (branch OJB_1_0_RELEASE) I fixed several issues in conjunction with use of OJB in managed environments and updated the session bean examples (e.g. in RollbackBean how to handle exceptions).
We have set the connection-descriptor property "eager-release" to "true"
the property 'eager-release' was introduced as a workaround for problems with older JBoss versions.
http://db.apache.org/ojb/docu/guides/deployment.html#%0A++++++++++++++++++++++++-N1022A
and the property "useAutoCommit" to "0".
If you set "useAutoCommit" to "0" OJB doesn't try to change the autoCommit state of the used connection. In managed environments it's not allowed to change the autoCommit state of the used connection, so this setting is mandatory.
regards, Armin
We feel that we have not understood these properties fully well and these might be causing some problems.
Can someone please throw light on wheterh these properties might be the cause. What is the significance of these properties ? Are we right in using these properties ?
Regards, Vikram.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
