RE: tomcat-jdbc: correct way to create a new separated org.apache.tomcat.jdbc.pool.DataSource from another one

2012-08-07 Thread Martin Gainty
leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > From: german.ferr...@gmail.com > Date: Tue, 7 Aug 2012 20:06:53 -0300 > Subject: tomcat-jdbc: correct way to create a new separated > org.apache.tomcat.jdbc.pool.DataSource from anot

tomcat-jdbc: correct way to create a new separated org.apache.tomcat.jdbc.pool.DataSource from another one

2012-08-07 Thread Germán Ferrari
the PoolConfiguration to PoolProperties, but it doesn't seem safe for the general case. What would be the correct way to create a new separated DataSource from another one having some properties changed? I'm using tomcat-jdbc 7.0.29 as a standalone library. Thank you. Regards, Germán

Re: source for jdbc pool?

2012-06-19 Thread Mark Thomas
On 19/06/2012 18:55, S Ahmed wrote: > Where is the source for the jdbc pool? Can't seem to find it here: > https://github.com/apache/tomcat70 http://svn.apache.org/viewvc/tomcat/trunk/modules/jdbc-pool/ The canonical version of the source code for an ASF project will always be on A

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-06-01 Thread Christopher Schultz
d have to figure out which connection pool to grab before getting a connection or you'd never get connected). Next, you'd have to switch to tomcat-pool because commons-dbcp (the default CP in Tomcat) does not support obtaining pooled connections with credentials. Next, you remove t

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-05-31 Thread S Ahmed
>It would be easier if all databases were hosted by a single instance >of MySQL -- then you could use Tomcat-pool's feature of being able to >provide credentials when obtaining connections from the pool -- and >get the right database. That way, a much smaller number of connections >could be maintai

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-05-30 Thread Pid *
On 31 May 2012, at 00:49, Christopher Schultz wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > André, > > On 5/30/12 6:18 PM, André Warnier wrote: >> Taking the same hypothetical case and figures : >> >> Assuming that you need a total of (1 * 4 connections) = 4 >> connections.

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-05-30 Thread Pid *
On 30 May 2012, at 23:19, "André Warnier" wrote: >> On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz < >> ch...@christopherschultz.net> wrote: > .. >>> >>> If my environment and requirements match yours, you'd need 1 * >>> max_pool_size * 66KiB at peak usage. That's about 640MiB for each

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-05-30 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 André, On 5/30/12 6:18 PM, André Warnier wrote: > Taking the same hypothetical case and figures : > > Assuming that you need a total of (1 * 4 connections) = 4 > connections. Assuming that it takes 10ms to set up one such > connection, and

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-05-30 Thread André Warnier
On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: .. If my environment and requirements match yours, you'd need 1 * max_pool_size * 66KiB at peak usage. That's about 640MiB for each connection you want in 10k pools. For a (uniform) max pool size o

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-05-30 Thread S Ahmed
Chris, Great thanks that is exactly what I was looking for, just to get an idea at this point. And yes it was for mysql. I was thinking one could create a smarter pool, one that created more connections for sites used more often, and less for others. Much appreciated. On Wed, May 30, 2012 at 1

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2012-05-30 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed, On 5/29/12 9:29 AM, S Ahmed wrote: > If my requirement for a hosted application is to give each > customer a separate instance of mysql, I am curious how feasible > that would be. You can certainly do this. > What is the memory footprint for

Re: Where can I find slow query log produced by tomcat-jdbc?

2012-05-16 Thread Vladimir Dymikha
Ok, after upgrade to 7.0.27 I can see in catalina.out May 16, 2012 6:29:13 PM org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport reportSlowQuery WARNING: Slow Query Report SQL=/* named HQL query HotelView.findPriceById */ select minspohote0_.HOTEL as HOTEL27_, minspohote0_.ID_CITY_DEP as I

Where can I find slow query log produced by tomcat-jdbc?

2012-05-16 Thread Vladimir Dymikha
Pool works nice, but I get empty logs/pool.2012-04-06.log No debug messages, no slow query's. Configuration below --- datasource.xml: --- ${catalina.home}/conf/logging.properties: handler

RE: JDBC Connection over VPN

