Re: Tomcat JDBC CP: Exponential backoff?

2023-01-27 Thread Christopher Schultz
Thomas, On 1/26/23 03:00, Thomas Meyer wrote: Am 18. Januar 2023 23:20:29 MEZ schrieb Christopher Schultz : Thomas, On 1/17/23 13:33, Thomas Meyer wrote: Does Tomcat's CP support exponential backoff in case DB is unavailable for some reason? I didn't find anything in the documentation in

Re: Tomcat JDBC CP: Exponential backoff?

2023-01-26 Thread Thomas Meyer
Am 18. Januar 2023 23:20:29 MEZ schrieb Christopher Schultz : >Thomas, > >On 1/17/23 13:33, Thomas Meyer wrote: >> Does Tomcat's CP support exponential backoff in case DB is unavailable for >> some reason? >> I didn't find anything in the documentation in this regards. > >I don't think is supp

Re: Tomcat JDBC CP: Exponential backoff?

2023-01-18 Thread Christopher Schultz
Thomas, On 1/17/23 13:33, Thomas Meyer wrote: Does Tomcat's CP support exponential backoff in case DB is unavailable for some reason? I didn't find anything in the documentation in this regards. I don't think is supports any such thing. What would be the purpose of exponential back-off... do

Tomcat JDBC CP: Exponential backoff?

2023-01-17 Thread Thomas Meyer
Hi, Does Tomcat's CP support exponential backoff in case DB is unavailable for some reason? I didn't find anything in the documentation in this regards. Mfg Thomas -- Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.

Re: Tomcat jdbc connections

2022-01-26 Thread Phil Steitz
Christopher Schultz Sent: 24 January 2022 22:42 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/23/22 09:17, Alan F wrote: Can I just follow up here what would be the next steps how would I go about capturing the root cause of these very short connection times t

Re: Tomcat jdbc connections

2022-01-25 Thread Christopher Schultz
Schultz Sent: 24 January 2022 22:42 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/23/22 09:17, Alan F wrote: Can I just follow up here what would be the next steps how would I go about capturing the root cause of these very short connection times to Oracle from To

RE: [External] Re: Tomcat jdbc connections

2022-01-25 Thread Scott,Tim
> Would it be along the lines of Wireshark or TCP dump to see what's > occurring as I gather this won't be captured in tomcat logging via > Catalina.out? Or can it be. Have you explored Oracle listener / client tracing? Ref: https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF3

RE: Tomcat jdbc connections

2022-01-25 Thread Alan F
s due to connections being used! -Original Message- From: Christopher Schultz Sent: 24 January 2022 22:42 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/23/22 09:17, Alan F wrote: > Can I just follow up here what would be the next steps how would I go

Re: Tomcat jdbc connections

2022-01-24 Thread Christopher Schultz
nk dbcp does that kind of thing, so you'd have to crank-up the logging level on that application and/or Tomcat instance to see what's happening with the connection pool. Hope that helps, -chris -Original Message- From: Phil Steitz Sent: 21 January 2022 17:50 To: users@

RE: Tomcat jdbc connections

2022-01-23 Thread Alan F
ogging via Catalina.out? Or can it be. -Original Message- From: Phil Steitz Sent: 21 January 2022 17:50 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections On 1/21/22 9:28 AM, Alan F wrote: > Ok thanks Phil ok I checked other connections in the same host and see

RE: Tomcat jdbc connections

2022-01-21 Thread Alan F
Thanks for your input Phil! Arghh will keep looking. -Original Message- From: Phil Steitz Sent: 21 January 2022 17:50 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections On 1/21/22 9:28 AM, Alan F wrote: > Ok thanks Phil ok I checked other connections in the same h

Re: Tomcat jdbc connections

2022-01-21 Thread Phil Steitz
al Message- From: Phil Steitz Sent: 21 January 2022 16:10 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections On 1/21/22 8:19 AM, Alan F wrote: Thanks John, Here is an example of a connection below I see timeBetweenEvictionRunsMillis but not maxConnLifetimeMillis if the server

