Re: Jdbc drivers not found on Tomcat 10

2022-01-06 Thread hantsy bai
HI Christopher, not sure we are on the same page. The problem I encountered was that a Spring 6 war app with pg driver(42.3.1) could not deploy on Tomcat 10, but worked well when downupgraded to Spring 5/Tomcat 9. But on the jetty 11 and WildFly preview 26, Spring 6/pg war package are also working

Re: Jdbc drivers not found on Tomcat 10

2022-01-06 Thread Christopher Schultz
Hantsy, On 1/5/22 23:31, hantsy bai wrote: I finally resolved this issue. Exclude the pg driver from war, and copy it to tomcat/lib, it works. I remember in the past years, I preferred tomcat for Java Web applications because I did not need to register a Jdbc driver but it is tedious work in

Re: Jdbc drivers not found on Tomcat 10

2022-01-05 Thread hantsy bai
I finally resolved this issue. Exclude the pg driver from war, and copy it to tomcat/lib, it works. I remember in the past years, I preferred tomcat for Java Web applications because I did not need to register a Jdbc driver but it is tedious work in Java EE application servers, such as Glassfish

RE: jdbc connction pool issues [EXTERNAL]

2020-12-18 Thread Beard, Shawn
ership Unleashing Business Potential -Original Message- From: Christopher Schultz Sent: Friday, December 18, 2020 7:22 AM To: Tomcat Users List Subject: Re: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message Shawn, On 12/17/20 14:21, Beard, Shawn wrote: > Well

Re: jdbc connction pool issues [EXTERNAL]

2020-12-18 Thread Christopher Schultz
Shawn, On 12/17/20 14:21, Beard, Shawn wrote: Well the other tomcat servers had a custom factory specified. That was the only difference. (devs wrote their own library for it) So they were different. It's always misleading when getting a report like this: On 12/15/20 15:35, Beard, Shawn wrote:

RE: jdbc connction pool issues [EXTERNAL]

2020-12-17 Thread Beard, Shawn
ubject: Re: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message Shawn, On 12/17/20 11:04, Beard, Shawn wrote: > I was able to fix this. I added this to the config: > > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > > I was then seeing maxConnecti

Re: jdbc connction pool issues [EXTERNAL]

2020-12-17 Thread Christopher Schultz
Shawn, On 12/17/20 11:04, Beard, Shawn wrote: I was able to fix this. I added this to the config: factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" I was then seeing maxConnections of 50 in jmx and not 8. So Phil was right: you needed to s/maxActive/maxTotal/. That doesn't sounds righ

RE: jdbc connction pool issues [EXTERNAL]

2020-12-17 Thread Beard, Shawn
sbe...@wrberkley.com<mailto:sbe...@wrberkley.com> -Original Message- From: Beard, Shawn Sent: Wednesday, December 16, 2020 7:43 AM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message Yes same version of tomcat 9.0.31,

RE: jdbc connction pool issues [EXTERNAL]

2020-12-16 Thread Beard, Shawn
<mailto:sbe...@wrberkley.com> -Original Message- From: Phil Steitz Sent: Tuesday, December 15, 2020 3:37 PM To: users@tomcat.apache.org Subject: Re: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message On 12/15/20 1:35 PM, Beard, Shawn wrote: > No intitialSi