2012-05-07 Thread Sanjeev Sharma
[mailto:sanjeev.sha...@buchanan-edwards.com] Sent: Monday, May 07, 2012 4:04 PM To: Tomcat Users List Subject: RE: JDBC Connection over VPN Telnet seems to connect. -Original Message- From: Saurabh Makol [mailto:saurabh.ma...@gmail.com] Sent: Monday, May 07, 2012 3:50 PM To: Tomcat Users List

RE: JDBC Connection over VPN

2012-05-07 Thread Sanjeev Sharma
Telnet seems to connect. -Original Message- From: Saurabh Makol [mailto:saurabh.ma...@gmail.com] Sent: Monday, May 07, 2012 3:50 PM To: Tomcat Users List Subject: Re: JDBC Connection over VPN Can you run telnet 1521 from command prompt when you VPN into your network? On Mon, May 7

Re: JDBC Connection over VPN

2012-05-07 Thread Saurabh Makol
Can you run telnet 1521 from command prompt when you VPN into your network? On Mon, May 7, 2012 at 3:46 PM, Sanjeev Sharma < sanjeev.sha...@buchanan-edwards.com> wrote: > Using port 1521 in both cases, but it only fails for JDBC. > > -Original Message- > Fro

RE: JDBC Connection over VPN

2012-05-07 Thread Sanjeev Sharma
Using port 1521 in both cases, but it only fails for JDBC. -Original Message- From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Sent: Monday, May 07, 2012 3:43 PM To: 'Tomcat Users List' Subject: RE: JDBC Connection over VPN Could the VPN connection be utlizing the same p

RE: JDBC Connection over VPN

2012-05-07 Thread Propes, Barry L
Sent: Monday, May 07, 2012 2:36 PM To: Tomcat Users List Subject: JDBC Connection over VPN Hi, Not sure if this is a Tomcat issue. When I connect directly to a network and startup my tomcat 7, my JDBC connection to an Oracle 11g network works just fine, but if I tunnel into the same network, JDBC fai

JDBC Connection over VPN

2012-05-07 Thread Sanjeev Sharma
Hi, Not sure if this is a Tomcat issue. When I connect directly to a network and startup my tomcat 7, my JDBC connection to an Oracle 11g network works just fine, but if I tunnel into the same network, JDBC fails to connect to the database. At the same time I'm able to make a connecti

Re: jdbc pool properties

2012-04-06 Thread S Ahmed
me other valid query for your > > DB). > > +1 > > > See the following link for an explanation of those properties. > > > > https://commons.apache.org/dbcp/configuration.html > > - -1 > > This is the wrong documentation for tomcat-pool. You're lo

Re: jdbc pool properties

2012-04-06 Thread Christopher Schultz
t;removeAbandonedTimeout" value="60"/> > > You probably want to add testOnBorrow="true" and > "validationQuery=SELECT 1" (or some other valid query for your > DB). +1 > See the following link for an explanation of those properties. &

Re: Where can I find slow query log produced by tomcat-jdbc?

2012-04-06 Thread Daniel Mikusa
Just saw this too. https://issues.apache.org/bugzilla/show_bug.cgi?id=51237 You might want to check what version you are using. Dan - Original Message - > Pool works nice, but > I get empty logs/pool.2012-04-06.log > No debug messages, no slow query's. > Configuration below > > ---

Re: Where can I find slow query log produced by tomcat-jdbc?

2012-04-06 Thread Daniel Mikusa
- Original Message - > Pool works nice, but > I get empty logs/pool.2012-04-06.log > No debug messages, no slow query's. > Configuration below Maybe you have really fast queries? I believe if you set "threshold=-1", it should log all queries. Not something you'd want to do in production

Where can I find slow query log produced by tomcat-jdbc?

2012-04-06 Thread Vladimir Dymikha
Pool works nice, but I get empty logs/pool.2012-04-06.log No debug messages, no slow query's. Configuration below --- datasource.xml: --- ${catalina.home}/conf/logging.properties: handler

Re: jdbc pool properties

