From user-return-7747-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org Wed Sep 26 08:49:12 2007 Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 47646 invoked from network); 26 Sep 2007 08:49:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Sep 2007 08:49:12 -0000 Received: (qmail 68873 invoked by uid 500); 26 Sep 2007 08:48:56 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 68850 invoked by uid 500); 26 Sep 2007 08:48:56 -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 68839 invoked by uid 99); 26 Sep 2007 08:48:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Sep 2007 01:48:56 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Sep 2007 08:48:55 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IaSZP-0003Gz-8l for user@geronimo.apache.org; Wed, 26 Sep 2007 01:48:35 -0700 Message-ID: <12896626.post@talk.nabble.com> Date: Wed, 26 Sep 2007 01:48:35 -0700 (PDT) From: Chua Chee Seng To: user@geronimo.apache.org Subject: Transaction problem using Spring 2 Transaction + Oracle Data Source MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: chuacheeseng83@gmail.com X-Virus-Checked: Checked by ClamAV on apache.org Hi all, I am facing problem when using Spring 2 Transaction with Oracle Data Source. The following are the version of components that I am using:- i) JDK (Sun 1.6.0_02) ii) Geronimo 1.1.1 iii) spring.jar (version 2.0.6) iv) aspectweaver.jar, commons-dbcp.jar, commons-logging.jar, commons-pool.jar (come with spring distribution) v) ojdbc6.jar (Downloaded from Oracle 11g database driver) I have deployed a Oracle Data Source called 'TestDataSource' using Console. I then deployed the testoracle application which contains a TestBean. The TestBean contains a insertData() method which uses Spring JDBC to write a record into 'kz_id' database table. The 'kz_id' table has two columns called 'id' (varchar2 type) and 'current_value' (number). Spring Declarative transaction management is used to commit/rollback the transaction. TestServlet get the TestBean from the Spring context and call the insertData() method. I have enabled the logging to see what Spring does with the transaction. Once TestServlet is accessed, I can see from the log that Spring is starting the transaction and commit it when it is done. It seems to have committed successfully. But I am not able to see the data from other Oracle client, for example using sqlplus. To double comfirm that the transaction is not committed properly, I tried to update the related row, which it hang. I also query the v$transaction view and see 1 increment after the TestServlet is accessed. Once Geronimo is shutdown, the data is visible to other clients and count in v$transaction is decreased. I first think it is the problem of the Oracle driver, however, if I use apache DBCP's BasicDataSource instead of data source managed by Geronimo, it works fine! This makes me wonder whether the problem can come from tranql or Geronimo data source? Honestly, I do not know the cause, I would really appreciate for any helps to clarify this. I attach the web app for your reference. http://www.nabble.com/file/p12896626/testoracle.zip testoracle.zip Thanks. Best Regards, Chee Seng -- View this message in context: http://www.nabble.com/Transaction-problem-using-Spring-2-Transaction-%2B-Oracle-Data-Source-tf4520875s134.html#a12896626 Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.