Re: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Phil Steitz
com> -Original Message- From: Johnson, Jim Sent: Tuesday, December 15, 2020 2:22 PM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message Hi Shawn, No, I don't think that maxActive means that it's defining the m

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
...@wrberkley.com<mailto:sbe...@wrberkley.com> -Original Message- From: Jalaj Asher Sent: Tuesday, December 15, 2020 2:39 PM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message Hi Shawn, Check the Catalina home and see i

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Jalaj Asher
:22 PM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] Attention: This email was sent from someone outside of eClinicalWorks. Always use caution when opening attachments or clicking links from unknown senders or when receiving unexpected emails. Hi Shawn, No, I don

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
Sent: Tuesday, December 15, 2020 2:22 PM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message Hi Shawn, No, I don't think that maxActive means that it's defining the maximum number of connections for the pool, I think it's stri

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Johnson, Jim
: Tuesday, December 15, 2020 2:49 PM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] But wouldn’t maxActive mean the connection pool has a max of 50 conenctions? On other tomcat servers I have, maxActive is set to 50 and I verified im jmx that there are 50 max connections

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Johnson, Jim
- Jim -Original Message- From: Beard, Shawn Sent: Tuesday, December 15, 2020 2:42 PM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] If default is 10, they why would we be getting an error about 8 being max? Shawn​ Beard Sr. Systems Engineer |

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
​ Beard Sr. Systems Engineer | BTS Middleware Engineering | +1-515-564-2528 | sbe...@wrberkley.com<mailto:sbe...@wrberkley.com> -Original Message- From: Johnson, Jim Sent: Tuesday, December 15, 2020 1:35 PM To: Tomcat Users List Subject: RE

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
- From: Johnson, Jim Sent: Tuesday, December 15, 2020 1:35 PM To: Tomcat Users List Subject: RE: jdbc connction pool issues [EXTERNAL] ** CAUTION: External message Hi Shawn, I think you’re missing initialSize initialSize (int)The initial number of connections that are created when the pool is s

RE: jdbc connction pool issues

2020-12-15 Thread Johnson, Jim
Hi Shawn, I think you’re missing initialSize initialSize (int)The initial number of connections that are created when the pool is started. Default value is 10 maxActive (int) The maximum number of active connections that can be allocated from this pool at the same time. The default value is 10

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-08 Thread Zahid Rahman
Hey Dave B. , My question from chris was for your benefit. default configuration is not the same thing as vendor neutral. chris wrote: > If you use both, you should be all set for whichever pool you use at runtime. DOH ! >If you look in your log file, you will notice that when Tomcat starts >up

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-05 Thread Guang Chao
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 document > https://tomcat.apac

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread zahid
chris, Is commons-dbcp-2.x   a Database pooling component for any container Jetty,Jboss tomcat   etc. ? is commons-dbcp-2.x a third option, separate option from the two pooling options [tomcat-pool and commons-pool] you mentioned ? On 03/01/2020 23:21, Dave Bothwell wrote: Chris, That w

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread Dave Bothwell
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 Tomcat 8.5.11 with JDBC connection pool

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread Christopher Schultz
-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 unclear, based on > this

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread zahid
|I hope these descriptions of the setting helps you in making a decision as to the value. | |maxActive| (int) The maximum number of active connections that can be allocated from this pool at the same time. The default value is |100||| | | On 03/01/2020 18:47, Dave Bothwell wrote: Hello,

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

2016-08-15 Thread John Huss
I don't have one. I'm creating the pool in code. Basically like this: PoolConfiguration p = new PoolProperties(); p.setUrl(url); p.setDriverClassName(driverClass); p.setUsername(username); p.setPassword(password); p.setJmxEnabled(true); p.setTestWhileIdle(true); p.setTestOnBorrow(true); p.setTes

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

2016-08-15 Thread Christopher Schultz
-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 an > open trans

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

2016-08-12 Thread Jose María Zaragoza
2016-08-12 13:46 GMT+02:00 John Huss : > 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 for executing validationQuery sentence, Tomcat

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

2016-08-12 Thread John Huss
In every database I have used every query requires a transaction. Often they will start them automatically if you don't do it explicitly. On Fri, Aug 12, 2016 at 4:13 AM Jose María Zaragoza wrote: > 2016-08-11 21:33 GMT+02:00 John Huss : > > I have verified that in version 8.0.36 of tomcat jdbc t

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

2016-08-12 Thread Jose María Zaragoza
2016-08-11 21:33 GMT+02:00 John Huss : > 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 databa

Re: jdbc check available database

