Re: Tomcat 9.0.0-M4 seems not to start digest algorithm on JDBC Realm as did tomcat 8.0.25

2016-04-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Fabio, On 4/24/16 11:36 AM, Fabio Ricci wrote: > appreciate the sunday answer (thank you). > > To say the truth: I did read the documentation and the migration > guide. > > But since there are no examples in > http://tomcat.apache.org/tomcat-8.0-do

Re: Tomcat 9.0.0-M4 seems not to start digest algorithm on JDBC Realm as did tomcat 8.0.25

2016-04-24 Thread Fabio Ricci
appreciate the sunday answer (thank you). To say the truth: I did read the documentation and the migration guide. But since there are no examples in http://tomcat.apache.org/tomcat-8.0-doc/config/credentialhandler.html, I did not manage to create my own implementation concreteness. That’s why I

Re: Tomcat 9.0.0-M4 seems not to start digest algorithm on JDBC Realm as did tomcat 8.0.25

2016-04-24 Thread Mark Thomas
On 22/04/2016 23:35, Fabio Ricci wrote: > Dear tomcat Community > > I am using cross context (which seems to be easy to configure but in in > tomcat 8 hard to run) … so today I downloaded tomcat 9 and I migrated my > apps to it. > In tomcat 9 cross context is running smoothly (thank you!) > > To

Tomcat 9.0.0-M4 seems not to start digest algorithm on JDBC Realm as did tomcat 8.0.25

2016-04-22 Thread Fabio Ricci
Dear tomcat Community I am using cross context (which seems to be easy to configure but in in tomcat 8 hard to run) … so today I downloaded tomcat 9 and I migrated my apps to it. In tomcat 9 cross context is running smoothly (thank you!) To authenticate my config is using JDBCRealm with a mysql

Re: Determine jdbc driver loaded in running Tomcat instance

2016-04-21 Thread tomcat
On 21.04.2016 18:17, John Beaulaurier -X (jbeaulau - ADVANCED NETWORK INFORMATION INC at Cisco) wrote: Hello, Is there a method to determine what jdbc driver a running Tomcat instance loaded and is running? Since I suppose that this must be possible using JMX, here is a reminder for a nifty

Determine jdbc driver loaded in running Tomcat instance

2016-04-21 Thread John Beaulaurier -X (jbeaulau - ADVANCED NETWORK INFORMATION INC at Cisco)
Hello, Is there a method to determine what jdbc driver a running Tomcat instance loaded and is running? Thank you -John

Re: Updating jdbc drivers Tomcat 7

2016-04-19 Thread Mark Thomas
pache.org] > Sent: Tuesday, April 19, 2016 12:27 PM > To: Tomcat Users List > Subject: Re: Updating jdbc drivers Tomcat 7 > > On 19/04/2016 20:25, John Beaulaurier -X (jbeaulau - ADVANCED NETWORK > INFORMATION INC at Cisco) wrote: >> Hello, >> >> Reading the T

RE: Updating jdbc drivers Tomcat 7