RE: Tomcat jdbc connections

2022-01-21 Thread Alan F
inutes! And diff is identical apart from Cluster ips. -Original Message- From: Phil Steitz Sent: 21 January 2022 16:10 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections On 1/21/22 8:19 AM, Alan F wrote: > Thanks John, > > Here is an exampl

Re: Tomcat jdbc connections

2022-01-21 Thread Phil Steitz
2022 14:50 To: users@tomcat.apache.org Subject: RE: Tomcat jdbc connections Alan, -Original Message- From: Alan F Sent: Friday, January 21, 2022 6:53 AM To: Tomcat Users List Subject: RE: Tomcat jdbc connections Hi Christopher Thanks for your time here. You mean like, a connection is

Re: Tomcat jdbc connections

2022-01-21 Thread Phil Steitz
-Original Message- From:john.e.gr...@wellsfargo.com.INVALID Sent: 21 January 2022 14:50 To:users@tomcat.apache.org Subject: RE: Tomcat jdbc connections Alan, -Original Message- From: Alan F Sent: Friday, January 21, 2022 6:53 AM To: Tomcat Users List Subject: RE: Tomcat jdbc

RE: Tomcat jdbc connections

2022-01-21 Thread Alan F
? -Original Message- From: john.e.gr...@wellsfargo.com.INVALID Sent: 21 January 2022 14:50 To: users@tomcat.apache.org Subject: RE: Tomcat jdbc connections Alan, > -Original Message- > From: Alan F > Sent: Friday, January 21, 2022 6:53 AM > To: Tomcat Users List &

RE: Tomcat jdbc connections

2022-01-21 Thread John.E.Gregg
Alan, > -Original Message- > From: Alan F > Sent: Friday, January 21, 2022 6:53 AM > To: Tomcat Users List > Subject: RE: Tomcat jdbc connections > > Hi Christopher > > Thanks for your time here. > > You mean like, a connection is made, no q

RE: Tomcat jdbc connections

2022-01-21 Thread Alan F
: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/20/22 09:33, Alan F wrote: > I have an issue with connections on Tomcat9 Oracle showing connections > made for about 2seconds then dropped again. Is this normal when the > server is not being used? You mean like

Re: Tomcat jdbc connections

2022-01-20 Thread Christopher Schultz
Alan, On 1/20/22 09:33, Alan F wrote: I have an issue with connections on Tomcat9 Oracle showing connections made for about 2seconds then dropped again. Is this normal when the server is not being used? You mean like, a connection is made, no queries are executed, and then the connection is ter

Re: Tomcat jdbc connections

2022-01-20 Thread Mark Thomas
On 20/01/2022 14:33, Alan F wrote: I have an issue with connections on Tomcat9 Oracle showing connections made for about 2seconds then dropped again. Is this normal when the server is not being used? Seems unlikely. Can you provide the DataSource configuration? Remember to obfuscate any sen

Tomcat jdbc connections

2022-01-20 Thread Alan F
I have an issue with connections on Tomcat9 Oracle showing connections made for about 2seconds then dropped again. Is this normal when the server is not being used? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org F

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

2021-08-13 Thread Christopher Schultz
Sampath, On 8/12/21 07:02, Sampath Rajapakshe wrote: Hi Chris, Thanks for the detailed explanation, yes, we tried with abandoned true logs and found an issue with our code base as well. It seems we had a case where a single thread creates a new connection and before closing that connection crea

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

2021-08-12 Thread Sampath Rajapakshe
Hi Chris, Thanks for the detailed explanation, yes, we tried with abandoned true logs and found an issue with our code base as well. It seems we had a case where a single thread creates a new connection and before closing that connection creates a new connection and closes that new connection and

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

2021-08-11 Thread Christopher Schultz
Sampath, On 8/9/21 01:45, Sampath Rajapakshe wrote: In our case, we know the reason for the pool exhausted behaviour, there are slow queries and also due to high TPS where pool is not enough. So we are expected to get pool exhaustion with current configurations. Ok. What we wanted to verify w

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

