From user-return-4009-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org Wed Jul 05 19:36:39 2006 Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 66171 invoked from network); 5 Jul 2006 19:36:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Jul 2006 19:36:39 -0000 Received: (qmail 40242 invoked by uid 500); 5 Jul 2006 19:36:36 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 40221 invoked by uid 500); 5 Jul 2006 19:36:36 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 40209 invoked by uid 99); 5 Jul 2006 19:36:35 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 12:36:35 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of linsun.unc@gmail.com designates 64.233.184.224 as permitted sender) Received: from [64.233.184.224] (HELO wr-out-0506.google.com) (64.233.184.224) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 12:36:35 -0700 Received: by wr-out-0506.google.com with SMTP id i32so909608wra for ; Wed, 05 Jul 2006 12:36:14 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole:importance:in-reply-to; b=FR/R35W+/HBcI0g4YBCS5s+rbdIKmAYHwPuKPAbV5/FZqah8mXjhEwxUuCTgGIvltLfgjux/JAz2zJc9I0k588VrJ6TXuBz+VWaiiOODRxayobnI3xnpiwjed/qqK2ar+4xM4tgVV1ZxzIOMvylu8Z84k3C7LXTL2l7VWwbgcUs= Received: by 10.54.62.4 with SMTP id k4mr3154327wra; Wed, 05 Jul 2006 12:36:14 -0700 (PDT) Received: from LinT60 ( [66.57.117.186]) by mx.gmail.com with ESMTP id g3sm6402667wra.2006.07.05.12.36.13; Wed, 05 Jul 2006 12:36:14 -0700 (PDT) From: "Lin Sun" To: Subject: RE: daytrader with Tranql Oracle XA resource adapter Date: Wed, 5 Jul 2006 15:36:14 -0400 Message-ID: <003201c6a06a$470efd20$ae943109@raleigh.ibm.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Importance: Normal In-Reply-To: <44A43E5E.8070408@coderesearch.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi there, Thanks - I remember seeing your posting on CommitBeforeAutCommit setting = in the generic adapter. The CommitBeforeAutCommit setting is not avail = in the Oracle XA resource adapter. =20 Lin -----Original Message----- From: Mario R=FCbsam [mailto:mr@coderesearch.com]=20 Sent: Thursday, June 29, 2006 4:56 PM To: user@geronimo.apache.org Subject: Re: daytrader with Tranql Oracle XA resource adapter Hi, the CommitBeforeAutCommit setting in the generic adapter call a commit on the local connection before it calls setAutoCommit(true). Some JDBC drivers act not like specified in JDBC and don't call a commit when the AutoCommit value changes with setAutoCommit(true) so CommitBeforeAutCommit is a workaround to get the transaction commited on these drivers (MySQL, MaxDB, PostgreSQL in some cases). I don't know about the XA driver and Oracle but it could be a similar problem. -Mario Lin Sun wrote: > Hi there, >=20 > 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! >=20 > 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. >=20 > Here is what I did to check if the order is recorded in the database: >=20 > Select * from orderejb where account_id=3D50; >=20 > 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. >=20 > If I run the same scenario with db2 or derby, I can see my order > recorded in the orderejb table immediately. >=20 > 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? >=20 > Thanks, Lin >=20