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
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
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
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
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
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) =
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
-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
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
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
-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
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
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
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
: 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
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
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
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
[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
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
- 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
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
. 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
-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
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
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
- 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
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
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
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
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
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
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
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
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
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
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
(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
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
-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
: 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
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
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
:
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
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
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
-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,
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
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
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
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
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
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
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
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
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
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
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
.
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
: 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
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
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
. 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
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
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
: 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
- 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
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
: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
- 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
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
...@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
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
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
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
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
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
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
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
-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
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
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
-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
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
-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
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
,
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
/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
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
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
-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.
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
(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
/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
-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
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
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
-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
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
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:
601 - 700 of 1590 matches
Mail list logo