2016-08-09 Thread Jose María Zaragoza
a: Christoph Nenning [mailto:christoph.nenn...@lex-com.net] > Inviato: martedì 2 agosto 2016 09:44 > A: Tomcat Users List > Oggetto: Re: jdbc check available database > >> Hello guys, >> >> I’ve SQL Server database with Tomcat 7 and, when I restart only > database,

Re: jdbc check available database

2016-08-02 Thread Christoph Nenning
> 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

Re: JDBC Connection pooling

2016-01-26 Thread Felix Schumacher
Am 22.01.2016 um 12:35 schrieb R. Sriram: Hello I am trying to establish connection pooling. Should I be using dbcp? If you want to use db connection pooling, it is probably a good idea to use the pooling method the container gives you, as it will be used by a lot of people and therefore has go

Re: JDBC PoolExhaustedException

2015-10-13 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Nathan, On 10/9/15 4:11 PM, Nathan Boyce wrote: > Does the tomcat jdbc pool use its own executor or does it share > the executor that's calling it? A connection pool rarely has a thread pool associated with it: it's just a repository for connection

Re: JDBC Realm & exceptions

2015-02-20 Thread Leonid Rozenblyum
Thanks for the idea with the view! On Thu, Feb 19, 2015 at 9:03 PM, Felix Schumacher wrote: > Am 19.02.2015 um 13:58 schrieb Leonid Rozenblyum: >> >> I'm sorry for the late response. >> >> 1. After deeper check I see our structure is NOT much more complex >> than standard Tomcat structure. >> Act

Re: JDBC Realm & exceptions

2015-02-19 Thread Felix Schumacher
Am 19.02.2015 um 13:58 schrieb Leonid Rozenblyum: I'm sorry for the late response. 1. After deeper check I see our structure is NOT much more complex than standard Tomcat structure. Actually the significant difference is : user roles table has foreign key to id in users table (so we join by id n

Re: JDBC Realm & exceptions

2015-02-19 Thread Leonid Rozenblyum
I'm sorry for the late response. 1. After deeper check I see our structure is NOT much more complex than standard Tomcat structure. Actually the significant difference is : user roles table has foreign key to id in users table (so we join by id not by username) 2. Great news about fix in 8.0.19!

Re: JDBC Realm & exceptions