2021-08-08 Thread Sampath Rajapakshe
Hi Chris, Thanks for the clarification. I've gone through the blog, In our case, we know the reason for the pool exhausted behaviour, there are slow queries and also due to high TPS where pool is not enough. So we are expected to get pool exhaustion with current configurations. What we wanted to v

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

2021-08-06 Thread Christopher Schultz
Sampath, On 8/6/21 08:37, Sampath Rajapakshe wrote: Hi All, In my local setup before pool exhaustion exception is thrown, all the connections seem to be in freezed and when checking processList in mysql, those connections are in sleep state and doesn't execute any queries. After waiting for max

Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

2021-08-06 Thread Sampath Rajapakshe
Hi All, In my local setup before pool exhaustion exception is thrown, all the connections seem to be in freezed and when checking processList in mysql, those connections are in sleep state and doesn't execute any queries. After waiting for maxWait period the pool exhausted exception gets thrown an

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-16 Thread Christopher Schultz
> Hello, > > > > > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call commit() or rollback() and finally

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-15 Thread My Subs
> > > > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) > > on a connection obtained from a Tomcat JDBC Connection Pool. Then I do > > some stuff with the connection, call commit() or rollback() and final

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-15 Thread Christopher Schultz
n 12/03/2021 03:57, My Subs wrote: > > > > Hello, > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-13 Thread My Subs
> On 12/03/2021 03:57, My Subs wrote: > > > > Hello, > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a > > connection obtained from a Tomcat JDBC Connection Pool. Then I do some > > stuff with the conne

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-12 Thread Christopher Schultz
Alex, On 3/12/21 16:32, My Subs wrote: On Fri, 12 Mar 2021 02:35:27 -0500 Mark Thomas wrote > On 12/03/2021 03:57, My Subs wrote: > > Hello, > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a T

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-12 Thread My Subs
On Fri, 12 Mar 2021 02:35:27 -0500 Mark Thomas wrote > On 12/03/2021 03:57, My Subs wrote: > > Hello, > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a > > connection obtained from a Tomcat JDBC Connection Pool. The

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-11 Thread Mark Thomas
On 12/03/2021 03:57, My Subs wrote: Hello, I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call commit() or rollback() and finally call close() on it without ever ca

Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-11 Thread My Subs
Hello, I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call commit() or rollback() and finally call close() on it without ever calling setAutocommit(true). What wil

Re: Tomcat JDBC Connection Pool question

2021-02-11 Thread xcorpius
Thanks Phil! Mensaje original On 11 feb. 2021 2:54, Phil Steitz escribió: > See maxWait for Tomcat JDBC Pool > > https://tomcat.apache.org/tomcat-9.0-doc/jdbc-pool.html > > Or for the default dbcp pool, maxWaitMillis > > https://commons.apache.or

Re: Tomcat JDBC Connection Pool question

2021-02-10 Thread Phil Steitz
See maxWait for Tomcat JDBC Pool https://tomcat.apache.org/tomcat-9.0-doc/jdbc-pool.html Or for the default dbcp pool, maxWaitMillis https://commons.apache.org/proper/commons-dbcp/configuration.html Phil On 2/10/21 3:22 PM, xcorpius wrote: Hi Chris! ConnectionReserveTimeoutSeconds: The

Re: Tomcat JDBC Connection Pool question

2021-02-10 Thread xcorpius
Units: seconds Default: 10 Minimum: -1 Maximum: 231-1 Thanks, Xcorpius Mensaje original On 10 feb. 2021 23:13, Christopher Schultz escribió: > Xcorpius, > > On 2/10/21 07:15, xcorpius wrote: >> Is there a parameter in "Tomcat JDBC Connection Pool&quo

Re: Tomcat JDBC Connection Pool question

2021-02-10 Thread Christopher Schultz
Xcorpius, On 2/10/21 07:15, xcorpius wrote: Is there a parameter in "Tomcat JDBC Connection Pool" 9 equivalent to the ConnectionReserveTimeoutSeconds parameter from Weblogic? Maybe. What does that parameter actually d

