Bharat, Just use the Simple datasource. You won't be dependent on any outside frameworks.
-Richard -----Original Message----- From: Bharat Nagwani [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 10:57 AM 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/

