Return-Path: 
 <user-java-return-11222-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 70825 invoked from network); 30 Mar 2007 13:54:38 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 30 Mar 2007 13:54:38 -0000
Received: (qmail 28246 invoked by uid 500); 30 Mar 2007 13:54:42 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 28225 invoked by uid 500); 30 Mar 2007 13:54:42 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 28214 invoked by uid 99); 30 Mar 2007 13:54:42 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Mar 2007 06:54:42 -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 (herse.apache.org: domain of lists@nabble.com designates
 72.21.53.35 as permitted sender)
Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Mar 2007 06:54:34 -0700
Received: from [72.21.53.38] (helo=jubjub.nabble.com)
	by talk.nabble.com with esmtp (Exim 4.50)
	id 1HXHYT-0001nO-FC
	for user-java@ibatis.apache.org; Fri, 30 Mar 2007 06:54:13 -0700
Message-ID: <9753607.post@talk.nabble.com>
Date: Fri, 30 Mar 2007 06:54:13 -0700 (PDT)
From: Mehul <dikshit_mehul@rediffmail.com>
To: user-java@ibatis.apache.org
Subject: JTA with Ibatis and WebLogic Server
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: dikshit_mehul@rediffmail.com
X-Virus-Checked: Checked by ClamAV on apache.org


Hi 
I was trying to work with JTA IBatis and WebLogic combination for my
persistence layer. 
My configuration as below...
    <transactionManager type="JTA">
            <property name="UserTransaction"
value="javax.transaction.UserTransaction"/>
            <dataSource type="JNDI">
                <property name="DataSource" value="jdbc/pscdb"/>
            </dataSource>    
    </transactionManager>

THe problem we are facing is that IBatis is creating new connection every
time and the pool gets evantually exhausted. We are not starting any
tansaction for select query but the connection is not released back to pool.
the connections are only released after the connection time out period is
elasped.

Is it necessary to start transaction and end them even for select query? Or
is there something more to be done to release the connection back to Pool.

Thanks,
-- 
View this message in context: http://www.nabble.com/JTA-with-Ibatis-and-WebLogic-Server-tf3492356.html#a9753607
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.