Tomcat JDBC Connection Pool question

2021-02-10 Thread xcorpius
Hi! Is there a parameter in "Tomcat JDBC Connection Pool" 9 equivalent to the ConnectionReserveTimeoutSeconds parameter from Weblogic? Thanks, Xcorpius

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-31 Thread Felix Schumacher
   minIdle="10" >>>>>    maxWait="3" >>>>>    timeBetweenEvictionRunsMillis="5000" >>>>>    minEvictableIdleTimeMillis="6" >>>>>    removeAbandoned

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-31 Thread Phil Steitz
testWhileIdle="true" testOnBorrow="true" testOnReturn="false" validationQuery="/* ping */ SELECT 1" validationInterval="3" jmxEnabled="true" jdbcInter

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-31 Thread Felix Schumacher
000" >>> timeBetweenEvictionRunsMillis="5000" >>> minEvictableIdleTimeMillis="6" >>> removeAbandonedTimeout="600" >>> removeAbandoned="true" >>>

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-31 Thread Felix Schumacher
>>> timeBetweenEvictionRunsMillis="5000" >>> minEvictableIdleTimeMillis="6" >>> removeAbandonedTimeout="600" >>> removeAbandoned="true" >>>

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-30 Thread Gokhan Akgul
ot;600" > > removeAbandoned="true" > > logAbandoned="false" > > testWhileIdle="true" > > testOnBorrow="true" > > testOnRe

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-30 Thread Gokhan Akgul
uot;6" > > removeAbandonedTimeout="600" > > removeAbandoned="true" > > logAbandoned="false" > > testWhileIdle="true" > > testOnBorrow="true" >

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-29 Thread Phil Steitz
On 8/27/20 2:47 AM, Gokhan Akgul wrote: Hi , I have been facing the deadlock issue for the last 2 months about JDBCPoolCleaner Thread . Following config set in context.xml Thread dump Tomcat JDBC Pool Cleaner[63445188:1598345711425] id=16 state=BLOCKED - waiting to lock

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-27 Thread Felix Schumacher
" > removeAbandoned="true" > logAbandoned="false" > testWhileIdle="true" > testOnBorrow="true" > testOnReturn="false" > validationQuery="/* ping */ SELECT

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-27 Thread Michael Ng
aracterEncoding > =latin5&characterResultSet=latin5&zeroDateTimeBehavior=convertTo > Null&autoReconnect=true&interactiveClient=true" > > > > > username="user" > > password="pass" initialSize="10" maxActive="30" maxIdle="

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-27 Thread Christopher Schultz
inEvictableIdleTimeMillis="6" removeAbandonedTimeout="600" > removeAbandoned="true" logAbandoned="false" testWhileIdle="true" > testOnBorrow="true" testOnReturn="false" validationQuery="/* ping > */ SELECT 1&qu

Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-27 Thread Gokhan Akgul
Hi , I have been facing the deadlock issue for the last 2 months about JDBCPoolCleaner Thread . Following config set in context.xml Thread dump Tomcat JDBC Pool Cleaner[63445188:1598345711425] id=16 state=BLOCKED - waiting to lock <0x57dcb0b7> (a com.mysql.jdbc.JDBC4PreparedSta

Re: Eclipse/Tomcat/jdbc

2019-02-09 Thread John Dale
Bravo! Good work. John On 2/9/19, Jerry Malcolm wrote: > John, > > Update I went into the eclipse server definition and changed "Use > Workspace Metadata" to "Use Tomcat Installation" and it finally works. > This validates your assumption that some config item was not being > replicated.

Re: Eclipse/Tomcat/jdbc

2019-02-09 Thread John Dale
It's been awhile since I used eclipse, so forgive my lack of specificity. I did run into this problem several times, though, when I was using eclipse I'm sure of it. Are you setting up a database connection pool? You can define these either in server.xml or in a separate context file. I believe

Re: Eclipse/Tomcat/jdbc

2019-02-09 Thread Jerry Malcolm
John, Update I went into the eclipse server definition and changed "Use Workspace Metadata" to "Use Tomcat Installation" and it finally works.  This validates your assumption that some config item was not being replicated.  But I still would like to know what it is that's missing.  I gues

Re: Eclipse/Tomcat/jdbc

2019-02-09 Thread Jerry Malcolm
John, Specifically what "jdbc configuration" am I looking for?  I see all the replicated config files in the eclipse workspace plus the metadata folder, etc.  But I don't really define 'jdbc' explicitly in native tomcat (At least I don't think I do).  So I'm not sure what should be replicated

