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 >

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 <users@tomcat.apache.org> > 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, >>

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 <users@tomcat.apache.org> Subject: Re: Updating jdbc drivers Tomcat 7 On 19/04/2016 20:25, John Beaulaur

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

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

RE: Encrypted jdbc

2016-04-11 Thread Harrie Robins
:26 To: Tomcat Users List <users@tomcat.apache.org> 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: >

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
l.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="jdbc:mysql://ex

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 se

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

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

Re: Encrypted jdbc

2016-04-07 Thread Tommy Pham
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 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

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

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
't happen > but > > connection is really closed (checked via JMX) > > } > > return super.invoke(proxy, method, args); > > } > > > > --> JSP to simulate long running query > > > > <%@ page session="false" import="

[Tomcat-JDBC] ResetAbandoned doesn't trigger JdbcInterceptors

2015-12-17 Thread Robert Anderson
} --> 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 ds =

[Tomcat-JDBC] RemovedAbandoned doesn't trigger JdbcInterceptors

2015-12-17 Thread Robert Anderson
} --> 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 ds =

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

2015-12-17 Thread Keiichi Fujino
nnection is really closed (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.*&

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

2015-11-10 Thread Simon Kepp Nielsen
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.driver.OracleD

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

2015-11-10 Thread Felix Schumacher
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.driver.OracleDriver '&qu

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 Nielsen <s..

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: 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? > >

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 repo

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 added

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

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

2015-10-07 Thread Bradley Wagner
ot; 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 helpful to have a page on the >

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 Tomcat

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

2015-10-07 Thread Christopher Schultz
ng 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 it would be help

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-issue-between-jetty

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

2015-08-29 Thread Sreyan Chakravarty
. 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 -: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null

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

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 I try to do

Re: Tomcat JDBC vs DBCP2?

2015-06-04 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 curious... I am using Tomcat JDBC, because I

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

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, because I

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 felix.schumac...@internetallee.de 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

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

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 access

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, Jean-Louis Mateo jean- louis.ma

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

2015-02-06 Thread Daniel Mikusa
=jdbc/LocalTestDB E R R O R this jndi name doesn't exist global=sharedDataSource type=javax.sql.DataSource/ After, in my context file ResourceLink name=jdbc/TestDB - That's the right name

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 jean-louis.ma...@bull.net 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.apache.org/tomcat-7.0-doc

Re: tomcat-jdbc PoolCleaner deadlock

2015-02-06 Thread Robert Anderson
://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 fi...@hanik.com: Are you seeing that message, cause it seems to be a defensive check, but wouldn't happen due to 509 public void

Re: tomcat-jdbc PoolCleaner deadlock

2015-02-06 Thread Filip Hanik
|| (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-30 16:13 GMT-03:00 Filip Hanik fi...@hanik.com

Re: JDBC Realm exceptions

2015-02-05 Thread Felix Schumacher
Am 5. Februar 2015 22:21:38 MEZ, schrieb Leonid Rozenblyum lrozenbl...@gmail.com: 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

Re: JDBC authentication problem

2015-02-05 Thread Christopher Schultz
felix.schumac...@internetallee.de 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 problem :) Firstly, I add the validationQuery and it works and I can see

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

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

RE: JDBC authentication problem

2015-02-05 Thread Felix Schumacher
a long period of inactivity. Thank you for your help, and maybe this could help someone else. Regards, Luc. De : Felix Schumacher felix.schumac...@internetallee.de Envoyé : mercredi 4 février 2015 20:11 À : Tomcat Users List Objet : Re: JDBC authentication

RE: JDBC authentication problem

2015-02-05 Thread Luc DALLEMANE
. De : Felix Schumacher felix.schumac...@internetallee.de 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 problem :) Firstly, I

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

Re: JDBC authentication problem

2015-02-04 Thread Felix Schumacher
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 : Konstantin Kolinko knst.koli

RE: JDBC authentication problem

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

RE: JDBC authentication problem

