Re: Tomcat JDBC Pool Cleaner Deadlock Problem

that it probably won't. What MySQL advises is to change the pool to use the abort-Method of the connection to close it in the case of abandoned connections. The dbcp2 pools seems to be able to use that method, while I found no reference to it in the jdbc-pool module (which you are using). We

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

, while I found no reference to it in the jdbc-pool module (which you are using). So, maybe it is a good idea to switch the used pool from the jdbc-pool to the default tomcat pool (see http://tomcat.apache.org/tomcat-9.0-doc/jndi-datasource-examples-howto.html). It should work equally well (I am not sure,

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

nEvictionRunsMillis="5000" >>> minEvictableIdleTimeMillis="6" >>> removeAbandonedTimeout="600" >>> removeAbandoned="true" >>> logAbandoned="false" >

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

removeAbandoned="true" > > logAbandoned="false" > > testWhileIdle="true" > > testOnBorrow="true" > > testOnReturn="false" > > validationQuery="/*

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

removeAbandonedTimeout="600" > > removeAbandoned="true" > > logAbandoned="false" > > testWhileIdle="true" > > testOnBorrow="true" > > testOnR

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

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

removeAbandoned="true" > logAbandoned="false" > testWhileIdle="true" > testOnBorrow="true" > testOnReturn="false" > validationQuery="/* ping */ SELECT 1" > valid

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

I had a similar issue with JDBC and it got fixed by adding this parameter 'numTestsPerEvictionRun'=> '3', 'auth' => 'Container', 'driverClassName' => 'oracle.jdbc.OracleDriver', '

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

illis="6" removeAbandonedTimeout="600" > removeAbandoned="true" logAbandoned="false" testWhileIdle="true" > testOnBorrow="true" testOnReturn="false" validationQuery="/* ping > */ SELECT 1" validationIn

Tomcat JDBC Pool Cleaner Deadlock Problem

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: Tomcat 9.0 - JDBC URL Help

://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/glossary.html#GUID-8836AF91-6176-4133-BD13-348AF90181CE El lun., 27 ene. 2020 a las 18:15, Edwards, Crista E () escribió: > What is the proper syntax for the URL portion of my JDBC connection when > using 2 databases? We are on Tomc

Tomcat 9.0 - JDBC URL Help

What is the proper syntax for the URL portion of my JDBC connection when using 2 databases? We are on Tomcat 9.0, connecting to an Oracle database. We have 2 database instances, one active & one inactive, but the JDBC connection must contain both & connect to the active instanc

Re: JDBC connection pooling maxActive or MaxTotal

On Fri, Jan 3, 2020 at 5:29 PM Christopher Schultz < > > ch...@christopherschultz.net> wrote: > > > >> -BEGIN PGP SIGNED MESSAGE- > >> Hash: SHA256 > >> > >> Dave, > >> > >> On 1/3/20 13:47, Dave Bothwell wrot

Re: [OT] JDBC connection pooling maxActive or MaxTotal

quot;dbcp" flavor provides pooling (unsurprisingly) of JDBC connections. The commons-pool reference was meant to be the bundled version of commons-dbcp that Tomcat already provides. Thanks, - -chris > On 03/01/2020 23:21, Dave Bothwell wrote: >> Chris, >> >> T

Re: JDBC connection pooling maxActive or MaxTotal

On Sat, Jan 4, 2020 at 2:47 AM Dave Bothwell wrote: > Hello, > > I am using Tomcat 8.5.11 with JDBC connection pooling. Based on the > documentation it is clear that DBCP pooling has changed the maxActive > attribute to maxTotal. However it is unclear, based on this d

Re: JDBC connection pooling maxActive or MaxTotal

, That was very helpful. Thank you Dave On Fri, Jan 3, 2020 at 5:29 PM Christopher Schultz < ch...@christopherschultz.net> wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Dave, On 1/3/20 13:47, Dave Bothwell wrote: I am using Tomcat 8.5.11 with JDBC connection pooling.

Re: JDBC connection pooling maxActive or MaxTotal

Chris, That was very helpful. Thank you Dave On Fri, Jan 3, 2020 at 5:29 PM Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Dave, > > On 1/3/20 13:47, Dave Bothwell wrote: > > I am using Tomc

Re: JDBC connection pooling maxActive or MaxTotal

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Dave, On 1/3/20 13:47, Dave Bothwell wrote: > I am using Tomcat 8.5.11 with JDBC connection pooling. Based on > the documentation it is clear that DBCP pooling has changed the > maxActive attribute to maxTotal. However it is uncle

Re: JDBC connection pooling maxActive or MaxTotal

, I am using Tomcat 8.5.11 with JDBC connection pooling. Based on the documentation it is clear that DBCP pooling has changed the maxActive attribute to maxTotal. However it is unclear, based on this document https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html, if JDBC pooling has also changed

JDBC connection pooling maxActive or MaxTotal

Hello, I am using Tomcat 8.5.11 with JDBC connection pooling. Based on the documentation it is clear that DBCP pooling has changed the maxActive attribute to maxTotal. However it is unclear, based on this document https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html, if JDBC pooling has also

tomcat7 jdbc pool seems blocked: PoolExhaustedException

HI??thank you for read this mail??In our product env??we get exception?? Caused by: org.apache.tomcat.jdbc.pool.PoolExhaustedException: [-cmd[system_intergration.enn_portal_login]-ip[10.11.87.126]] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:300;

RE: [EXTERNAL] Re: Could not find datasource: java:/comp/env/jdbc/TOPSDB when start Tomcat 9.0.13

Chris: I did what you suggested, that is to remove all drivers from the application's WEB-INF/lib directory and leave the one in Tomcat's lib/ directory. Now the error "FATAL connection.DatasourceConnectionProvider - Could not find datasource: java:/comp/env/jdbc/T

Re: [EXTERNAL] Re: Could not find datasource: java:/comp/env/jdbc/TOPSDB when start Tomcat 9.0.13

ec 17 > 17:45 log4j.jar I'm always suspicious of library JAR files that have no version number. You might want to take a look at what these are and re-name them appropriately. > -rwxrwxrwx 1 atadmin atadmin 1196109 Dec 17 17:47 classes12.jar classes12.jar is Oracle's JDBC driver wri

RE: [EXTERNAL] Re: Could not find datasource: java:/comp/env/jdbc/TOPSDB when start Tomcat 9.0.13

own.sh and startup.sh the server, same error occurred. Thanks Gary -Original Message- From: Olaf Kock [mailto:tom...@olafkock.de] Sent: Monday, March 25, 2019 1:56 AM To: users@tomcat.apache.org Subject: [EXTERNAL] Re: Could not find datasource: java:/comp/env/jdbc/TOPSDB when start

Re: Could not find datasource: java:/comp/env/jdbc/TOPSDB when start Tomcat 9.0.13

gt; 1537 [main] FATAL connection.DatasourceConnectionProvider - Could not find > datasource: java:/comp/env/jdbc/TOPSDB > java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp2.BasicDataSource > cannot be cast to javax.sql.DataSource > at > org.hibernate.connection.DatasourceConnectionProvider.configu

Could not find datasource: java:/comp/env/jdbc/TOPSDB when start Tomcat 9.0.13

Hi experts: After I deployed my application TOPS to Tomcat server(9.0.13) on Linux box, and started the server, I got the following error: 1537 [main] FATAL connection.DatasourceConnectionProvider - Could not find datasource: java:/comp/env/jdbc/TOPSDB

Re: Eclipse/Tomcat/jdbc

ut it is pretty clear now that Eclipse didn't > replicate everything required to use the metadata. Any idea what might > be missing? I guess I might need to move this discussion over to > Eclipse now. > > Thanks for the suggestions. > > Jerry > > On 2/9/2019 11:23 AM, Jer

Re: Eclipse/Tomcat/jdbc

a little time to straighten out which set(s) of files re driving tomcat, and one final word to the wise .. make sure you aren't pointing to another older/stale war file that is deploying successfully. THAT is annoying! ;) John On 2/9/19, Jerry Malcolm wrote: > John, > > Specifically what &qu

Re: Eclipse/Tomcat/jdbc

ny idea what might be missing?  I guess I might need to move this discussion over to Eclipse now. Thanks for the suggestions. Jerry On 2/9/2019 11:23 AM, Jerry Malcolm wrote: John, Specifically what "jdbc configuration" am I looking for?  I see all the replicated config files in

Re: Eclipse/Tomcat/jdbc

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 w

Re: Eclipse/Tomcat/jdbc

and reinstalled the latest TC (9.0.14 I think).  I copied my server.xml and my Catalina virtual host folders.  Started it up with Windows services.  Ran perfectly.  Created a new eclipse workspace, defined the server. It started up fine.  But again... no jdbc. I had this all working a month ago, which

Re: Eclipse/Tomcat/jdbc

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

Re: Eclipse/Tomcat/jdbc

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 functiona

Eclipse/Tomcat/jdbc

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

Feature? jdbc driver vs javamail loading from WEB-INF/lib

Hello, Is the jdbc driver loading from WEB-INF/lib and used in jndi datasource an official feature, given that it is used in so many webapps? Then what about mail session and javamail? Before saying yes of course or never it is, see that the jdbc driver is loaded from WEB-INF/lib and used

RE: Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

> 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

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

Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

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

Re: Getting all JDBC configs from the context

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Shawn, On 3/30/18 5:30 PM, Shawn Heisey wrote: > On 3/30/2018 11:38 AM, Christopher Schultz wrote: >> No. In Java, the "class" is defined by the ClassLoader (which >> loaded it) plus the fully-qualified class name. It's entirely >> possible in > >

Re: Getting all JDBC configs from the context

On 3/30/2018 11:38 AM, Christopher Schultz wrote: > No. In Java, the "class" is defined by the ClassLoader (which loaded > it) plus the fully-qualified class name. It's entirely possible in The subtleties of classloader-related problems make my head hurt. :) > If objects a and b were

Re: Getting all JDBC configs from the context

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Shawn, On 3/29/18 3:29 PM, Shawn Heisey wrote: > On 3/29/2018 10:00 AM, Christopher Schultz wrote: >> I don't bother with any of that garbage. I use Tomcat's Manager >> application and the JMXProxyServlet. It's an HTTP-to-JMX bridge, >> so your

Re: Getting all JDBC configs from the context

On 3/29/2018 10:00 AM, Christopher Schultz wrote: > I don't bother with any of that garbage. I use Tomcat's Manager > application and the JMXProxyServlet. It's an HTTP-to-JMX bridge, so > your client just has to speak HTTP. I'm not sure that the manager application is active on our install.  The

Re: Getting all JDBC configs from the context

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Shawn, On 3/29/18 12:00 PM, Christopher Schultz wrote: > Shawn, > > On 3/28/18 4:42 PM, Shawn Heisey wrote: >> On 3/28/2018 1:18 PM, Christopher Schultz wrote: I would like to write a logging thread that can get ALL of the datasource

Re: Getting all JDBC configs from the context

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Shawn, On 3/28/18 4:42 PM, Shawn Heisey wrote: > On 3/28/2018 1:18 PM, Christopher Schultz wrote: >>> I would like to write a logging thread that can get ALL of the >>> datasource objects from the context, and for types that it >>> knows, cast

Re: Getting all JDBC configs from the context

On 3/28/2018 1:18 PM, Christopher Schultz wrote: Don't forget to terminate the thread (or ExecutorService) when the application is shutting-down, of you'll have a ClassLoader (and a a huge memory) leak. Here's a new paste, that I think addresses the thread leak problem.

Re: Getting all JDBC configs from the context

On 3/28/2018 1:18 PM, Christopher Schultz wrote: > > I would like to write a logging thread that can get ALL of the > > datasource objects from the context, and for types that it knows, > > cast them to the appropriate object to log the active/idle > > connection counts. > > It might be easier to

Re: Getting all JDBC configs from the context

= > (Context)initContext.lookup("java:/comp/env"); DataSource ds = > (DataSource)envContext.lookup("jdbc/REDACTED"); > > I would like to write a logging thread that can get ALL of the > datasource objects from the context, and for types that it knows, > cast the

Getting all JDBC configs from the context

This is what the code in our application looks like that gets a datasource object from the context:   Context initContext = new InitialContext();   Context envContext  = (Context)initContext.lookup("java:/comp/env");   DataSource ds = (DataSource)envContext.lookup("jdbc/REDACTED&q

Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

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?

-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

Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

"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

Monitoring Tomcat JDBC Connection Pool with JConsole?

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

tomcat-jdbc PoolExhaustedException message

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

Unable to use Tomcat JDBC CP with XA connections

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

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 SQLWarn

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

On 16 February 2017 17:26:18 GMT+00:00, Chris Keilitz <keil...@gmail.com> 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 po

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

" version) that logs. > > According to you, what kind of log the Tomcat driver should write ? > > 2017-02-16 19:08 GMT+01:00 Chris Keilitz <keil...@gmail.com>: > > > I'm assuming, once configured properly, the Tomcat JDBC connection pool > > would output log messa

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

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

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

litz <keil...@gmail.com>: > 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 he

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

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

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

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

Tomcat JDBC Connection Pool - Stand Alone Logging

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 directory and have

Re: Tomcat6 enabling SSL for JDBC during startup

of those components are hideously old. >> From the logs it looks like SSL is getting enabled for JDBC. Any >> help to > understand why the below information shows up in catalina logs > would be much appreciated? There is nothing that got changed in the > JDBC datasource configuratio

Re: Tomcat6 enabling SSL for JDBC during startup

On Thu, Nov 17, 2016 at 7:13 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > king for help in correcting the problems that have caused the > messages in the first place? > Chris - Both. I would like to know why they started appearing in the catalina logs and how to correct the

Re: Tomcat6 enabling SSL for JDBC during startup

SSL is getting enabled for JDBC. Any >> help to > understand why the below information shows up in catalina logs > would be much appreciated? There is nothing that got changed in the > JDBC datasource configuration recently and the application uses SQL > server 2008. > >> Fr

Tomcat6 enabling SSL for JDBC during startup

I'm using Tomcat 6.0.29 version with Java 1.6.0_45 on Windows server 2008 and started noticing SSL related information in Catalina logs recently. >From the logs it looks like SSL is getting enabled for JDBC. Any help to understand why the below information shows up in catalina logs would be m

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

e results). > > > > 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 of the projec

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

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

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

(to >> paginate >> results). >> >> 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 th

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

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 ojdbc

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

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

Re: [jdbc-pool] Validation query leaves transaction open

< ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > John, > > On 8/11/16 3:33 PM, John Huss wrote: > > I have verified that in version 8.0.36 of tomcat jdbc the > > validation query functionality does not commit the transac

Re: [jdbc-pool] Validation query leaves transaction open

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 John, On 8/11/16 3:33 PM, John Huss wrote: > I have verified that in version 8.0.36 of tomcat jdbc the > validation query functionality does not commit the transaction it > starts in order to run the validation query, which can cause

Re: [jdbc-pool] Validation query leaves transaction open

2016-08-12 13:46 GMT+02:00 John Huss <johnth...@gmail.com>: > In every database I have used every query requires a transaction. Often > they will start them automatically if you don't do it explicitly. Right , but I guess that Tomcat uses JDBC connections and I wonder why f

Re: [jdbc-pool] Validation query leaves transaction open

gt;: > > I have verified that in version 8.0.36 of tomcat jdbc the validation > query > > functionality does not commit the transaction it starts in order to run > the > > validation query, which can cause an open transaction for a very long > time > > (possibly until the

Re: [jdbc-pool] Validation query leaves transaction open

2016-08-11 21:33 GMT+02:00 John Huss <johnth...@gmail.com>: > I have verified that in version 8.0.36 of tomcat jdbc the validation query > functionality does not commit the transaction it starts in order to run the > validation query, which can cause an open transaction for a

[jdbc-pool] Validation query leaves transaction open

I have verified that in version 8.0.36 of tomcat jdbc the validation query functionality does not commit the transaction it starts in order to run the validation query, which can cause an open transaction for a very long time (possibly until the database crashes). This seems to be especially

Re: Define datasource, reference JDBC driver, and see init in console

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 David, On 8/2/16 4:04 PM, KARR, DAVID wrote: > I'm attempting to use Tomcat(tomee) to run a REST service that will > return some data from some SQL queries (Oracle). I've installed > Tomee 7.0.1, which uses Tomcat 8.5.3. > >

Re: jdbc check available database

2016-08-09 10:52 GMT+02:00 Andrea Galli <andrea.ga...@tp-italia.com>: > Thank you Christoph , but in this how-to there isn't any example for SQL > Server. This is my configuration (context.xml) for a SQL Server connection pool You need a SQL Server JDBC driver > > -M

Re: R: jdbc check available database

, contact the Microsoft helpdesk (or the available on-line Microsoft documentation) to help you using it with Tomcat/java/jdbc 2) a) find a working java jdbc driver for SQL Server, install it as indicated in the page b) read the documentation of this driver, to find out how to adapt any of the 3