Re: Eclipse/Tomcat/jdbc

2019-02-09 Thread Jerry Malcolm
Arjuna, It's not maven.  It's a simple WAR file project.  Actually several virtual hosts with several WAR files per host.  I don't build in Eclipse.  I simply reference the source tree.  Everything is deployed in Tomcat and running fine standalone. I decided to start from scratch and reinsta

Re: Eclipse/Tomcat/jdbc

2019-02-09 Thread John Dale
Eclipse creates its own set of deployment metadata .. likely your jdbc configuration is not being replicated there. In the tomcat logs, you can usually find some file paths that give a clue as to the deployment information being used .. in eclipse, I would guess they are machine generated paths th

Re: Eclipse/Tomcat/jdbc

2019-02-09 Thread Arjuna Bandara
Jerry, Are you running Maven project? Could you send error msg? Regards, Arjuna On Sat, 9 Feb 2019 9:46 pm Jerry Malcolm, wrote: > Any idea what could cause 'jdbc' to not be found when running eclipse, > but it is found when running outside eclipse? > > I have a fully functional Tomcat 9.0 r

Eclipse/Tomcat/jdbc

2019-02-09 Thread Jerry Malcolm
Any idea what could cause 'jdbc' to not be found when running eclipse, but it is found when running outside eclipse? I have a fully functional Tomcat 9.0 running fine with Windows services.  But when I define a Tomcat 9.0 server in Eclipse and start it up, the first time I need to access a dat

RE: Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

2018-07-14 Thread Caldarale, Charles R
> From: Felix Schumacher [mailto:felix.schumac...@internetallee.de] > Subject: Re: Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor > Am 11.07.2018 um 16:22 schrieb Martin Knoblauch: > > Now it might be, that we are just using the StatementFinalizer in a w

Re: Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

2018-07-14 Thread Felix Schumacher
Am 11.07.2018 um 16:22 schrieb Martin Knoblauch: Hi, while analyzing some heap dump for other reasons, I found that our application is apparently aggregating a considerable amount of memory in "org.apache.tomcat.jdbc.pool.TrapException", which is never cleaned by GC. Digging deeper, it seem

Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

2018-07-11 Thread Martin Knoblauch
Hi, while analyzing some heap dump for other reasons, I found that our application is apparently aggregating a considerable amount of memory in "org.apache.tomcat.jdbc.pool.TrapException", which is never cleaned by GC. Digging deeper, it seems that the entries of the "statements" linked list in t

Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

2018-01-12 Thread Jerry Malcolm
Thanks for the info.  But it appears that the mbean: org.apache.tomcat.jdbc.pool.jmx.ConnectionPool is not registered.  I found some code that collects info from this bean, and this mbean doesn't even show up when querying jmx in Tomcat.  I am running Tomcat 8.5.  I've tried googling and

Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

2018-01-11 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jerry, Please don't hijack threads. Start a new thread by sending a fresh message to users@tomcat.apache.org. Don't just reply to an existing message in the list and change the subject. - -chris On 1/11/18 1:47 PM, Jerry Malcolm wrote: > I followe

Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

2018-01-11 Thread Simon De Uvarow
"No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides, no traiciones, lo que siempre te ha hecho vivir." On Thu, Jan 11, 2018 at 6:47 PM, Jerry Malcolm wrote: > I followed the instructions to enable JMX on Tomcat. I added the > following lines to java config: > > -Dcom.sun.man

Monitoring Tomcat JDBC Connection Pool with JConsole?