2015-02-03 Thread Luc DALLEMANE
. Thank you for your help !! And if you have another idea... you're welcome again. Regards, Luc. De : Felix Schumacher felix.schumac...@internetallee.de Envoyé : lundi 2 février 2015 18:59 À : Tomcat Users List Objet : Re: JDBC authentication problem Am

Re: JDBC authentication problem

2015-02-03 Thread Konstantin Kolinko
2015-02-03 14:29 GMT+03:00 Luc DALLEMANE ldallem...@alaloop.com: 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

RE: JDBC authentication problem

2015-02-02 Thread Luc DALLEMANE
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 ldallem...@alaloop.com Envoyé : vendredi 30 janvier 2015 15:39 À : Tomcat Users List Objet : RE: JDBC authentication

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 able

Re: JDBC Fails to connect to SQL Server

2015-02-02 Thread Christopher Schultz
=jdbc:sqlserver://xxx-xxx:1433;databaseName=xxx user=xxx password=xxx/ Then this has nothing to do with Tomcat: you are using Solr's configuration with Microsoft's JDBC driver. You might get some help here due to the general nature of connection pools, firewalls, etc., but this isn't a Tomcat problem

RE: JDBC authentication problem

2015-02-02 Thread Luc DALLEMANE
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: SHA256 Luc, On 2

Re: JDBC authentication problem

2015-02-02 Thread Felix Schumacher
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 MESSAGE- Hash: SHA256 Luc, On 2/2/15 6:11 AM, Luc DALLEMANE

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 Tomcat

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: 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 0x1504e6d8

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 0x00071ba001d0

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 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:58 - DB:DATASOURCE(java:/comp/env/jdbc

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 aniket.b...@gmail.com 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

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
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 0x00071ba001d0, a com.intersys.jdbc.CacheConnection

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 ranom...@gmail.com: Filip, however, disabling the pool cleaner it should yield better results. The documention[1] says: This value should not be set under 1 second Isn't

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 [0x5125b000

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 since intersys

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
() 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-30 16:13 GMT-03:00 Filip Hanik fi...@hanik.com

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
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 however, disabling the pool cleaner it should yield

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 object monitor

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
= 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-30 16:13 GMT-03:00 Filip Hanik fi...@hanik.com

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 Filip Hanik
() getValidationQuery()!=null); 924 result = result || ( timer getMinEvictableIdleTimeMillis()0); 925 return result; 926 } On Fri, Jan 30, 2015 at 11:17 AM, Robert Anderson ranom...@gmail.com wrote: Sorry, [1] https://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html 2015-01-30 15:15 GMT-03:00 Robert

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Robert Anderson
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 2015-01-30 15:17 GMT-03:00

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Filip Hanik
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:17 GMT-03:00 Robert Anderson ranom...@gmail.com: Sorry, [1] https://people.apache.org/~fhanik/jdbc

Re: tomcat-jdbc PoolCleaner deadlock

2015-01-30 Thread Filip Hanik
] 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 fi...@hanik.com: Are you seeing that message, cause it seems to be a defensive check, but wouldn't happen due to 509 public void

RE: JDBC authentication problem

2015-01-30 Thread Luc DALLEMANE
] 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 ldallem...@alaloop.com: 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

Re: JDBC authentication problem

2015-01-30 Thread Christopher Schultz
. (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 problem 2015-01-30 16:45 GMT+03:00 Luc DALLEMANE ldallem

Re: JDBC authentication problem

2015-01-30 Thread Konstantin Kolinko
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? If it is the former, then your Resource is not used at all. 2

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 -BEGIN PGP

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

JDBC authentication problem

2015-01-30 Thread Luc DALLEMANE
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 doesn't answer

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, Darren

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. Setting

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
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 tried a show

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Christopher Schultz
validation query of SELECT 1 would require a wait of 15 minutes to succeed. Agreed. It's also strange that this only happens sporadically, and not every time a new connection is being birthed by the system. We've tried two different pooling technologies: DBCP and the new Apache JDBC pooling

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