2012-04-05 Thread S Ahmed
Daniel, Your suggestion seems to have worked so far, thanks! testOnBorrow="true" and "validationQuery=SELECT 1" On Wed, Apr 4, 2012 at 8:46 AM, Daniel Mikusa wrote: > > > - Original Message - > > My db connections seem to be lost after an extended period of > > inactivity > > There cou

Re: [JDBC Pool] PoolCleaner creates some sort of memory

2012-04-04 Thread Filip Hanik Mailing Lists
sers List" > Sent: Friday, March 30, 2012 2:05:50 AM > Subject: RE: [JDBC Pool] PoolCleaner creates some sort of memory > > Konstantin Kolinko wrote: > > 2012/3/30 Osipov, Michael : > >> Filip Hanik (mailing lists) wrote: > >>> http://svn.apache.org/viewv

Re: jdbc pool properties

2012-04-04 Thread Filip Hanik Mailing Lists
> From: "Barry L Propes" > To: "Tomcat Users List" > Sent: Wednesday, April 4, 2012 7:53:26 AM > Subject: RE: jdbc pool properties > > There are some databases that do go in and periodically kill off > connections, aside from the Tomcat settings. > > I

RE: jdbc pool properties

2012-04-04 Thread Propes, Barry L
"true" timeBetweenEvictionRunsMillis="-1" minEvictableIdleTimeMillis="28800" -Original Message- From: Daniel Mikusa [mailto:dmik...@vmware.com] Sent: Wednesday, April 04, 2012 7:46 AM To: Tomcat Users List Subject: Re: jdbc pool properties - Original Message - > My d

Re: jdbc pool properties

2012-04-04 Thread Daniel Mikusa
- Original Message - > My db connections seem to be lost after an extended period of > inactivity There could be a number of reasons that this occurs. Perhaps a network issue is causing them to be disconnected or the database may be timing them out. At any rate, it's not likely that

Re: jdbc pool properties

2012-04-04 Thread Pid
On 04/04/2012 12:08, S Ahmed wrote: > My db connections seem to be lost after an extended period of inactivity > (for a web application). And the only way to get the connections to work > again is to restart tomcat. > > My tomcat.jdbc.pool.Datasource settings have: > > > > >

RE: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-30 Thread Osipov, Michael
Konstantin Kolinko wrote: > 2012/3/30 Osipov, Michael : >> Filip Hanik (mailing lists) wrote: >>> http://svn.apache.org/viewvc?view=revision&revision=1306946 >> >> Thanks for the patch, I am having trouble to build from source. I do >> have some test failures, should I ignore them and go on? > >

Re: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-30 Thread Konstantin Kolinko
2012/3/30 Osipov, Michael : > Filip Hanik (mailing lists) wrote: >> http://svn.apache.org/viewvc?view=revision&revision=1306946 > > Thanks for the patch, I am having trouble to build from source. I do have > some test failures, should I ignore them and go on? Please be more specific. In what test

RE: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-30 Thread Osipov, Michael
Filip Hanik (mailing lists) wrote: > http://svn.apache.org/viewvc?view=revision&revision=1306946 Thanks for the patch, I am having trouble to build from source. I do have some test failures, should I ignore them and go on? Another one, can we have a clearer name for the thread, e.g. like the I ha

RE: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-29 Thread Filip Hanik (mailing lists)
http://svn.apache.org/viewvc?view=revision&revision=1306946 > -Original Message- > From: Osipov, Michael [mailto:michael.osi...@siemens.com] > Sent: Thursday, March 29, 2012 1:36 AM > To: Tomcat Users List > Subject: RE: [JDBC Pool] PoolCleaner creates

RE: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-29 Thread Osipov, Michael
Filip Hanik (mailing lists) wrote: > PoolCleaner is a static singleton. The pool cleaner thread will not > be removed until all JDBC pools have been stopped. > So, yes, one application can be the one that starts the thread, but > not necessarily the one that stops it Filip, I

RE: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Filip Hanik (mailing lists)
: SHA1 > > Filip, > > On 3/28/12 12:00 PM, Filip Hanik (mailing lists) wrote: > > PoolCleaner is a static singleton. The pool cleaner thread will not > > be removed until all JDBC pools have been stopped. So, yes, one > > application can be the one that starts the t

