Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:Mime-Version:In-Reply-To:References:Content-Type:Message-Id:Content-Transfer-Encoding:From:Subject:Date:To:X-Mailer;
  b=psulkPG507hXFrknMZmqm/vfIBGRQWCrArvcMItwo+1TnHMItuX2WY/shxJWh8PCV0hhuULQ89yuldWwFdEo8doiJH/AVxVtV8PGiYus2OkupRIGiMtFsJOhnHdx77nbuMUM5Kny9M/ix0EWoMmglkskFhIWZbFHPlfEeRToSD8=
  ;
Mime-Version: 1.0 (Apple Message framework v749.3)
In-Reply-To: <add18bc80606291342y7be2b15ew348af8d56a84ef3b@mail.gmail.com>
References: <add18bc80606291342y7be2b15ew348af8d56a84ef3b@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <70C7F68E-522C-4089-B2EC-345894570AEF@yahoo.com>
Content-Transfer-Encoding: 7bit
From: David Jencks <david_jencks@yahoo.com>
Subject: Re: daytrader with Tranql Oracle XA resource adapter
Date: Thu, 29 Jun 2006 14:12:43 -0700
To: dev@geronimo.apache.org


On Jun 29, 2006, at 1:42 PM, Lin Sun wrote:

> 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?
>

Can you figure out what transaction demarcation is being used for  
this work?  Is the connection supposed to be autocommit, is  
connection.commit() being used, or is there a JTA transaction?

If it's autocommit, it might be worth investigating what  
connection.getAutocommit() says.

thanks
david jencks


> Thanks, Lin