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
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: 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 another one To: users

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 ASF hardware. i.e

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

2012-06-01 Thread Christopher Schultz
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 the database name from the JDBC URL (or maybe change it to something everyone can access

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

2012-05-31 Thread Pid *
On 30 May 2012, at 23:19, André Warnier a...@ice-sa.com 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-31 Thread Pid *
On 31 May 2012, at 00:49, Christopher Schultz ch...@christopherschultz.net 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) =

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 maintained

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 a

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

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 of

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 that

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: bean id=dataSourceOnline class=org.apache.tomcat.jdbc.pool.DataSource destroy-method=close

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

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 connection

RE: JDBC Connection over VPN

2012-05-07 Thread Propes, Barry L
: 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 fails

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 port Tomcat

Re: JDBC Connection over VPN

2012-05-07 Thread Saurabh Makol
Can you run telnet DatahbaseIpaddress 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- From: Propes, Barry

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 DatahbaseIpaddress 1521 from command prompt when you VPN into your network

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

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: bean id=dataSourceOnline class=org.apache.tomcat.jdbc.pool.DataSource destroy-method=close

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, but

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: jdbc pool properties

2012-04-06 Thread Christopher Schultz
. You're looking for http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html On the other hand, there was no mention of a Tomcat version, what type of pool is actually being used (I inferred tomcat-pool from the subject line as well as the use of tomcat.jdbc.pool.DataSource) and the use of property

Re: jdbc pool properties

2012-04-06 Thread S Ahmed
-pool. You're looking for http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html On the other hand, there was no mention of a Tomcat version, what type of pool is actually being used (I inferred tomcat-pool from the subject line as well as the use of tomcat.jdbc.pool.DataSource) and the use

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 dmik...@vmware.com wrote: - Original Message - My db connections seem to be lost after an extended period of inactivity

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: property name=maxActive

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 Propes, Barry L
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 db connections seem to be lost after an extended

Re: jdbc pool properties

2012-04-04 Thread Filip Hanik Mailing Lists
L Propes barry.l.pro...@citi.com To: Tomcat Users List users@tomcat.apache.org 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. In addition

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

2012-04-04 Thread Filip Hanik Mailing Lists
List users@tomcat.apache.org 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 michael.osi...@siemens.com: Filip Hanik (mailing lists) wrote: http://svn.apache.org/viewvc?view

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=revisionrevision=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

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

2012-03-30 Thread Konstantin Kolinko
2012/3/30 Osipov, Michael michael.osi...@siemens.com: Filip Hanik (mailing lists) wrote: http://svn.apache.org/viewvc?view=revisionrevision=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

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

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

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 have already noticed

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

2012-03-29 Thread Filip Hanik (mailing lists)
http://svn.apache.org/viewvc?view=revisionrevision=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 some sort of memory

[JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Osipov, Michael
it. This is 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: [JDBC Pool] PoolCleaner creates some sort of memory

2012-03-28 Thread Konstantin Kolinko
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 stopped or removed. This makes Tomcat think

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

2012-03-28 Thread Osipov, Michael
(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 deploy the PoolCleanTimer thread is created only once and retained until all apps have been stopped or removed

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, Michael

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 the thread

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 thread, but not necessarily the one

Re: jdbc driver location in TC 7

2012-03-26 Thread Terence M. Bandoian
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 conf/catalina.properties, you'll

Re: jdbc driver location in TC 7

2012-03-26 Thread Terence M. Bandoian
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 conf/catalina.properties, you'll

Re: jdbc driver location in TC 7

2012-03-26 Thread Pid
: 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_BASE

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 the

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

2012-03-26 Thread Colin Ingarfield
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 more quickly. And I'm

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 fixed,

Re: jdbc driver location in TC 7

2012-03-25 Thread Pid *
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 in which

Re: tomcat jdbc pool

2012-03-25 Thread Konstantin Kolinko
2012/3/26 S Ahmed sahmed1...@gmail.com: 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

Re: tomcat jdbc pool

2012-03-25 Thread S Ahmed
call .get(), is that possible? On Sun, Mar 25, 2012 at 6:41 PM, Konstantin Kolinko knst.koli...@gmail.comwrote: 2012/3/26 S Ahmed sahmed1...@gmail.com: 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

Re: jdbc driver location in TC 7

2012-03-24 Thread Pid *
On 23 Mar 2012, at 21:59, David Kerber dcker...@verizon.net 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 Terence M. Bandoian
On 1:59 PM, Pid * wrote: On 23 Mar 2012, at 21:59, David Kerberdcker...@verizon.net 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

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 in my app. I

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 see the order in which

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 conf

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_BASE

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'm

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

2012-03-22 Thread Christopher Schultz
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/properly-handling-pooled-jdbc-connections/ - -chris

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

2012-03-22 Thread Colin Ingarfield
. http://blog.christopherschultz.net/index.php/2009/03/16/properly-handling-pooled-jdbc-connections/ - -chris -BEGIN PGP SIGNATURE- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

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

2012-03-22 Thread Colin Ingarfield
: 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 being abandoned. I also made the max pool size pretty small.. my

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

2012-03-22 Thread Filip Hanik Mailing Lists
debug logging for Tomcat jdbc pool (Tomcat 6.0.32) Ah, Wireshark. My friend calls it the universal debugger. :) I will set the validation interval to 1 and keep an eye on the network to see what's going on. I may also install MySql locally so I can kill it easily to try and simulation

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

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

2012-03-22 Thread Filip Hanik Mailing Lists
. 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 by other threads busy

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

2012-03-21 Thread Colin Ingarfield
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 suspect a misconfiguration

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? It is not an official release. Released versions of jdbc-pool come

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

2012-03-21 Thread Filip Hanik Mailing Lists
: 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 logs I see these errors: 2012-03-16 18:25:18,248 ERROR

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 colin...@gmail.com 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 the tomcat-jdbc.jar/META-INF

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

2012-03-21 Thread Colin Ingarfield
My configuration: Resource auth=Container name=jdbc/cdb.mysql defaultAutoCommit=false driverClassName=com.mysql.jdbc.Driver factory=org.apache.tomcat.jdbc.pool.DataSourceFactory url=jdbc:mysql://X.com/_dev?sessionVariables=TRANSACTION ISOLATION LEVEL READ COMMITTED

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

2012-03-21 Thread Filip Hanik Mailing Lists
:46 AM Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32) My configuration: Resource auth=Container name=jdbc/cdb.mysql defaultAutoCommit=false driverClassName=com.mysql.jdbc.Driver factory=org.apache.tomcat.jdbc.pool.DataSourceFactory url

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

2012-03-21 Thread Colin Ingarfield
- Original Message - From: Colin Ingarfield colin...@gmail.com To: users@tomcat.apache.org 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: Resource auth=Container name=jdbc/cdb.mysql

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

2012-03-21 Thread Filip Hanik Mailing Lists
users@tomcat.apache.org 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 being abandoned. I also made the max pool

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

2012-03-20 Thread Filip Hanik (mailing lists)
...@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 x86_64. I would like to increase the logging from the pool

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 colin...@gmail.com: 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 an official release

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: [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 Hedrickbrooke.t.hedr...@gmail.com 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] Close

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

2012-03-10 Thread Filip Hanik - Dev Lists
password= roles=admin-gui,admin-script,manager-gui,manager-script,manager-jmx,manager-status/ 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-tp4557182p4558028.html Sent

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

2012-03-10 Thread Jonathan Hodges
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-**tp4557182p4558028.htmlhttp://tomcat.10.n6.nabble.com/What-is-the-best-way-to-view-Tomcat-JDBC-pool-properties

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: Resource auth=Container maxPoolSize=100 minPoolSize=10 name=jdbc/iviewDS

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread amit shah
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/ConnectionPool.java?view=markup Have a look at the public boolean validate(int validateAction,String sql) method

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

2012-03-08 Thread hodgesz
-status/ user username= password= roles=admin-gui,admin-script,manager-gui,manager-script,manager-jmx,manager-status/ 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

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread Daniel Mikusa
and tomcat-juli.jar from 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/ConnectionPool.java?view=markup Have a look

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

2012-03-08 Thread Christopher Schultz
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getXAConnection(DataSourceProxy.java:134) It looks like 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

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

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

2012-03-08 Thread hodgesz
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 list archive at Nabble.com

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 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

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread 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 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

Re: JDBC Pool - Error handling during connection creation

2012-03-08 Thread Daniel Mikusa
/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 validate method ignores any exception which is thrown

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

2012-03-08 Thread Christopher Schultz
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 XAConnection as attributes. I'll have to configure a jdbc-pool locally and take a look. - -chris -BEGIN PGP SIGNATURE- Version

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: 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 logback.

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, GlobalNamingResources Resource auth

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
(and not with a server.xml file I mean nothing in src\main\tomcatconf ) ? Thanks, 2012/3/7 Guofeng Zhang guof...@radvision.com: 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

Re: JDBC Pool - Error handling during connection creation

2012-03-07 Thread Christopher Schultz
/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 validate method ignores any exception which is thrown while validating

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: Resource auth=Container maxPoolSize=100 minPoolSize=10 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

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

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 hodg...@gmail.com 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 pool is part

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 null

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 jdbc pool independently in my application

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-mail:

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