Return-Path: 
 <ibatis-user-java-return-1266-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 27257 invoked from network); 1 Mar 2005 19:21:50 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 1 Mar 2005 19:21:50 -0000
Received: (qmail 265 invoked by uid 500); 1 Mar 2005 19:21:31 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 199 invoked by uid 500); 1 Mar 2005 19:21:31 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 144 invoked by uid 99); 1 Mar 2005 19:21:31 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (hermes.apache.org: local policy)
Received: from ddsmttayz003.sam.pentagon.mil (HELO
 ddsmttayz003.ptc.pentagon.mil) (140.185.1.132)
  by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 01 Mar 2005 11:21:29 -0800
Received: by ddsmttayz003.ptc.pentagon.mil with Internet Mail Service
 (5.5.2657.72)
	id <FS129T6G>; Tue, 1 Mar 2005 19:21:42 -0000
Message-ID: 
 <B1A1D42876EED611858C00805FC78FF70938D989@ddsmttayz064.int.dmdc.osd.mil>
From: "Yee, Richard K, CTR,, DMDCWEST" <Richard.Yee.ctr@osd.pentagon.mil>
To: "'ibatis-user-java@incubator.apache.org'"
	 <ibatis-user-java@incubator.apache.org>
Subject: RE: Database Connection without Datasource
Date: Tue, 1 Mar 2005 19:19:49 -0000 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: text/plain
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Bharat,
Just use the Simple datasource. You won't be dependent on any outside
frameworks. 

-Richard


-----Original Message-----
From: Bharat Nagwani [mailto:bnagwani@juniper.net] 
Sent: Tuesday, March 01, 2005 10:57 AM
To: ibatis-user-java@incubator.apache.org
Subject: RE: Database Connection without Datasource


Thanks for the replies.
I think it is just little expensive to create a datasource object and a 
Conn. Pool with 1 connection, When all my code needs is to get a single
connection do some processing and quit. It also means I am dependent on some

framework like dbcp for DataSource implementation.

thanks

-----Original Message-----
From: Kris Jenkins [mailto:krisajenkins@yahoo.co.uk] 
Sent: Tuesday, March 01, 2005 10:39 AM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Database Connection without Datasource

I'm pretty sure dataSource is mandatory (after all, you've got to have 
some kind of source for your data!).  Whenever I've wanted to do what 
you describe, I've just used <dataSource type="SIMPLE"> and set 
<property name="Pool.MaximumActiveConnections" value="1"/>

HTH,
Kris

>  
>
> Hi,
>
>  
>
> Is there a way to specify connection properties in xml file to create
> a single connection (no conn. Pool) instead of using datasource? Lets
say
>
> my application runs once per day. It creates a connection does some
> processing and ends. Datasource
>
> in this case is not a right choice.
>
>  
>
> thanks
>


-- 
Kris Jenkins
Email:  kris@jenkster.com
Blog:   http://cafe.jenkster.com/
Wiki:   http://wiki.jenkster.com/