2015-02-05 Thread Felix Schumacher
Am 5. Februar 2015 22:21:38 MEZ, schrieb Leonid Rozenblyum : >Hello Felix! >Thanks for the detail answer! Good suggestion about DataSourceRealm! >(I thought about this possibility but then I discovered that we have >extended JDBCRealm to support some complex DB structure so maybe this >switch t

Re: JDBC Realm & exceptions

2015-02-05 Thread Leonid Rozenblyum
Hello Felix! Thanks for the detail answer! Good suggestion about DataSourceRealm! (I thought about this possibility but then I discovered that we have extended JDBCRealm to support some complex DB structure so maybe this switch to another Realm is not SO easy as it should be). Is it a good idea t

Re: JDBC Realm & exceptions

2015-02-05 Thread Felix Schumacher
Hi Leonid, Am 05.02.2015 um 16:28 schrieb Leonid Rozenblyum: Hello! After upgrading from Tomcat7 to Tomcat8 we started facing exceptions: rg.apache.catalina.realm.JDBCRealm getPassword SEVERE: Exception performing authentication org.postgresql.util.PSQLException: This statement has been closed

Re: JDBC authentication problem

2015-02-05 Thread Christopher Schultz
or not? JDBCRealm is pretty stupid. - -chris > De : Felix Schumacher > Envoyé : mercredi 4 février > 2015 20:11 À : Tomcat Users List Objet : Re: JDBC authentication > problem > > Am 04.02.2015 um 14:21 schrieb Luc DALLEMANE: >>

RE: JDBC authentication problem

2015-02-05 Thread Felix Schumacher
l" connexion. > >With this, we are now able to connect to the site even after a long >period of inactivity. > >Thank you for your help, and maybe this could help someone else. > >Regards, Luc. >________ >De : Felix Schumacher >Envoy

RE: JDBC authentication problem

2015-02-05 Thread Luc DALLEMANE
ld help someone else. Regards, Luc. De : Felix Schumacher Envoyé : mercredi 4 février 2015 20:11 À : Tomcat Users List Objet : Re: JDBC authentication problem Am 04.02.2015 um 14:21 schrieb Luc DALLEMANE: > Hi, > > I'm back again with the probl

Re: JDBC authentication problem

2015-02-04 Thread Felix Schumacher
onstantin Kolinko Envoyé : mardi 3 février 2015 12:33 À : Tomcat Users List Objet : Re: JDBC authentication problem 2015-02-03 14:29 GMT+03:00 Luc DALLEMANE : Hi, Thanks for the reply, I tried to add the options you told me about (testWhileIdle, timeBetweenEvictionRunsMillis, and maxConnLifetimeMilli

RE: JDBC authentication problem

2015-02-04 Thread Luc DALLEMANE
uch a long period of trying to connect. Thank you again for your ideas and haven't found a solution. Regards, Luc. De : Konstantin Kolinko Envoyé : mardi 3 février 2015 12:33 À : Tomcat Users List Objet : Re: JDBC authentication problem 2015-02-03 14:2

Re: JDBC authentication problem

2015-02-03 Thread Konstantin Kolinko
2015-02-03 14:29 GMT+03:00 Luc DALLEMANE : > Hi, > > Thanks for the reply, I tried to add the options you told me about > (testWhileIdle, timeBetweenEvictionRunsMillis, and maxConnLifetimeMillis), > but I'm still unable to log after un hour ... Do you have validationQuery configured? testOnBorr

RE: JDBC authentication problem

2015-02-03 Thread Luc DALLEMANE
), because nobody have a solution for this in mine. Thank you for your help !! And if you have another idea... you're welcome again. Regards, Luc. De : Felix Schumacher Envoyé : lundi 2 février 2015 18:59 À : Tomcat Users List Objet : Re: JDBC authenti

Re: JDBC authentication problem

2015-02-02 Thread Felix Schumacher
onnections (but why should I use a pool then?). Hope this helps Felix -Message d'origine- De : Christopher Schultz [mailto:ch...@christopherschultz.net] Envoyé : lundi 2 février 2015 16:19 À : Tomcat Users List Objet : Re: JDBC authentication problem -BEGIN PGP SIGNED MESSA

RE: JDBC authentication problem

2015-02-02 Thread Luc DALLEMANE
I'm using the DataSourceRealm provided with Tomcat7. -Message d'origine- De : Christopher Schultz [mailto:ch...@christopherschultz.net] Envoyé : lundi 2 février 2015 16:19 À : Tomcat Users List Objet : Re: JDBC authentication problem -BEGIN PGP SIGNED MESSAGE- Hash: SHA

Re: JDBC authentication problem

2015-02-02 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Luc, On 2/2/15 6:11 AM, Luc DALLEMANE wrote: > I tried to switch to DataSourceRealm but my problem is here again. > > After a while, the authentication is still impossible. Maybe i > have missed something about the DataSource in the doc but I'm abl

Re: JDBC Fails to connect to SQL Server

2015-02-02 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Aniket, On 2/2/15 3:09 AM, Aniket Bhoi wrote: > On Fri, Jan 30, 2015 at 10:37 PM, Christopher Schultz < > ch...@christopherschultz.net> wrote: > >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 >> >> Aniket, >> >> On 1/30/15 10:01 AM, Aniket B

RE: JDBC authentication problem

2015-02-02 Thread Luc DALLEMANE
work admin looked the firewall config and told me the config was OK ... So, if you have any idea, you're welcome ! Regards, Luc. De : Luc DALLEMANE Envoyé : vendredi 30 janvier 2015 15:39 À : Tomcat Users List Objet : RE: JDBC authentication problem O

Re: JDBC Fails to connect to SQL Server

2015-02-02 Thread Aniket Bhoi
On Fri, Jan 30, 2015 at 10:37 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Aniket, > > On 1/30/15 10:01 AM, Aniket Bhoi wrote: > > I have Apache Solr hosted on Tomcat 6. > > > > There have been no changes to the code on Tomc

Re: JDBC Fails to connect to SQL Server

2015-01-30 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Aniket, On 1/30/15 10:01 AM, Aniket Bhoi wrote: > I have Apache Solr hosted on Tomcat 6. > > There have been no changes to the code on Tomcat whatsoever.However > for the last few days I now see this error in the Log files: > > SEVERE: Full Import

Re: JDBC Fails to connect to SQL Server

2015-01-30 Thread Jeff Kohut
On Fri, Jan 30, 2015 at 9:01 AM, Aniket Bhoi wrote: > Hi, > > I have Apache Solr hosted on Tomcat 6. > > There have been no changes to the code on Tomcat whatsoever.However for the > last few days I now see this error in the Log files: > > SEVERE: Full Import failed > Throwable occurred: > org.ap

RE: JDBC authentication problem

2015-01-30 Thread Luc DALLEMANE
Ok, I'm going to try this. Hope this will help to solve my problem. Regards Luc D. -Message d'origine- De : Christopher Schultz [mailto:ch...@christopherschultz.net] Envoyé : vendredi 30 janvier 2015 15:24 À : Tomcat Users List Objet : Re: JDBC authentication problem

Re: JDBC authentication problem

2015-01-30 Thread Christopher Schultz
be ok and in production . (But didn't saw i had > paste it ...) Good. :) - -chris > -Message d'origine- De : Konstantin Kolinko > [mailto:knst.koli...@gmail.com] Envoyé : vendredi 30 janvier 2015 > 14:52 À : Tomcat Users List Objet : Re: JDBC authentication > prob

RE: JDBC authentication problem

2015-01-30 Thread Luc DALLEMANE
@gmail.com] Envoyé : vendredi 30 janvier 2015 14:52 À : Tomcat Users List Objet : Re: JDBC authentication problem 2015-01-30 16:45 GMT+03:00 Luc DALLEMANE : > Hi, > > > I'm facing a problem with my web application. > > > I'm using Tomcat 7.0.56, Java 1.8, Postgres

Re: JDBC authentication problem

2015-01-30 Thread Konstantin Kolinko
2015-01-30 16:45 GMT+03:00 Luc DALLEMANE : > Hi, > > > I'm facing a problem with my web application. > > > I'm using Tomcat 7.0.56, Java 1.8, Postgres 9.4 and Debian 7. > > The application is configured as followed : > > > The web server is located in a DMZ. > > The database server is located in ou

Re: JDBC-Pool: Reconnect the connection upon failures; retry queries; etc.

2014-06-19 Thread Miroslav Nachev
Hi Chris, There are 2 cases: - When we try to execute some statement and the connection is lost, we would like to retry some times, to show Popup Window to the client with notification, etc. - We have application, which depends on another database application. If the connection to

Re: JDBC-Pool: Reconnect the connection upon failures; retry queries; etc.

2014-06-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Miro, On 6/19/14, 9:42 AM, Miroslav Nachev wrote: > Is it possible to configure JDBC-Pool for the following > functionality or I need to write my own interceptors and > Validator? > > - Retry N times to getConnection() for OnBorrow/OnConnect and >

Re: jdbc connection pool, hanging threads and same physical connection usage

2013-05-28 Thread Daniel Mikusa
On May 27, 2013, at 7:40 AM, Huub Sepers wrote: > Hi, > > > > We are experiencing some problems while using the tomcat jdbc pool. > > > > Tomcat version: apache-tomcat-7.0.29 Try the latest version. Your's is pretty old. > > Pool settings: > > factory="org.apache.tomcat.jdbc.pool.Data

Re: [jdbc-pool] Transaction left open by the connection validation mechanism ?

2013-01-04 Thread Davoust, Pascal
Sorry, I probably did not make myself clear. I certainly do not suggest to issue the rollback on each connection checkout, but only as part of the validation process - because this is where the problem lies and only there - which I would imagine is triggered only occasionally (when connection is i

Re: [jdbc-pool] Transaction left open by the connection validation mechanism ?

2013-01-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Pascal, On 1/4/13 5:56 PM, Davoust, Pascal wrote: > Indeed I was referring to the tomcat jdbc-pool code, not mine :-). > > Now, I would suggest to consider that this problem is more common > than you could imagine at first sight. First because this

Re: [jdbc-pool] Transaction left open by the connection validation mechanism ?

2013-01-04 Thread Davoust, Pascal
Indeed I was referring to the tomcat jdbc-pool code, not mine :-). Now, I would suggest to consider that this problem is more common than you could imagine at first sight. First because this is randomly occuring, but frequently enough so that it shows up in quite a few areas. A few examples where