R: jdbc check available database

Thank you Christoph , but in this how-to there isn't any example for SQL Server. -Messaggio originale- Da: Christoph Nenning [mailto:christoph.nenn...@lex-com.net] Inviato: martedì 2 agosto 2016 09:44 A: Tomcat Users List <users@tomcat.apache.org> Oggetto: Re: jdbc check ava

Define datasource, reference JDBC driver, and see init in console

I'm attempting to use Tomcat(tomee) to run a REST service that will return some data from some SQL queries (Oracle). I've installed Tomee 7.0.1, which uses Tomcat 8.5.3. The JDBC driver is available from a private enterprise maven repo. I'd prefer to get it from there, as opposed to storing

Re: jdbc check available database

> Hello guys, > > I’ve SQL Server database with Tomcat 7 and, when I restart only database, > webapps on Tomcat didn’t works , it show me error to connect to database .. > > In webapp context I use jdbc driver for connect, so there is a kind of > method for retry to con

jdbc check available database

Hello guys, I’ve SQL Server database with Tomcat 7 and, when I restart only database, webapps on Tomcat didn’t works , it show me error to connect to database .. In webapp context I use jdbc driver for connect, so there is a kind of method for retry to connect to database when it return

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

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 where

Re: tomcat 7.0.55 jdbc pool "Not a wrapper of oracle.jdbc.OracleConnection"

