Re: tomcat datasource, find active connections

2010-07-13 Thread Konstantin Kolinko
2010/7/14 Caldarale, Charles R : >> From: Christopher Schultz [mailto:ch...@christopherschultz.net] >> Subject: Re: tomcat datasource, find active connections >> >> As much fun as that sounds, the OP could just use the default >> DataSourceFactory which is based up

RE: tomcat datasource, find active connections

2010-07-13 Thread Caldarale, Charles R
> From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Subject: Re: tomcat datasource, find active connections > > As much fun as that sounds, the OP could just use the default > DataSourceFactory which is based upon DBCP. Does that require setting the privileged at

Re: tomcat datasource, find active connections

2010-07-13 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, On 7/12/2010 10:38 AM, Caldarale, Charles R wrote: >> From: Ashish Kulkarni [mailto:ashish.kulkarn...@gmail.com] >> Sent: 2010 July 12, Monday 09:16 >> To: Tomcat Users List; p...@pidster.com >> Subject: Re: tomcat

Re: tomcat datasource, find active connections

2010-07-12 Thread David kerber
On 7/12/2010 11:23 AM, Ken Bowen wrote: Perhaps " select 1" is the simplest & lightest weight. If the db will accept it (without a FROM clause), yes. D - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For addit

Re: tomcat datasource, find active connections

2010-07-12 Thread Ken Bowen
Perhaps " select 1"is the simplest & lightest weight. On Jul 12, 2010, at 11:04 AM, David kerber wrote: On 7/12/2010 10:50 AM, Pid wrote: On 12/07/2010 15:15, Ashish Kulkarni wrote: Hi Where do i specify data source factory? i have following setup driverClassName="co

Re: tomcat datasource, find active connections

2010-07-12 Thread David kerber
On 7/12/2010 10:50 AM, Pid wrote: On 12/07/2010 15:15, Ashish Kulkarni wrote: Hi Where do i specify data source factory? i have following setup Is that the most lightweight validation query you can use? Yeah, you might add a "WHERE true = false" to it, so you don't make the db actually do

Re: tomcat datasource, find active connections

2010-07-12 Thread Pid
On 12/07/2010 15:15, Ashish Kulkarni wrote: > Hi > Where do i specify data source factory? i have following setup > > auth="Container" > type="javax.sql.DataSource" > maxActive="2" > maxIdle="2" > maxWait="3000" >

RE: tomcat datasource, find active connections

2010-07-12 Thread Caldarale, Charles R
> From: Ashish Kulkarni [mailto:ashish.kulkarn...@gmail.com] > Sent: 2010 July 12, Monday 09:16 > To: Tomcat Users List; p...@pidster.com > Subject: Re: tomcat datasource, find active connections > > Where do i specify data source factory? http://tomcat.apache.org/tomcat-6.0-

Re: tomcat datasource, find active connections

2010-07-12 Thread Ashish Kulkarni
Hi Where do i specify data source factory? i have following setup On Fri, Jul 9, 2010 at 5:42 PM, Pid wrote: > On 09/07/2010 20:03, Ashish Kulkarni wrote: > > Hi > > I have following in context.xml, and it works fine. > > But i would like to find how many active connections are there in data

Re: tomcat datasource, find active connections

2010-07-09 Thread Pid
On 09/07/2010 20:03, Ashish Kulkarni wrote: > Hi > I have following in context.xml, and it works fine. > But i would like to find how many active connections are there in data > source or how many total connections are there? > 1 is it possible to do so? > > 2 Can i change type javax.sql.DataSourc

tomcat datasource, find active connections

2010-07-09 Thread Ashish Kulkarni
Hi I have following in context.xml, and it works fine. But i would like to find how many active connections are there in data source or how many total connections are there? 1 is it possible to do so? 2 Can i change type javax.sql.DataSource to com.ibm.as400.access.AS400JDBCDataSource, as this has