I am facing the same problem.
I was wondering whether tansaction.begin("whateverTheDataSourceNameIs oracle In my
case") is a must for any manual transaction. Becasue when i try this, it just
hangs
on me, does not go further, and waits for time out.
And is there a way to make the transaction active, i did check for isActive(), it
always goes to NOT active.
Any suggestion!!!
Thanks
Neeraj
Curt Springer <[EMAIL PROTECTED]> wrote:
>1. If your Vector is empty, it looks as though you might be rolling back>when you
haven't done anything. There is 'isActive' or something like that>on
CSpTransaction
that you should test.>>2. If you turn on terse debugging in the rdbms
service, you
will see what>is happening with your transaction and the various sql
requests.>>--
Curt Springer, Team NetDynamics>>>>At 03:40 PM 2/26/99 -0600, Jensen Chen
wrote:>>I'm
in the process of migration from 3.12 to 4.1.3 and one of my transaction>>got
blow.
This is the error I get:>>>>"spider.database.CSpTransaction.rollback: Called
when
database transaction>>is NOT 'active'. Call has been ignored.">>>>I can't
figure
it out. Any help would be appreciated. Thanks.>>>>Jensen
Chen>>>>*********************************************************************>>CSpInsert
insertPart = (CSpInsert) CSpider.getDataObject("doPartInsert");>>CSpInsert
insertPrice
= (CSpInsert) CSpider.getDataObject("doPriceInsert");>>CSpTransaction trans =
new
CSpTransaction();>>>>//set up transaction object>>String sql = new
String();>>boolean
ok =
false;>>trans.addDataObject(insertPart);>>trans.addDataObject(insertPrice);>>>>try>>{>>
if (trans.begin("OracleSmithWeb"))>> {>> for (int i = 0; i <
categoryVector.size();
i++)>> {>> //insert into part table>> availibilityValue =
aVector.get(i).toString().toUpperCase();>>
sql = "...my sql...">>>> insertPart.clearAllValues();>>
insertPart.setSqlTextOverride(CSpSQLObject.FULL_TEXT_OVERRIDE);>>
insertPart.setSqlTextFull(sql + "<BR>");>>
trans.execute(insertPart);>>>>
if (insertPart.succeeded())>> {>> //insert into
price table>>
sql = "...my sql...";>>
insertPrice.clearAllValues();>>>>insertPrice.setSqlTextOverride(CSpSQLObject.FULL_TEXT_OVERRIDE);>>
insertPrice.setSqlTextFull(sql);>>
trans.execute(insertPrice);>>
}>> }>> }>> catch(Exception ex)>> {>> ...error
handling...>>
}>> finally>> {>> if (trans.succeeded ())>>
trans.commit();>>
else>> trans.rollback();>> }>>
}>>>>>>_________________________________________________________________________>>>>For
help in using, subscribing, and unsubscribing to the discussion>>forums,
please go
to: http://www.netdynamics.com/support/#forums>>>>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]