ionQuery="select 1 from dual" validationInterval="3" > removeAbandoned="true" removeAbandonedTimeout="600" > logAbandoned="true" testWhileIdle="false" testOnReturn="false" > jmxEnabled="true" accessToUnderlyingConnectionAllowed=&qu

tomcat 7.0.55 jdbc pool "Not a wrapper of oracle.jdbc.OracleConnection"

I have following resource configuration for Oracle Data source Pool and trying to unwrap the connection object using: OracleConnection conn = connection.unwrap(OracleConnection.class); And getting following exception: com.sun.proxy.$Proxy77.unwrap exception : java.sql.SQLException: Not a

Re: Getting current_statement_cache in tomcat jdbc connection pool

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

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

istopher 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 PGP SIGNED MESSAGE- > Hash: SHA256 > > Sailaja, > > On

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

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

-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

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

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

Re: tomcat(7.0.56) is not releasing idle jdbc connections

d, May 11, 2016 at 7:35 AM, Niranjan Babu Bommu < > > niranjan.bo...@gmail.com> wrote: > > > > > Hi Mark > > > I have included defined data source in this mail, do you want me to > > > include complete server.xml? > > > > > > thanks > >

Re: tomcat(7.0.56) is not releasing idle jdbc connections

Behavior=true"/> > > On Wed, May 11, 2016 at 7:35 AM, Niranjan Babu Bommu < > niranjan.bo...@gmail.com> wrote: > > > Hi Mark > > I have included defined data source in this mail, do you want me to > > include complete server.xml? > > > &