Re: [jdbc-pool] Transaction left open by the connection validation mechanism ?

2013-01-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Pid, On 1/4/13 4:26 PM, Pid wrote: > On 04/01/2013 20:34, Christopher Schultz wrote: >> On 1/3/13 12:49 PM, Davoust, Pascal wrote: >>> >>> I then had a look at the corresponding code into the tomcat >>> jdbc pool (source 7.0.34), and more specifica

Re: [jdbc-pool] Transaction left open by the connection validation mechanism ?

2013-01-04 Thread Pid
On 04/01/2013 20:34, Christopher Schultz wrote: > Pascal, > > On 1/3/13 12:49 PM, Davoust, Pascal wrote: >> I'm using the tomcat jdbc connection pool (7.0.34) to connect >> against a PostgreSQL database (version 8.4 - jdbc driver 9.0.801) >> and I'm having a potentially dodgy situation with the va

Re: [jdbc-pool] Transaction left open by the connection validation mechanism ?

2013-01-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Pascal, On 1/3/13 12:49 PM, Davoust, Pascal wrote: > I'm using the tomcat jdbc connection pool (7.0.34) to connect > against a PostgreSQL database (version 8.4 - jdbc driver 9.0.801) > and I'm having a potentially dodgy situation with the validation

Re: jdbc connection debugging, tips?