Re: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Filip, On 3/28/12 12:00 PM, Filip Hanik (mailing lists) wrote: > PoolCleaner is a static singleton. The pool cleaner thread will not > be removed until all JDBC pools have been stopped. So, yes, one > application can be the one that starts t

RE: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Filip Hanik (mailing lists)
PoolCleaner is a static singleton. The pool cleaner thread will not be removed until all JDBC pools have been stopped. So, yes, one application can be the one that starts the thread, but not necessarily the one that stops it Filip > -Original Message- > From: Osipov, M

RE: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Osipov, Michael
Sources are created in the >> context.xml file. All DataSources are cleaned up (closed) with a >> context.xml Listener. The JDBC Pool is version 7.0.26. >> >> As far as my debug sessions have revealed (with attached VisualVM), >> it does not matter how many apps you

Re: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Konstantin Kolinko
losed) with a context.xml Listener. The JDBC > Pool is version 7.0.26. > > As far as my debug sessions have revealed (with attached VisualVM), it does > not matter how many apps you deploy the PoolCleanTimer thread is created only > once and retained until all apps have been stopp

[JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Osipov, Michael
very likely to create a memory leak. There is some similar thread [1] which had no real result. I am on Tomcat 6.0.35, all DataSources are created in the context.xml file. All DataSources are cleaned up (closed) with a context.xml Listener. The JDBC Pool is version 7.0.26. As far as my debug

Re: tomcat jdbc pool

2012-03-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 S Ahmed, On 3/25/12 6:57 PM, S Ahmed wrote: > Why would you want to use a future? > > Say in a web application, I can't really think of a reason why I > would use the future (asych) connection retrieval pattern. The # > of connections is always fix

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-26 Thread Colin Ingarfield
rn up pool logging to FINE. When a connection attempt times out or fails it logs at this level. 3. Possibly enable connect and TCP read timeouts on the mysql jdbc driver. Per the docs they are 'infinite' by default, but I think lower timeouts would help to detect network/firewall problems mo

Re: jdbc driver location in TC 7

2012-03-26 Thread Torsten Krah
Am Montag, den 26.03.2012, 05:30 -0600 schrieb Terence M. Bandoian: > Apparently, Tomcat (6.0.29) takes care of that if the > driver is located in the Tomcat lib directory but not if it is > located > in web application's lib directory. Tomcat does not take care afaik - the classloader is not t

Re: jdbc driver location in TC 7

2012-03-26 Thread Pid
gt;>>> On 3/23/2012 6:51 PM, Terence M. Bandoian wrote: >>>>>> On 1:59 PM, David kerber wrote: >>>>>>> On 3/23/2012 11:19 AM, Caldarale, Charles R wrote: >>>>>>>>> From: David kerber [mailto:dcker...@verizon.net] >>&

Re: jdbc driver location in TC 7

2012-03-26 Thread Terence M. Bandoian
es R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: jdbc driver location in TC 7 Where is the recommended location for jdbc driver jars in TC7, when I'm using separate CATALINA_HOME and CATALINA_BASE locations? If you look in conf/catalina.properties, you'll see the order

Re: jdbc driver location in TC 7

2012-03-26 Thread Terence M. Bandoian
es R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: jdbc driver location in TC 7 Where is the recommended location for jdbc driver jars in TC7, when I'm using separate CATALINA_HOME and CATALINA_BASE locations? If you look in conf/catalina.properties, you'll see the order

Re: tomcat jdbc pool

2012-03-25 Thread S Ahmed
bottom you call .get(), is that possible? On Sun, Mar 25, 2012 at 6:41 PM, Konstantin Kolinko wrote: > 2012/3/26 S Ahmed : > > Is the jdbc pool somehow married to tomcat or can I use it with other > > containers potentially? ( > > 1. You certainly can use it with other contain

Re: tomcat jdbc pool

2012-03-25 Thread Konstantin Kolinko
2012/3/26 S Ahmed : > Is the jdbc pool somehow married to tomcat or can I use it with other > containers potentially? ( 1. You certainly can use it with other containers. But it depends on Tomcat version of logging library (That is tomcat-juli.jar). You have to copy that jar as well. &

Re: jdbc driver location in TC 7

2012-03-25 Thread Pid *
3/23/2012 11:19 AM, Caldarale, Charles R wrote: >>>>>>> From: David kerber [mailto:dcker...@verizon.net] >>>>>>> Subject: jdbc driver location in TC 7 >>>>>>> Where is the recommended location for jdbc driver jars in TC7, >>>&

Re: jdbc driver location in TC 7

2012-03-24 Thread Terence M. Bandoian
On 1:59 PM, Pid * wrote: On 23 Mar 2012, at 21:59, David Kerber wrote: On 3/23/2012 6:51 PM, Terence M. Bandoian wrote: On 1:59 PM, David kerber wrote: On 3/23/2012 11:19 AM, Caldarale, Charles R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: jdbc driver location in TC 7

Re: jdbc driver location in TC 7

2012-03-24 Thread Pid *
On 23 Mar 2012, at 21:59, David Kerber wrote: > On 3/23/2012 6:51 PM, Terence M. Bandoian wrote: >> On 1:59 PM, David kerber wrote: >>> On 3/23/2012 11:19 AM, Caldarale, Charles R wrote: >>>>> From: David kerber [mailto:dcker...@verizon.net] >>&g

Re: jdbc driver location in TC 7

2012-03-23 Thread David Kerber
On 3/23/2012 6:51 PM, Terence M. Bandoian wrote: On 1:59 PM, David kerber wrote: On 3/23/2012 11:19 AM, Caldarale, Charles R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: jdbc driver location in TC 7 Where is the recommended location for jdbc driver jars in TC7, when I&#

Re: jdbc driver location in TC 7

2012-03-23 Thread Terence M. Bandoian
On 1:59 PM, David kerber wrote: On 3/23/2012 11:19 AM, Caldarale, Charles R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: jdbc driver location in TC 7 Where is the recommended location for jdbc driver jars in TC7, when I'm using separate CATALINA_HOME and CATALINA

Re: jdbc driver location in TC 7

2012-03-23 Thread David kerber
On 3/23/2012 11:19 AM, Caldarale, Charles R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: jdbc driver location in TC 7 Where is the recommended location for jdbc driver jars in TC7, when I'm using separate CATALINA_HOME and CATALINA_BASE locations? If you look in

RE: jdbc driver location in TC 7

2012-03-23 Thread Caldarale, Charles R
> From: David kerber [mailto:dcker...@verizon.net] > Subject: jdbc driver location in TC 7 > Where is the recommended location for jdbc driver jars in TC7, > when I'm using separate CATALINA_HOME and CATALINA_BASE locations? If you look in conf/catalina.properties, you'll

jdbc driver location in TC 7

2012-03-23 Thread David kerber
Kind of related to the upgrade issue I ran into yesterday: Where is the recommended location for jdbc driver jars in TC7, when I'm using separate CATALINA_HOME and CATALINA_BASE locations? If it makes a difference, I am not using tomcat's connection pooling; it's handled

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-22 Thread Filip Hanik Mailing Lists
s required. You could try 1. Use IP instead of host name in your jdbc URL 2. Configure the JRE to not cache dns lookups, (network.properties) The error you see tells you that: 1. The pool doesn't have any idle established connections idle=0 2. The pool doesn't have any connections used b

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-22 Thread Colin Ingarfield
up in the logs. 5. Restore vpn connection 6. Check if pool creates new connections, which it does not. I also upgraded to the latest pool available in maven central: tomcat-jdbc-7.0.26.jar I understand this could still be a connection leak in my application. But the new pool version logs an

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-22 Thread Filip Hanik Mailing Lists
there is a loop somewhere that when it fails it just retries and retries, logAbandoned will show that though. Filip - Original Message - > From: "Colin Ingarfield" > To: "Tomcat Users List" > Sent: Thursday, March 22, 2012 8:06:14 AM > Subject: Re: how t

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-22 Thread Colin Ingarfield
iginal Message - > > From: "Colin Ingarfield" > > To: "Tomcat Users List" > > Sent: Wednesday, March 21, 2012 10:11:43 AM > > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat > 6.0.32) > > > > I added the 3 abandon

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-22 Thread Colin Ingarfield
ng your max connection pool size to > "1": you'll find potential deadlocks that way, too. > > > http://blog.christopherschultz.net/index.php/2009/03/16/properly-handling-pooled-jdbc-connections/ > > - -chris > -BEGIN PGP SIGNATURE- > Version: GnuPG/MacGPG

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-22 Thread Christopher Schultz
ion would have failed > quickly if all the connections we're being incorrectly held up. In development, I recommend setting your max connection pool size to "1": you'll find potential deadlocks that way, too. http://blog.christopherschultz.net/index.php/2009/03/16/prop

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Filip Hanik Mailing Lists
> To: "Tomcat Users List" > Sent: Wednesday, March 21, 2012 10:11:43 AM > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32) > > I added the 3 abandoned settings but I don't see any indication in > the > tomcat log that connections are

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Colin Ingarfield
tries the operation. And that is the only way to get around the > problem (assuming my assumption is correct) > > > Filip > - Original Message - > > From: "Colin Ingarfield" > > To: users@tomcat.apache.org > > Sent: Wednesday, March 21, 2012 9:30:4

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Filip Hanik Mailing Lists
g > Sent: Wednesday, March 21, 2012 9:30:46 AM > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32) > > My configuration: > > name="jdbc/cdb.mysql" > defaultAutoCommit="false" > driverClassName="com.mysql.j

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Colin Ingarfield
My configuration: I have testOnBorrow and validationQuery set as you suggest, so I do not think that is the issue. Thanks, Colin

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Filip Hanik Mailing Lists
- Original Message - > From: "Colin Ingarfield" > To: users@tomcat.apache.org > Sent: Wednesday, March 21, 2012 6:25:54 AM > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32) > > iirc I copied the version number from th

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Filip Hanik Mailing Lists
@tomcat.apache.org > Sent: Wednesday, March 21, 2012 6:23:02 AM > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32) > > Hello Filip, > > Over the weekend my application appears to have lost connectivity to > its > MySQL server. At that point in my

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Colin Ingarfield
>> Hello, >> >> I'm using the new Tomcat jdbc pool (1.1.0.1) with Tomcat 6.0.32, Ubuntu >> x86_64. I would like to increase the logging from the pool to try and >> chase down connection timeouts. > >Where your "1.1.0.1" comes from? >

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-21 Thread Colin Ingarfield
on pool and try to see what's going on. I couldn't find any log output from the pool in my logs or in the Tomcat logs directory. My application uses Spring JDBC and Spring's @Transaction annotations so my code does not directly interact with the DataSource or the jdbc Connections. I

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-20 Thread Konstantin Kolinko
2012/3/19 Colin Ingarfield : > Hello, > > I'm using the new Tomcat jdbc pool (1.1.0.1) with Tomcat 6.0.32, Ubuntu > x86_64.  I would like to increase the logging from the pool to try and > chase down connection timeouts. Where your "1.1.0.1" comes from? It is not

