Hi Bharat, You wont have to as the SIMPLE type does not use dbcp from apache but any pooling properites offered by the jdbc driver itself. You do not have to set any of these values they are optional. I have a similar requirment and i have no dependancies other that the the basic ones required for ibatis. The one thing i like is that it would be esay to scale up my up easily by either 1 setting the parameters for my jdbc driver or 2 plugging in apache db pooling - nice no change to the app no build - just test and go.
Steve. -----Original Message----- From: Bharat Nagwani [mailto:[EMAIL PROTECTED] Sent: Tue 3/1/2005 6:56 PM To: [email protected] 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:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 10:39 AM To: [email protected] 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: [EMAIL PROTECTED] Blog: http://cafe.jenkster.com/ Wiki: http://wiki.jenkster.com/ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
<<winmail.dat>>
