geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lin Sun" <linsun....@gmail.com>
Subject daytrader with Tranql Oracle XA resource adapter
Date Thu, 29 Jun 2006 20:42:02 GMT
Hi there,

I have been playing with the daytrader with Tranql Oracle XA resource
adapter (tranql-connector-oracle-xa-1.1.rar).  After I tweaked the
plan a bit and I am able to get daytrader running well with oracle!

One thing I noticed is that if I perform any trading activities as a
user (say uid:1, account_id 50), I get the message that my order has
been completed almost immediately.  However, the order isn't committed
into the oracle database until quite a while.  I don't know the exact
timing but seems to be over 20-30 minutes.

Here is what I did to check if the order is recorded in the database:

Select * from orderejb where account_id=50;

If the order is committed into the database, I would expect a row that
represents my previous order to be returned as the output of the sql
command.

If I run the same scenario with db2 or derby, I can see my order
recorded in the orderejb table immediately.

I looked at the tranql oracle vendor code but I didn't see anywhere
specifying the commit timing thing.  The generic resource adapter does
offer an param called CommitBeforeAutCommit and by setting it to true
would force the commit to happen immediately.   Can someone shed some
light on this?

Thanks, Lin

Mime
View raw message