RE: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-20 Thread Filip Hanik (mailing lists)
Colin Ingarfield [mailto:colin...@gmail.com] > Sent: Monday, March 19, 2012 1:51 PM > To: users@tomcat.apache.org > Subject: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32) > > Hello, > > I'm using the new Tomcat jdbc pool (1.1.0.1) with Tomcat 6.0.32, Ubuntu >

how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

2012-03-19 Thread Colin Ingarfield
Hello, I'm using the new Tomcat jdbc pool (1.1.0.1) with Tomcat 6.0.32, Ubuntu x86_64. I would like to increase the logging from the pool to try and chase down connection timeouts. I added the following line to $CATALINA_BASE/conf/logging.properties: org.apache.tomcat.jdbc.pool.level=FINE

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-10 Thread Jonathan Hodges
ConnectionHandler.** >> process(AbstractProtocol.java:**579) >> at >> org.apache.tomcat.util.net.**JIoEndpoint$SocketProcessor.** >> run(JIoEndpoint.java:307) >> at >> java.util.concurrent.**ThreadPoolExecutor$Worker.** >> runTask(ThreadPool

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-10 Thread Filip Hanik - Dev Lists
little more detail we have enabled all the new Manager roles while we test this issue. Any ideas? Thanks in advance, Jonathan -- View this message in context: http://tomcat.10.n6.nabble.com/What-is-the-best-way-to-view-Tomcat-JDBC-pool-properties-in-Tomcat-7

Re: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-10 Thread Filip Hanik - Dev Lists
On 3/3/2012 10:50 AM, Brooke Hedrick wrote: On Mar 3, 2012 11:48 AM, "Brooke Hedrick" wrote: On Mar 3, 2012 11:35 AM, "Caldarale, Charles R"< chuck.caldar...@unisys.com> wrote: From: Brooke Hedrick [mailto:brooke.t.hedr...@gmail.com] Subject: Re: [Tomcat JDBC Pool

RE: [OT] Using tomcat7-maven-plugin- 2.0-beta-1: java.lang.RuntimeException: Name jdbc is not bound in this Context

2012-03-09 Thread Guofeng Zhang
Subject: Re: [OT] Using tomcat7-maven-plugin- 2.0-beta-1: java.lang.RuntimeException: Name jdbc is not bound in this Context -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Guofeng, On 3/7/12 5:32 AM, Guofeng Zhang wrote: > name="jdbc/iviewDS" testQuery="select count(*) from T_ROLE&q

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Amit, On 3/8/12 11:55 AM, Amit wrote: > Enabling debug level would add some extra handling > > 1. We use slf4j & logback as our logging framework & tomcat uses > jul logging. We would have to add jul-to-slf4j.jar to direct the > jul messages to logba

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread hodgesz
Thanks guys. I will file a new bug with the details you provided about it exposing too many get methods. -- View this message in context: http://tomcat.10.n6.nabble.com/What-is-the-best-way-to-view-Tomcat-JDBC-pool-properties-in-Tomcat-7-tp4557182p4559731.html Sent from the Tomcat - User

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread Christopher Schultz
alled by the MBeanDumper, and thus probably should >> be exposed as an attribute through an MBean. >> > You meant "should not be exposed", right ? Yes, I did. I checked the mbeans-deacriptor in trunk and there seems to be no mention of "connection" or "XAC

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread Daniel Mikusa
;> I am using tomcat-jdbc.jar and tomcat-juli.jar from version > >>>> 7.0.26. > >>>> > >>>>> I don't see any place in setupConnection where an exception is > >>>>> swallowed, do you? > >>>>> > >>&g

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread Amit
SIGNED MESSAGE- >>> Hash: SHA1 >>> >>> Amit, >>> >>> On 3/7/12 12:12 AM, amit shah wrote: >>>> I am using tomcat-jdbc.jar and tomcat-juli.jar from version >>>> 7.0.26. >>>> >>>>> I don't see

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread André Warnier
Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonathan, On 3/8/12 10:19 AM, hodgesz wrote: Well the exact same Spring code doesn't throw an exception with 6.0.29 version of Tomcat. See Rainer's note in the bug you filed: those properties didn't exist in 6.0.x. I h

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonathan, On 3/8/12 10:19 AM, hodgesz wrote: > Well the exact same Spring code doesn't throw an exception with > 6.0.29 version of Tomcat. See Rainer's note in the bug you filed: those properties didn't exist in 6.0.x. > I have already entered a bug

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread hodgesz
n't need it now so that doesn't seem like the solution here. -Jonathan -- View this message in context: http://tomcat.10.n6.nabble.com/What-is-the-best-way-to-view-Tomcat-JDBC-pool-properties-in-Tomcat-7-tp4557182p4558561.html Sent from the Tomcat - User mailing l

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonathan, So, ConnectionPool.getProxyConstructor definitely makes a decision about what interfaces to expose when generating a proxy for a PooledConnection (sorry for the word-wrapping): public Constructor getProxyConstructor(boolean xa) throws N

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread Christopher Schultz
a bug to me. The problem is I'm not sure if that's a bug in Tomcat's code or in Spring's code, since both code is involved in both stack traces. I would probably look first in the jdbc-pool code to see if a Proxy is being created that does not include all the proper interfaces (ob

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread Daniel Mikusa
gt; On 3/7/12 12:12 AM, amit shah wrote: > > > I am using tomcat-jdbc.jar and tomcat-juli.jar from version > > > 7.0.26. > > > > > >> I don't see any place in setupConnection where an exception is > > >> swallowed, do you? > &

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-08 Thread hodgesz
) ... 30 more To add a little more detail we have enabled all the new Manager roles while we test this issue. Any ideas? Thanks in advance, Jonathan -- View this message in context: http://tomcat.10.n6.nabble.com/What-is-the-best-way-to-view-Tomcat-JDBC

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread amit shah
version > > 7.0.26. > > > >> I don't see any place in setupConnection where an exception is > >> swallowed, do you? > >> > >> > http://svn.apache.org/viewvc/tomcat/trunk/modules/jdbc-pool/src/main/java/org/apache/tomcat/jdbc/pool/Conne

Re: What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-07 Thread Pid *
On 8 Mar 2012, at 02:26, hodgesz wrote: > In 6.0.29 we used the Spring MBeanExporter to export the Tomcat JDBC pool > properties. > > We are still able to view them with this approach in JConsole and using the > JMXProxy Servlet with Tomcat 7. > > However since Tomcat JDBC p

What is the best way to view Tomcat JDBC pool properties in Tomcat 6?

2012-03-07 Thread hodgesz
In 6.0.29 we used the Spring MBeanExporter to export the Tomcat JDBC pool properties. We are still able to view them with this approach in JConsole and using the JMXProxy Servlet with Tomcat 7. However since Tomcat JDBC pool is part of Tomcat 7 are its properties exposed without using the

Re: [OT] Using tomcat7-maven-plugin- 2.0-beta-1: java.lang.RuntimeException: Name jdbc is not bound in this Context

2012-03-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Guofeng, On 3/7/12 5:32 AM, Guofeng Zhang wrote: > name="jdbc/iviewDS" testQuery="select count(*) from T_ROLE" You might want to use a simper testQuery (like "SELECT 1 FROM DUAL", for instance). Some RDBMS engines

Re: JDBC Pool - Error handling during connection creation

2012-03-07 Thread Christopher Schultz
t; http://svn.apache.org/viewvc/tomcat/trunk/modules/jdbc-pool/src/main/java/org/apache/tomcat/jdbc/pool/ConnectionPool.java?view=markup > >> > Have a look at the public boolean validate(int > validateAction,String sql) method in PooledConnection class line no > - 445. > The

Re: Using tomcat7-maven-plugin- 2.0-beta-1: java.lang.RuntimeException: Name jdbc is not bound in this Context

2012-03-07 Thread Olivier Lamy
file I mean nothing in src\main\tomcatconf ) ? Thanks, 2012/3/7 Guofeng Zhang : > Hi, > > I try tomcat7-maven-plugin/2.0-beta-1. When I use "mvn tomcat7:run" to launch > my app, I got: >  javax.naming.NameNotFoundException: Name jdbc is not bound in this Context > &g

Using tomcat7-maven-plugin- 2.0-beta-1: java.lang.RuntimeException: Name jdbc is not bound in this Context

2012-03-07 Thread Guofeng Zhang
Hi, I try tomcat7-maven-plugin/2.0-beta-1. When I use "mvn tomcat7:run" to launch my app, I got: javax.naming.NameNotFoundException: Name jdbc is not bound in this Context I configured the datatsource as global naming datasource in server.xml, The server.xml is copied t

Re: [Tomcat JDBC Pool] Close pooled connections via JMX

2012-03-06 Thread Chema
> There's nothing like chasing your tail for a few days on a mailing list. > > - -chris ok, ok ...it was my fault ... sorry :-/ Regards - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mai

Re: JDBC Pool - Error handling during connection creation

2012-03-06 Thread amit shah
Comments below. Thanks, Amit. On Tue, Mar 6, 2012 at 8:07 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Amit, > > On 3/6/12 4:46 AM, amit shah wrote: > > Hello, I am using the tomcat

Re: JDBC Pool - Error handling during connection creation

2012-03-06 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Amit, On 3/6/12 4:46 AM, amit shah wrote: > Hello, I am using the tomcat jdbc pool independently in my > application and frequently I faced a NullPointerException with the > below stack trace >

<    2   3   4   5   6   7   8   9   10   11   >