2018-01-11 Thread Jerry Malcolm
I followed the instructions to enable JMX on Tomcat.  I added the following lines to java config: -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=8083 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false -Djava.rmi.server.hostname=localhos

tomcat-jdbc PoolExhaustedException message

2017-12-20 Thread Tara Czutno
Hello, my application in production is having intermittent performance problems. My app shows db queries are taking too long. The db team says the database is running fine. The network is between us and it has had problems in the past. We saw this pool exhausted exception at one point. Can so

Unable to use Tomcat JDBC CP with XA connections

2017-11-23 Thread Maxim Sukhotin
Hello, I have Tomcat 8.5.23 with following context.xml: It declares XADataSource using Tomcat JDBC CP. When I retrieve a connection I get the following exception: org.postgresql.util.PSQLException: Connection has been closed. If I declare connection without Tomcat CP it works ok: Do I

tomcat-jdbc connection return to pool and SQL Warnings

2017-11-08 Thread Benoit Wiart
Hi, It looks like Connection#clearWarnings() is not called on the proxied jdbc connection when the connection is returned to the pool. Is this something missing or that's a design choice ? In our use case : 1 - borrow a connection from the pool 2 - use it -> the driver set a SQLWarning on the c

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Mark Thomas
On 16 February 2017 17:26:18 GMT+00:00, Chris Keilitz wrote: >I've implemented Tomcat JDBC connection pool stand-alone, outside of >Tomcat >or any app server or container and cannot get the Juli logging working >- >console or file. The connection pool works great, but I cann

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Chris Keilitz
t; > According to you, what kind of log the Tomcat driver should write ? > > 2017-02-16 19:08 GMT+01:00 Chris Keilitz : > > > I'm assuming, once configured properly, the Tomcat JDBC connection pool > > would output log messages. Unfortunately, I currently get no

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Chris, On 2/16/17 1:08 PM, Chris Keilitz wrote: > I'm assuming, once configured properly, the Tomcat JDBC connection > pool would output log messages. Unfortunately, I currently get no > console or file output...even after t

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Aurélien Terrestris
eilitz : > I'm assuming, once configured properly, the Tomcat JDBC connection pool > would output log messages. Unfortunately, I currently get no console or > file output...even after trying numerous logging.properties changes. > > I'm hoping for a little help to understand the

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Chris Keilitz
I'm assuming, once configured properly, the Tomcat JDBC connection pool would output log messages. Unfortunately, I currently get no console or file output...even after trying numerous logging.properties changes. I'm hoping for a little help to understand the proper way to configure a s

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Chris, On 2/16/17 12:26 PM, Chris Keilitz wrote: > I've implemented Tomcat JDBC connection pool stand-alone, outside > of Tomcat or any app server or container and cannot get the Juli > logging working - console or file. The connect

Tomcat JDBC Connection Pool - Stand Alone Logging

2017-02-16 Thread Chris Keilitz
I've implemented Tomcat JDBC connection pool stand-alone, outside of Tomcat or any app server or container and cannot get the Juli logging working - console or file. The connection pool works great, but I cannot get the logging going. I've added CATALINA_HOME to the local director

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

2016-09-08 Thread Mohamad Abbas
ke it simple and reproduce the problem i've created a test > > project who contains the "Main" class below. The test project is > > executed on on a windows 7, using jdk1.8.0_92. The only jars are > > present in the classpath of the project are: tomcat-jdbc(8.0.37),

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

2016-09-08 Thread Christopher Schultz
jars are > present in the classpath of the project are: tomcat-jdbc(8.0.37), > tomcat-juli(8.8.37), and ojdbc7-12.1.0.2.0. > > Those are the steps to reproduce the problem: > > - Create a Statement using the method .prepareStatement(String)=> > OK - Execute the qu

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

2016-09-08 Thread Mohamad Abbas
esults). >> >> To make it simple and reproduce the problem i've created a test project >> who >> contains the "Main" class below. The test project is executed on on a >> windows 7, using jdk1.8.0_92. The only jars are present in the classpath >> o

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

