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: ojb-user-unsubscribe@xxxxxxxxxxxxx
For additional commands, e-mail: ojb-user-help@xxxxxxxxxxxxx
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@xxxxxxxxxxxxx
For additional commands, e-mail: ojb-user-help@xxxxxxxxxxxxx
|