2016-04-19 Thread John Beaulaurier -X (jbeaulau - ADVANCED NETWORK INFORMATION INC at Cisco)
Thanks Mark, Do I have the procedure correct? -Original Message- From: Mark Thomas [mailto:ma...@apache.org] Sent: Tuesday, April 19, 2016 12:27 PM To: Tomcat Users List Subject: Re: Updating jdbc drivers Tomcat 7 On 19/04/2016 20:25, John Beaulaurier -X (jbeaulau - ADVANCED NETWORK

Re: Updating jdbc drivers Tomcat 7

2016-04-19 Thread Mark Thomas
On 19/04/2016 20:25, John Beaulaurier -X (jbeaulau - ADVANCED NETWORK INFORMATION INC at Cisco) wrote: > Hello, > > Reading the Tomcat documentation, to upgrade jdbc drivers one would perform > the following. > > 1. Shutdown the Tomcat instance(s) > > 2.

Updating jdbc drivers Tomcat 7

2016-04-19 Thread John Beaulaurier -X (jbeaulau - ADVANCED NETWORK INFORMATION INC at Cisco)
Hello, Reading the Tomcat documentation, to upgrade jdbc drivers one would perform the following. 1. Shutdown the Tomcat instance(s) 2. Remove the current jdbc driver in the base /lib directory then copy new driver to the directory 3. Restart the Tomcat instance(s) and the

Re: Encrypted jdbc

2016-04-11 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Harrie, On 4/11/16 4:10 AM, Harrie Robins wrote: >> From MariaDB manual: > > have_openssl > > Description: Before MariaDB 10.0.1, have_openssl was an alias for > have_ssl. Since MariaDB 10.0.1, comparing have_openssl with > have_ssl will indicate wh

RE: Encrypted jdbc

2016-04-11 Thread Harrie Robins
:26 To: Tomcat Users List Subject: Re: Encrypted jdbc -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Harrie, On 4/7/16 4:55 PM, Harrie Robins wrote: > I found MySQL easy to setup. I suspect MariaDB would be setup similar, > here a small example: > > Generate keys / certifi

Re: Encrypted jdbc

2016-04-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Harrie, On 4/7/16 4:55 PM, Harrie Robins wrote: > I found MySQL easy to setup. I suspect MariaDB would be setup > similar, here a small example: > > Generate keys / certificate's: > http://dev.mysql.com/doc/refman/5.5/en/creating-ssl-certs.html > >

RE: Encrypted jdbc

2016-04-07 Thread Harrie Robins
et.ssl.keyStorePassword","password"); System.setProperty("javax.net.ssl.trustStore","path_to_truststore_file"); System.setProperty("javax.net.ssl.trustStorePassword","password"); Add to JDBC connectionstring the following: connectionURL=&quo

Re: Encrypted jdbc

2016-04-07 Thread Christopher Schultz
OS Version: >>> 2.6.32-573.8.1.el6.x86_64 JVM Version:1.8.0_66-b17 = >>> >>> Back end database is mariadb residing on a another remote linux >>> instance. I have downloaded and copied the Mariadb jdbc driver to >>> the lib directory of the TC serve

Re: Encrypted jdbc

2016-04-07 Thread Mark Eggers
t;> >> Back end database is mariadb residing on a another remote linux >> instance. I have downloaded and copied the Mariadb jdbc driver to >> the lib directory of the TC server. >> >> Can you let me know how to encrypt the database connectivity from >> the TC

Re: Encrypted jdbc

2016-04-07 Thread Christopher Schultz
emote linux instance. I > have downloaded and copied the Mariadb jdbc driver to the lib directory of > the TC server. > > Can you let me know how to encrypt the database connectivity from the TC > instance to the DB instance. Just to confirm: you want to encrypt the communication chan

Re: Encrypted jdbc

2016-04-07 Thread Linux Support
t; > > Greetings all, > > > > = > > Server number: 8.0.28.0 > > OS Name:Linux > > OS Version: 2.6.32-573.8.1.el6.x86_64 > > JVM Version:1.8.0_66-b17 > > = > > > > Back end database is mariadb residing on a another remote linux > inst

Re: Encrypted jdbc

2016-04-07 Thread Tommy Pham
; Back end database is mariadb residing on a another remote linux instance. I > have downloaded and copied the Mariadb jdbc driver to the lib directory of > the TC server. > > Can you let me know how to encrypt the database connectivity from the TC > instance to the DB instance. > > thanks > OSP >

Encrypted jdbc

2016-04-07 Thread Linux Support
Greetings all, = Server number: 8.0.28.0 OS Name:Linux OS Version: 2.6.32-573.8.1.el6.x86_64 JVM Version:1.8.0_66-b17 = Back end database is mariadb residing on a another remote linux instance. I have downloaded and copied the Mariadb jdbc driver to the lib directory of

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

JDBC Connection pooling

2016-01-22 Thread R. Sriram
Hello I am trying to establish connection pooling. Should I be using dbcp? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org

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

2015-12-18 Thread Robert Anderson
> > > public Object invoke(Object proxy, Method method, Object[] args) > throws > > Throwable { > > if (method.getName() == CLOSE_VAL) { > > System.out.println("Interceptor called."); //Doesn't happen > but > > connect

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

2015-12-17 Thread Keiichi Fujino
(checked via JMX) > } > return super.invoke(proxy, method, args); > } > > --> JSP to simulate long running query > > <%@ page session="false" import="java.sql.*,javax.naming.*, javax.sql.*, > java.util.*" contentType="te

[Tomcat-JDBC] RemovedAbandoned doesn't trigger JdbcInterceptors

2015-12-17 Thread Robert Anderson
gs); } --> JSP to simulate long running query <%@ page session="false" import="java.sql.*,javax.naming.*, javax.sql.*, java.util.*" contentType="text/html" %><% Connection conn = null; try { Context ctx = new InitialContext(); DataSource

[Tomcat-JDBC] ResetAbandoned doesn't trigger JdbcInterceptors

2015-12-17 Thread Robert Anderson
gs); } --> JSP to simulate long running query <%@ page session="false" import="java.sql.*,javax.naming.*, javax.sql.*, java.util.*" contentType="text/html" %><% Connection conn = null; try { Context ctx = new InitialContext(); DataSource

SV: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver '"

2015-11-10 Thread Simon Kepp Nielsen
. -Oprindelig meddelelse- Fra: Felix Schumacher [mailto:felix.schumac...@internetallee.de] Sendt: 10. november 2015 15:15 Til: Tomcat Users List Emne: Re: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver '" Am 10. November 2015 15:06:09 MEZ, schrieb Simon Kepp Ni

Re: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver '"

2015-11-10 Thread Felix Schumacher
s the >test jsp page, I get the following error: >javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable >to get connection, DataSource invalid: >"org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC >driver class 'oracle.jdbc.driver.OracleDriver '&qu

Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver '"

2015-11-10 Thread Simon Kepp Nielsen
ar to $CATALINA_HOME\lib, but when I acces the test jsp page, I get the following error: javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driv

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 J

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 >

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

JDBC PoolExhaustedException

2015-10-09 Thread Nathan Boyce
Does the tomcat jdbc pool use its own executor or does it share the executor that's calling it? Reason I ask is the pool size is set to 320 but only 84 show busy. The default tomcatThreadPool executor has been removed from this config and executor with the name AJPThreadPool has been

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 can't find JDBC Driver listed under Maven

2015-08-29 Thread Sreyan Chakravarty
ject which > > uses Maven as a build tool. Now the JDBC Driver is listed as a > > maven dependency. Tomcat however cant find it when I try to do > > > > ds.getConnection (ie. get a JDBC connection from a datasource). > > > > The error that I am getting is -: > &

Re: Tomcat can't find JDBC Driver listed under Maven

2015-08-28 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Sreyan, On 8/28/15 3:11 PM, Sreyan Chakravarty wrote: > Okay I am trying to use connection pooling for my project which > uses Maven as a build tool. Now the JDBC Driver is listed as a > maven dependency. Tomcat however cant find it when

Tomcat can't find JDBC Driver listed under Maven

2015-08-28 Thread Sreyan Chakravarty
Okay I am trying to use connection pooling for my project which uses Maven as a build tool. Now the JDBC Driver is listed as a maven dependency. Tomcat however cant find it when I try to do ds.getConnection (ie. get a JDBC connection from a datasource). The error that I am getting is

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

Re: Tomcat JDBC vs DBCP2?

2015-06-03 Thread Mark Thomas
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 curiou

Re: Tomcat JDBC vs DBCP2?

2015-06-03 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 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... I am using Tomcat JDBC

Tomcat JDBC vs DBCP2?

2015-06-03 Thread Bjørn T Johansen
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... I am using Tomcat JDBC, because I read somewhere that this was better than DBCP (guess they were talking about DBCP 1 then). Does this

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: tomcat-jdbc PoolCleaner deadlock

2015-02-06 Thread Filip Hanik
t;> > pool sweeper is enabled if any settings that require async > intervention > >> in > >> > the pool are turned on boolean result = > >> > getTimeBetweenEvictionRunsMillis()>0; result = result && > >> > (isRemoveAbandoned() && getRemov

Re: tomcat-jdbc PoolCleaner deadlock

2015-02-06 Thread Robert Anderson
bandoned() && getRemoveAbandonedTimeout()>0); result = result >> || >> > (isTestWhileIdle() && getValidationQuery()!=null); return result;" [1] >> > >> > Best regards. >> > >> > >> > [1] >> > >> > >> https://to

Re: Issue when using tomcat JDBC Connection Pool with a shared resource

2015-02-06 Thread Daniel Mikusa
lated, but don't set "path" here. The path attribute is > ignore here. The path is determined by the name of the xml file, which > just happens to be "test-app" as well. > OK. "path" is no longer set. > > > Do you have anything set in "conf/con

RE: Issue when using tomcat JDBC Connection Pool with a shared resource

2015-02-06 Thread MWick
> -Original Message- > From: Daniel Mikusa [mailto:dmik...@pivotal.io] > Sent: Friday, February 06, 2015 8:06 AM > To: Tomcat Users List > Subject: Re: Issue when using tomcat JDBC Connection Pool with a shared > resource > > On Fri, Feb 6, 2015 at 6:27 AM, Je

Re: Issue when using tomcat JDBC Connection Pool with a shared resource

2015-02-06 Thread Daniel Mikusa
On Fri, Feb 6, 2015 at 6:27 AM, Jean-Louis Mateo wrote: > Hi, > > > > I would like to use the Tomcat JDBC Connection Pool with a shared resource > so I’ve read : > > http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html#Standalone and > http://tomcat.apach

Issue when using tomcat JDBC Connection Pool with a shared resource

2015-02-06 Thread Jean-Louis Mateo
Hi, I would like to use the Tomcat JDBC Connection Pool with a shared resource so I've read : http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html#Standalone and http://tomcat.apache.org/tomcat-7.0-doc/config/context.html#Resource_Links and tried to do the same but when I try to a

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

JDBC Realm & exceptions

2015-02-05 Thread 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. They look like not giving any harm (?). Could we do anything

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
quot; (at least according to http://commons.apache.org/proper/commons-dbcp/configuration.html) or in the jdbc url jdbc://...?tcpKeepAlive=true. You can even specify the timeout for connnecting to your database. Regards Felix Regards, Luc. De : K

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
GIN PGP SIGNATURE- Version: GnuPG v1 Comment: >> GPGTools - http://gpgtools.org > > > > Thanks Jeff, > > Let me check if there has been any such problem. > > Hi Chris, > > I do not have the resource configured in either context.xml or in > server.xml,it

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: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
sult && > > (isRemoveAbandoned() && getRemoveAbandonedTimeout()>0); result = result > || > > (isTestWhileIdle() && getValidationQuery()!=null); return result;" [1] > > > > Best regards. > > > > > > [1] > > > > >

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Filip Hanik
idationQuery()!=null); return result;" [1] > > Best regards. > > > [1] > > https://tomcat.apache.org/tomcat-7.0-doc/api/org/apache/tomcat/jdbc/pool/PoolConfiguration.html#isPoolSweeperEnabled() > > 2015-01-30 16:13 GMT-03:00 Filip Hanik : > > > Are you seeing tha

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
sRemoveAbandoned() && getRemoveAbandonedTimeout()>0); result = result || (isTestWhileIdle() && getValidationQuery()!=null); return result;" [1] Best regards. [1] https://tomcat.apache.org/tomcat-7.0-doc/api/org/apache/tomcat/jdbc/pool/PoolConfiguration.html#isPoolSweeperEnabled() 2015-01

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Filip Hanik
e connection pool evicter thread > interval is set to lower than 1 second."); > } > > > > [1] > http://svn.apache.org/repos/asf/tomcat/tc7.0.x/trunk/modules/jdbc-pool/src/main/java/org/apache/tomcat/jdbc/pool/ConnectionPool.java > > > 2015-01-30 15:

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Filip Hanik
sult || (timer && isTestWhileIdle() && getValidationQuery()!=null); 924 result = result || ( timer && getMinEvictableIdleTimeMillis()>0); 925 return result; 926 } On Fri, Jan 30, 2015 at 11:17 AM, Robert Anderson wrote: > Sorry, > > [1] https://people.apache.org/~

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
} else if (sleepTime < 1000) { log.warn("Database connection pool evicter thread interval is set to lower than 1 second."); } [1]http://svn.apache.org/repos/asf/tomcat/tc7.0.x/trunk/modules/jdbc-pool/src/main/java/org/apache/tomcat/jdbc/pool/ConnectionPool.java

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
Sorry, [1] https://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html 2015-01-30 15:15 GMT-03:00 Robert Anderson : > Filip, > > however, disabling the pool cleaner it should yield better results. > > The documention[1] says: > > "This value should not be set unde

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
s all in the > intersys traces. Furthermore, it seems as intersys may already be doing > pooling inside the driver. If that is the case, you have two options > > 1. disable pooling in intersys OR > 2. don't use tomcat's jdbc pool since intersys already does pooling > > howe

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Filip Hanik
Looking at the locks that are involved in the dead lock, it's all in the intersys traces. Furthermore, it seems as intersys may already be doing pooling inside the driver. If that is the case, you have two options 1. disable pooling in intersys OR 2. don't use tomcat's jdbc pool

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Filip Hanik
Disable the pool cleaner timeBetweenEvictionRunsMillis=0

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Felix Schumacher
Am 30.01.2015 um 18:44 schrieb Robert Anderson: Could you post a full stacktrace, or threaddump? "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - DB:DATASOURCE(java:/comp/env/jdbc/cacheapp)" daemon prio=10 tid=0x13bb nid=0x7a6d waiting for monitor entry [0x00

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
Could you post a full stacktrace, or threaddump? "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - DB:DATASOURCE(java:/comp/env/jdbc/cacheapp)" daemon prio=10 tid=0x13bb nid=0x7a6d waiting for monitor entry [0x5125b000] java.lang.Thread.State: BLOCKED (on obje

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
56 > > Robert, > > On 1/30/15 12:19 PM, Robert Anderson wrote: > > Every day we are getting deadlocks like that: > > > > Found one Java-level deadlock: = > > "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Felix Schumacher
Am 30.01.2015 um 18:19 schrieb Robert Anderson: Every day we are getting deadlocks like that: Found one Java-level deadlock: = "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - DB:DATASOURCE(java:/comp/env/jdbc/cacheapp)": waiting to lock monitor 0x00

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Christopher Schultz
OURCE(java:/comp/env/jdbc/cacheapp)": waiting to lock > monitor 0x1504e6d8 (object 0x00071ba001d0, a > com.intersys.jdbc.CacheConnection), which is held by > "PoolCleaner[1070846187:1422601344160]" > "PoolCleaner[1070846187:1422601344160]&qu

tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
Every day we are getting deadlocks like that: Found one Java-level deadlock: = "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - DB:DATASOURCE(java:/comp/env/jdbc/cacheapp)": waiting to lock monitor 0x1504e6d8 (object 0x00071

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

JDBC Fails to connect to SQL Server

2015-01-30 Thread Aniket Bhoi
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.apache.solr.handler.dataimport.DataImportHandlerException: Unable to exec

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
n a DMZ. > > The database server is located in our LAN. > > To communicate with each other, a firewall has been setup (Cisco asa firewall) > > > To authenticate an user to the website, I use the tomcat JDBC Realm. 1. Realm configuration =? Is it JDBCRealm or DataSourceRealm?

JDBC authentication problem

2015-01-30 Thread Luc DALLEMANE
l has been setup (Cisco asa firewall) To authenticate an user to the website, I use the tomcat JDBC Realm. At the beginning, everything works fine, but after about an hour of inactivity, its impossible to authenticate again : Tomcat process seems to be running but doesn't log anything and

Re: Occasional long wait for a JDBC connection

2015-01-14 Thread Filip Hanik
The timeout happens in your SocketRead, this is configurable (default is forever) http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html what appears to be happening is that somewhere there isn't a reset packet sent from the server to the JDBC driver. Se

Re: Occasional long wait for a JDBC connection

2015-01-14 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Darren, On 1/13/15 11:32 PM, Darren Davis wrote: > On Tue, Jan 13, 2015 at 8:39 PM, Christopher Schultz < > ch...@christopherschultz.net> wrote: > > Darren, > > (Sorry... just had to remove that monstrous stack trace...) > > On 1/13/15 5:04 PM,

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Darren Davis
On Tue, Jan 13, 2015 at 8:39 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Darren, > > (Sorry... just had to remove that monstrous stack trace...) > > On 1/13/15 5:04 PM, Darren Davis wrote: > > Hi Christopher. Yes, we've tr

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Darren, (Sorry... just had to remove that monstrous stack trace...) On 1/13/15 5:04 PM, Darren Davis wrote: > Hi Christopher. Yes, we've tried a show process list and can find > no evidence of the validation query running on mysql. Strange. Maybe

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Darren Davis
also coincided with creating a new > >> connection in the pool. It does not make any sense that the > >> simple validation query of "SELECT 1" would require a wait of 15 > >> minutes to succeed. > > > > Agreed. > > > >> It's also

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