2016-09-08 Thread Terence M. Bandoian
it simple and reproduce the problem i've created a test project who contains the "Main" class below. The test project is executed on on a windows 7, using jdk1.8.0_92. The only jars are present in the classpath of the project are: tomcat-jdbc(8.0.37), tomcat-juli(8.8.37), and ojdb

[TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

2016-09-08 Thread Mohamad Abbas
27;ve created a test project who contains the "Main" class below. The test project is executed on on a windows 7, using jdk1.8.0_92. The only jars are present in the classpath of the project are: tomcat-jdbc(8.0.37), tomcat-juli(8.8.37), and ojdbc7-12.1.0.2.0. Those are the steps

Dynamically determine which credentials to use for a Tomcat JDBC Connection Pool [Tomcat 8.0.36]

2016-07-08 Thread Philip Hachey
Hi. I'm looking for a way to dynamically determine which username and password to use for a Tomcat JDBC Connection Pool [https://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html] based on the database URL to which it is connecting. I imagine this as an external key=value lookup

Re: Getting current_statement_cache in tomcat jdbc connection pool

2016-06-23 Thread Mark Thomas
On 23/06/2016 11:06, Manisha Sapiah wrote: > Hi , > > Is there any way to get current_statement_cache in tomcat jdbc connection > pool. No, given that there is no such field or variable to be found anywhere in the current 9.0.x

Getting current_statement_cache in tomcat jdbc connection pool

2016-06-23 Thread Manisha Sapiah
Hi , Is there any way to get current_statement_cache in tomcat jdbc connection pool. Many Thanks in advance.

Re: Prepared statements are not cached with XA in tomcat jdbc connection pool implementation

2016-05-25 Thread Woonsan Ko
chultz.net] > Sent: 18 May 2016 01:24 > To: Tomcat Users List > Subject: Re: Prepared statements are not cached with XA in tomcat jdbc > connection pool implementation > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Sailaja, > > On 5/17/16 6:58 AM, Sailaj

RE: Prepared statements are not cached with XA in tomcat jdbc connection pool implementation

2016-05-17 Thread Sailaja Ravipati
Thank you. Will do that. Regards, Sailaja. -Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: 18 May 2016 01:24 To: Tomcat Users List Subject: Re: Prepared statements are not cached with XA in tomcat jdbc connection pool implementation -BEGIN

Re: Prepared statements are not cached with XA in tomcat jdbc connection pool implementation