2012-11-13 Thread S Ahmed
Ok it turns out it was bound to an private ip address on ec2, thanks Dan! On Tue, Nov 13, 2012 at 10:52 PM, S Ahmed wrote: > ubuntu:~$ mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 58 > Server version: 5.1.63-0ubuntu

Re: jdbc connection debugging, tips?

2012-11-13 Thread S Ahmed
ubuntu:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 58 Server version: 5.1.63-0ubuntu0.11.04.1-log (Ubuntu) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of

Re: jdbc connection debugging, tips?

2012-11-13 Thread S Ahmed
I'll report back tonight, thanks again! On Tue, Nov 13, 2012 at 11:08 AM, Daniel Mikusa wrote: > On Nov 13, 2012, at 9:55 AM, S Ahmed wrote: > > > Dan, > > > > Thanks for your help. > > > > From the terminal I was very explicit, I did this: > > > >> mysql --host localhost --port 3306 --user myu

Re: jdbc connection debugging, tips?

2012-11-13 Thread Daniel Mikusa
On Nov 13, 2012, at 9:55 AM, S Ahmed wrote: > Dan, > > Thanks for your help. > > From the terminal I was very explicit, I did this: > >> mysql --host localhost --port 3306 --user myuser --password >> password: 123 > > And it worked fine. In my log4net, I believe I set jdbc logs to be ALL or >

Re: jdbc connection debugging, tips?