Re: tomcat(7.0.56) is not releasing idle jdbc connections

ay 11, 2016 at 7:35 AM, Niranjan Babu Bommu < > niranjan.bo...@gmail.com> wrote: > >> Hi Mark >> I have included defined data source in this mail, do you want me to >> include complete server.xml? >> >> thanks >> Niranjan >> >> On Wed, May 11,

Re: tomcat(7.0.56) is not releasing idle jdbc connections

to > include complete server.xml? > > thanks > Niranjan > > On Wed, May 11, 2016 at 7:19 AM, Mark Thomas <ma...@apache.org> wrote: > >> On 11/05/2016 11:58, Niranjan Babu Bommu wrote: >> > Hi, >> > >> > we are migrating prod servers to tomcat

Re: tomcat(7.0.56) is not releasing idle jdbc connections

are migrating prod servers to tomcat, since we are doing it slowly we > > have found an issue in jdbc connection pool, tomcat is not releasing idle > > jdbc connections, even we have tried setting maxIdle="10" but "NumIdle > 97" > > always. due to this threads

Re: tomcat(7.0.56) is not releasing idle jdbc connections

On 11/05/2016 11:58, Niranjan Babu Bommu wrote: > Hi, > > we are migrating prod servers to tomcat, since we are doing it slowly we > have found an issue in jdbc connection pool, tomcat is not releasing idle > jdbc connections, even we have tried setting maxIdle="10" but &

tomcat(7.0.56) is not releasing idle jdbc connections

Hi, we are migrating prod servers to tomcat, since we are doing it slowly we have found an issue in jdbc connection pool, tomcat is not releasing idle jdbc connections, even we have tried setting maxIdle="10" but "NumIdle 97" always. due to this threads are piling up in data

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