2016-05-17 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Sailaja, On 5/17/16 6:58 AM, Sailaja Ravipati wrote: > I am using TomEE version Apache Tomcat Version 7.0.63. I have the > following test program. > > public static void main(String[] args) throws Exception { final > TransactionManager transactionM

Prepared statements are not cached with XA in tomcat jdbc connection pool implementation

2016-05-17 Thread Sailaja Ravipati
Hi I am using TomEE version Apache Tomcat Version 7.0.63. I have the following test program. public static void main(String[] args) throws Exception { final TransactionManager transactionManager = TransactionManagerFactory .getTra

Re: [Tomcat-JDBC] RemovedAbandoned doesn't trigger JdbcInterceptors

2015-12-18 Thread Robert Anderson
Thanks, Keiichi. 2015-12-18 3:21 GMT-03:00 Keiichi Fujino : > 2015-12-17 22:25 GMT+09:00 Robert Anderson : > > > Hi, > > > > When a connection is closed by "ResetAbandoned" the invoke() method from > > JdbcInterceptor is not called. Is it the expected behaviour? > > > > > Yes. > > The JdbcInterce

Re: [Tomcat-JDBC] RemovedAbandoned doesn't trigger JdbcInterceptors

2015-12-17 Thread Keiichi Fujino
2015-12-17 22:25 GMT+09:00 Robert Anderson : > Hi, > > When a connection is closed by "ResetAbandoned" the invoke() method from > JdbcInterceptor is not called. Is it the expected behaviour? > > Yes. The JdbcInterceptor.invoke() method is not called when removeAbandoned. The Connection(PooledConn

[Tomcat-JDBC] RemovedAbandoned doesn't trigger JdbcInterceptors

2015-12-17 Thread Robert Anderson
Hi, When a connection is closed by "ResetAbandoned" the invoke() method from JdbcInterceptor is not called. Is it the expected behaviour? -->server.xml --> pool.ExampleInterceptor public class ExampleInterceptor extends JdbcInterceptor { public Object invoke(Object proxy, Method

[Tomcat-JDBC] ResetAbandoned doesn't trigger JdbcInterceptors

2015-12-17 Thread Robert Anderson
Hi, When a connection is closed by "ResetAbandoned" the invoke() method from JdbcInterceptor is not called. Is it the expected behaviour? -->server.xml --> pool.ExampleInterceptor public class ExampleInterceptor extends JdbcInterceptor { public Object invoke(Object proxy, Method

Re: Tomcat JDBC configuration does not encrypt the database password

2015-10-26 Thread Christopher Schultz
Dave, On 10/26/15 7:22 AM, Dave Cronin wrote: > In the JNDI DataSource HowTo page, it describes how to configure the > DataSource in the application Context. I see that the password is not > encrypted. Is there any way to configure this with an encrypted password? > > A JDBC resource is configure

Tomcat JDBC configuration does not encrypt the database password

2015-10-26 Thread Dave Cronin
In the JNDI DataSource HowTo page, it describes how to configure the DataSource in the application Context. I see that the password is not encrypted. Is there any way to configure this with an encrypted password? A JDBC resource is configured like this in the documentation: >From >https://to

Re: DBCP params different for the Tomcat JDBC (not DBCP) implementation in Tomcat 8?

2015-10-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Bradley, On 10/7/15 4:04 PM, Bradley Wagner wrote: >> The general recommendation is to use the default pool >> (commons-dbcp). > > Great. Thanks! > >> Unless you have narrowed a performance problem to the pool >> itself, > there's no reason to use

Re: DBCP params different for the Tomcat JDBC (not DBCP) implementation in Tomcat 8?

2015-10-07 Thread Bradley Wagner
eady understand. > "DBCP" usually just means "database connection pool", but in the > Apache world, it usually specifically means commons-dbcp. > > > Is it your recommendation then to use DBCP 2 over Tomcat JDBC in > > Tomcat 8? If so, I think it would be help

Re: DBCP params different for the Tomcat JDBC (not DBCP) implementation in Tomcat 8?

2015-10-07 Thread Christopher Schultz
ly confusing to those you don't already understand. "DBCP" usually just means "database connection pool", but in the Apache world, it usually specifically means commons-dbcp. > Is it your recommendation then to use DBCP 2 over Tomcat JDBC in > Tomcat 8? If so, I think i

Re: DBCP params different for the Tomcat JDBC (not DBCP) implementation in Tomcat 8?

2015-10-07 Thread Bradley Wagner
Ah, I see what you're saying. My apologies for not seeing that sooner. That post was also very helpful in explaining why both exist. Thank you! Is it your recommendation then to use DBCP 2 over Tomcat JDBC in Tomcat 8? If so, I think it would be helpful to have a page on the public T

Classpath issue between jetty-maven-plugin and tomcat-jdbc 8.0.9+ leading to ServiceConfigurationError

2015-09-18 Thread Vinicius Sampaio
Hi, I'm getting an error while trying to update the tomcat-jdbc version to 8.0.9+ on a project I'm working on. Currently I'm using 8.0.8 version without issues. I would be very thankful for any help coming from you guys. http://stackoverflow.com/questions/32643530/classpath-issu

Re: Tomcat JDBC vs DBCP2?

2015-06-03 Thread Bjørn T Johansen
On 03.06.2015 21:57, Mark Thomas wrote: On 03/06/2015 20:50, Christopher Schultz wrote: Bjørn, On 6/3/15 2:52 PM, Bjørn T Johansen wrote: Just saw a discussion about Tomcat DBCP 8.0.18 issue, where Tomcat JDBC pooling vs Commons DBCP 2 pooling was briefly discussed.. So now I am a bit curious

  1   2   3   4   5   >