You need to execute 'begin' on your CSpTransaction to begin the transaction.
-- Curt Springer, Team ND
At 08:26 PM 6/11/99 +0530, Deepak Kumar Adhikary wrote:
>Hi,
>
>I am doing a full manual CspTransaction using CSpMultiSQL in the foll.
>fashion :
>
>CSpTransaction tranMainLabReq = null;
>CSpMultiSQL doLabTestReqAll = (CSpMultiSQL) CSpider.getDataObject
>("doLabTestReqAll");
>CSpMultiSQL doLabTestCellAll = (CSpMultiSQL) CSpider.getDataObject
>("doLabTestCellAll");
>
>try
>{
> tranMainLabReq = new CSpTransaction();
> if (tranMainLabReq.begin ("dsLtrs"))
> {
> if ( strMode.equals("TRUE"))
> {
>
>doLabTestReqAll.setSqlTextOverrideInsert(CSpSQLObject.FULL_TEXT_OVERRIDE
>);
>
>doLabTestReqAll.setSqlTextFullInsert(strSqlStmt);
> tranMainLabReq.executeInsert(doLabTestReqAll);
> }
> else
> {
>
>doLabTestReqAll.setSqlTextOverrideUpdate(CSpSQLObject.FULL_TEXT_OVERRIDE
>);
>
>doLabTestReqAll.setSqlTextFullUpdate(strSqlStmt);
> tranMainLabReq.executeUpdate(doLabTestReqAll);
>
> }
>
> if (tranMainLabReq.succeeded())
> {
> Some more processing goes on and some dataobjects for
>this transaction get executed.
> ------
> ------
> ------
>
> At the end for the last
> if (tranMainLabReq.succeeded ())
> {
>
> if (tranMainLabReq.isActive())
> CSpLog.send(this, CSpLog.CRITICAL, "
>TRANSACTION ACTIVE 10");
>
> tranMainLabReq.commit ();
>
> if ( tranMainLabReq.commit() )
> CSpLog.send(this, CSpLog.CRITICAL,
>"Transaction commited");
> }
> else Rollback.
>
>}
>
>Now the problem I am facing is it comes all the way to the log
>"TRANSACTION ACTIVE 10" ( meaning the transaction is active ) but as
>soon as it encounters the commit statement it gives the following
>message :
>
>spider.database.CSpTransaction.commit: Called when database transaction
>is NOT 'active'. Call has been ignored
>
>And thereafter the log "Transaction commited" is not shown. As a result
>the tables are not getting updated. This is quite weird as the
>transaction is showing up as active till the end but actually not
>committing. I have put a log
>" TRANSACTION ACTIVE n " at each tranMainLabReq.executeUpdate/Insert(
>dataobject ). The flow of logic goes on after checking
>(tranMainLabReq.succeeded()) .
>
>I am not able to understand why this strange thing is happening. Are the
>setSqlTextOverrideUpdate( ) or setSqlTextFullUpdate(strSqlStmt) are
>failing or is there any thing else to be done which I am missing out ?
>
>Any help would be highly appreciated.
>
>Regards
>Deepak
>_________________________________________________________________________
>
>For help in using, subscribing, and unsubscribing to the discussion
>forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
>For dire need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