2012-11-13 Thread S Ahmed
Dan, Thanks for your help. >From the terminal I was very explicit, I did this: >mysql --host localhost --port 3306 --user myuser --password >password: 123 And it worked fine. In my log4net, I believe I set jdbc logs to be ALL or DEBUG (i'll check when I get home), but it didn't output the host

Re: jdbc connection debugging, tips?

2012-11-13 Thread Daniel Mikusa
On Nov 12, 2012, at 10:55 PM, S Ahmed wrote: > I can't seem to connect to my mysql database from my java code, but I can > do it via terminal using the user and password that is in my spring context > file. > > I also tried modifying it to localhost:3306 but that didn't change anything > (it defa

Re: jdbc connection debugging, tips?

2012-11-12 Thread S Ahmed
This same setup works fine locally on my laptop..so it does work :) On Mon, Nov 12, 2012 at 10:55 PM, S Ahmed wrote: > I can't seem to connect to my mysql database from my java code, but I can > do it via terminal using the user and password that is in my spring context > file. > > I also tried

RE: JDBC Connection over VPN

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

RE: JDBC Connection over VPN

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

Re: JDBC Connection over VPN

2012-05-07 Thread Saurabh Makol
m: 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 or Oracle > usually does? Like something at 8080? > > No

RE: JDBC Connection over VPN

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

RE: JDBC Connection over VPN

2012-05-07 Thread Propes, Barry L
Could the VPN connection be utlizing the same port Tomcat or Oracle usually does? Like something at 8080? Not sure if that's the case; or conversely, does going into VPN block those ports? -Original Message- From: Sanjeev Sharma [mailto:sanjeev.sha...@buchanan-edwards.com] Sent: Monday

Re: jdbc pool properties

2012-04-06 Thread S Ahmed
I'm using tomcat 7, in a spring mvc application. The properties is in my spring-context.xml file. On Fri, Apr 6, 2012 at 2:09 PM, Christopher Schultz < ch...@christopherschultz.n

Re: jdbc pool properties

2012-04-06 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Daniel, On 4/4/12 8:46 AM, Daniel Mikusa wrote: > - Original Message - >> 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 res

Re: jdbc pool properties

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

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

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

Re: jdbc pool properties

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

RE: jdbc pool properties

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

Re: jdbc pool properties

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

Re: jdbc pool properties

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2012-03-28 Thread Filip Hanik (mailing lists)
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 [mailto:mic

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

2012-03-28 Thread Osipov, Michael
Konstantin Kolinko wrote: > 2012/3/28 Osipov, Michael : >> Hi folks, >> >> Recently this started to pop up in my logs: >> 23.03.2012 14:12:28 org.apache.catalina.loader.WebappClassLoader >> clearReferencesThreads >> SCHWERWIEGEND: The web application [/ket] appears to have started a >> thread nam

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

2012-03-28 Thread Konstantin Kolinko
2012/3/28 Osipov, Michael : > Hi folks, > > Recently this started to pop up in my logs: > 23.03.2012 14:12:28 org.apache.catalina.loader.WebappClassLoader > clearReferencesThreads > SCHWERWIEGEND: The web application [/ket] appears to have started a thread > named [PoolCleaner[18291494:1332172047

Re: jdbc driver location in TC 7

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

Re: jdbc driver location in TC 7

2012-03-26 Thread Pid
On 26/03/2012 12:30, Terence M. Bandoian wrote: > On 1:59 PM, Pid * wrote: >> On 25 Mar 2012, at 03:10, "Terence M. Bandoian" >> wrote: >> >>> On 1:59 PM, Pid * wrote: On 23 Mar 2012, at 21:59, David Kerber wrote: > On 3/23/2012 6:51 PM, Terence M. Bandoian wrote: >> On 1:59 P

Re: jdbc driver location in TC 7

2012-03-26 Thread Terence M. Bandoian
On 1:59 PM, Pid * wrote: On 25 Mar 2012, at 03:10, "Terence M. Bandoian" wrote: On 1:59 PM, Pid * wrote: On 23 Mar 2012, at 21:59, David Kerber wrote: On 3/23/2012 6:51 PM, Terence M. Bandoian wrote: On 1:59 PM, David kerber wrote: On 3/23/2012 11:19 AM, Caldarale, Charles R wrote: Fr

  1   2   3   4   >