RE: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Caldarale, Charles R
From: David kerber [mailto:dcker...@verizon.net] Subject: Re: Trouble with jdbc drivers in TC 7 Was something changed in 7 from previous versions wrt database connections? Even if it had been changed, it shouldn't matter in your case, since you're handling your own connections

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread David kerber
On 4/7/2011 3:28 PM, Caldarale, Charles R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: Re: Trouble with jdbc drivers in TC 7 Was something changed in 7 from previous versions wrt database connections? Even if it had been changed, it shouldn't matter in your case, since

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Christopher Schultz
[snip] I have also tried moving jodbc.jar to %catalina_home%/lib, but that didn't help either. Is this a pure Java driver? JDBC-ODBC drivers (which looks like yours might be) often have a native component. Could you be missing a shared library from your java.library.path? Sometimes, missing shared

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread David kerber
DB: Sybase ASA 9.0.2.3951, x64 version [snip] I have also tried moving jodbc.jar to %catalina_home%/lib, but that didn't help either. Is this a pure Java driver? JDBC-ODBC drivers (which looks like yours It is a jdbc-odbc bridge driver, and has windows dlls. might be) often have

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Christopher Schultz
:\Program Files\..., so it detected an x64 installation DB: Sybase ASA 9.0.2.3951, x64 version [snip] I have also tried moving jodbc.jar to %catalina_home%/lib, but that didn't help either. Is this a pure Java driver? JDBC-ODBC drivers (which looks like yours It is a jdbc-odbc bridge

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Filip Hanik - Dev Lists
The config has changed from Resource ... param to Resource driverClassName= that could be your culprit On 4/7/2011 12:08 PM, David kerber wrote: System: Windows Server 2008 R2 Standard (64-bit) JRE: 1.6.0_24 x64 TC: 7.0.11, installed in c:\Program Files\..., so it detected an x64

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread David kerber
On 4/7/2011 5:01 PM, Filip Hanik - Dev Lists wrote: The config has changed from Resource ... param to Resource driverClassName= I don't use any of those, because TC isn't managing the pool; the app handles its own pool. The file layout that works in 5.5 doesn't seem to work in 7.0,

Re: Trouble with jdbc drivers in TC 7 - fixed

2011-04-07 Thread David kerber
To close this loop, I got it fixed. The issue was a (apparently very slightly) corrupt jodbc.jar file. I say very slightly because I could open it with windows explorer's .zip handling functionality and everything looked fine, but tomcat choked on it when trying to open it with

Re: Trouble with jdbc drivers in TC 7 - fixed

2011-04-07 Thread Konstantin Kolinko
2011/4/8 David kerber dcker...@verizon.net: To close this loop, I got it fixed.  The issue was a (apparently very slightly) corrupt jodbc.jar file.  I say very slightly because I could open it with windows explorer's .zip handling functionality and everything looked fine, but tomcat choked on

Re: Trouble with jdbc drivers in TC 7 - fixed

2011-04-07 Thread David Kerber
On 4/7/2011 5:57 PM, Konstantin Kolinko wrote: 2011/4/8 David kerberdcker...@verizon.net: To close this loop, I got it fixed. The issue was a (apparently very slightly) corrupt jodbc.jar file. I say very slightly because I could open it with windows explorer's .zip handling functionality and

Re: Trouble with jdbc drivers in TC 7 - fixed

2011-04-07 Thread Konstantin Kolinko
2011/4/8 David Kerber dcker...@verizon.net: On 4/7/2011 5:57 PM, Konstantin Kolinko wrote: 2011/4/8 David kerberdcker...@verizon.net: To close this loop, I got it fixed.  The issue was a (apparently very slightly) corrupt jodbc.jar file.  I say very slightly because I could open it with

Re: Trouble with jdbc drivers in TC 7 - fixed

2011-04-07 Thread David Kerber
On 4/7/2011 8:02 PM, Konstantin Kolinko wrote: 2011/4/8 David Kerberdcker...@verizon.net: On 4/7/2011 5:57 PM, Konstantin Kolinko wrote: 2011/4/8 David kerberdcker...@verizon.net: To close this loop, I got it fixed. The issue was a (apparently very slightly) corrupt jodbc.jar file. I say

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
Listsdevli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Listsdevli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10

Re: JDBC Pool Disconnections

2011-04-06 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 הילה, On 4/6/2011 3:36 PM, הילה wrote: I wanted to add it, bu the company that developed the application that runs on the tomcat, says that it affect performance and has issues. What is your RDBMS? If it happens to be MySQL, I know that they

JDBC Pool Disconnections

2011-04-05 Thread הילה
Hey, I have lately (with your help) switched the pool that tomcat uses , from the basic pool to the JDBC pool, with these actions- 1. under resource tag in xml configuration [conf/catalina/localhost/Appname.xml] I specified the factory name, as you can see below- name=jdbc/com/vstechnology

Re: Cleaning up after tomcat jdbc-pool?

2011-03-13 Thread הילה
It seems that only using the new jdbc pool has solved the memory leak :] it's funny that the idea to use it came from a different thread here in the users list. :] Thanks for your help Hila בתאריך 9 במרס 2011 22:33, מאת הילה hilavalen...@gmail.com: Sure, when I'll have a final results

Re: Cleaning up after tomcat jdbc-pool?

2011-03-09 Thread Filip Hanik - Dev Lists
to close connections that ran out of memory. Look at the maxAge property in http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html it is created just to deal with the database sessions that have memory leaks, and the leak is somewhat predictable timing wise best Filip Don't know

Re: Cleaning up after tomcat jdbc-pool?

2011-03-09 Thread הילה
I'll define it. thanks :] I've implemented 2 changes in production servers - one with the new pool (and still jtds drivers) and one with new pool + switching to jdbc drivers. both has windows authentication enabled. the servers look pretty stable until now, but I'm waiting to see the memory

Re: Cleaning up after tomcat jdbc-pool?

2011-03-09 Thread André Warnier
הילה wrote: I'll define it. thanks :] I've implemented 2 changes in production servers - one with the new pool (and still jtds drivers) and one with new pool + switching to jdbc drivers. both has windows authentication enabled. the servers look pretty stable until now, but I'm waiting to see

Re: Cleaning up after tomcat jdbc-pool?

2011-03-09 Thread הילה
pool (and still jtds drivers) and one with new pool + switching to jdbc drivers. both has windows authentication enabled. the servers look pretty stable until now, but I'm waiting to see the memory behaviour in the next few days. on servers with the jtds driver, basic pool and windows

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread Olivier Lefevre
On 3/7/2011 8:00 AM, הילה wrote: How do I know if I use the new pool? just by specifying the org.apache.tomcat.jdbc.pool.DataSourceFactory AFAICT yes. what is the advantages of using the new pool? in which cases should I use it? See http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread הילה
of using the new pool? in which cases should I use it? See http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html I guess that will be merged into the Tomcat docs eventually. -- O.L. - To unsubscribe, e-mail: users

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread הילה
I found this http://people.apache.org/~fhanik/tomcat/jdbc-pool.html that I see that it suits for tomcat 6 as well but I can't find tomcat-jdbc.jar for download, and I understood I need it to use the new pool. from where can I download it? Thanks Hila בתאריך 7 במרס 2011 12:28, מאת הילה hilavalen

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread Mark Thomas
On 07/03/2011 10:39, הילה wrote: I found this http://people.apache.org/~fhanik/tomcat/jdbc-pool.html that I see that it suits for tomcat 6 as well but I can't find tomcat-jdbc.jar for download, and I understood I need it to use the new pool. from where can I download

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread Filip Hanik - Dev Lists
On 3/7/2011 3:48 AM, Mark Thomas wrote: On 07/03/2011 10:39, הילה wrote: I found this http://people.apache.org/~fhanik/tomcat/jdbc-pool.html that I see that it suits for tomcat 6 as well but I can't find tomcat-jdbc.jar for download, and I understood I need it to use the new pool. from where

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread הילה
Thanks :] Let's see if it'll somewhat help with the memory leak, or with memory management at all 2011/3/7 Filip Hanik - Dev Lists devli...@hanik.com On 3/7/2011 3:48 AM, Mark Thomas wrote: On 07/03/2011 10:39, הילה wrote: I found this http://people.apache.org/~fhanik/tomcat/jdbc

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread Nicholas Sushkin
I don't think the default pool has any glaring leaks. However, your db may. I have ran into cases when Oracle would run out of PGA memory, which cleared with tomcat restart. It may help to use connection validation feature of tomcat's new pool to close connections that ran out of memory. Don't

Re: Cleaning up after tomcat jdbc-pool?

2011-03-06 Thread Nicholas Sushkin
to clean up the pool? Thanks Hila The Factory we were talking about was from Tomcat's new jdbc pool, not from the default pool. If you're using the default pool, you don't need to do anything special like specifying factory in your context. So, if you are using the _new_ pool, make sure to have

Re: Cleaning up after tomcat jdbc-pool?

2011-03-06 Thread הילה
Hila The Factory we were talking about was from Tomcat's new jdbc pool, not from the default pool. If you're using the default pool, you don't need to do anything special like specifying factory in your context. So, if you are using the _new_ pool, make sure to have the tomcat-jdbc.jar

Re: Cleaning up after tomcat jdbc-pool?

2011-03-04 Thread Nicholas Sushkin
$session.program=MyApp-@release@ @instance.title@; driverClassName=oracle.jdbc.driver.OracleDriver factory=org.apache.tomcat.jdbc.pool.DataSourceFactory initialSize=1 maxActive=10 name=jdbc/Db1 password=@db1.password

Re: Cleaning up after tomcat jdbc-pool?

2011-03-04 Thread Olivier Lefevre
Thanks! But this: factory=org.apache.tomcat.jdbc.pool.DataSourceFactory is the default, I believe. Didn't you say you were using something else? -- O.L. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For

Re: Cleaning up after tomcat jdbc-pool?

2011-03-04 Thread Filip Hanik - Dev Lists
On 03/04/2011 02:04 PM, Olivier Lefevre wrote: Thanks! But this: factory=org.apache.tomcat.jdbc.pool.DataSourceFactory is the default, I believe. Didn't you say you were using something else? is not the default. org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory is default Filip -- O.L.

Re: Cleaning up after tomcat jdbc-pool?

2011-03-03 Thread Filip Hanik - Dev Lists
hi Nicholas, where is your pool configured? In server.xml or in your application context? If it is configured in server.xml, then this is a bug, the thread should have been created with the class loader from the pool itself. If it is configured in the application context, then this simply means

Re: Cleaning up after tomcat jdbc-pool?

2011-03-03 Thread Filip Hanik - Dev Lists
webapp context.xml Resource name=jdbc/AppDesignerDB auth=Container type=javax.sql.DataSource / and I don't get the error the OP reported. Are you both talking about something else? It will only start a thread if you have configured it to do clean up while

Re: Cleaning up after tomcat jdbc-pool?

2011-03-03 Thread Nicholas Sushkin
Hi, Filip, My tomcat jdbc pool is configured in my app's context.xml. My app uses MyBatis 3 to do the work. I store MyBatis SqlSessionFactory in ServletContext attributes. I was able to get DataSources back from Batis SqlSessionFactory, and invoke .close on each. The leak seems to have gone

Re: Cleaning up after tomcat jdbc-pool?

2011-03-03 Thread Olivier Lefevre
Can we see the relevant part of your context.xml, too? Thanks, -- O.L. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org

Cleaning up after tomcat jdbc-pool?

2011-03-02 Thread Nicholas Sushkin
Hi, Filip, Is there a recommended way to clean up after the pool? I am getting the following error message and I wonder if I need to add some code to prevent memory leak. 2011-03-02 22:20:20,786 ERROR [http-8081-1] org.apache.catalina.loader.WebappClassLoader - The web application [/…]

Can datasource password be changed in jdbc-pool?

2011-02-22 Thread Nicholas Sushkin
Hi, I am checking out the new Tomcat's jdbc-pool. So far it's great. I like JMX monitoring feature. I searched lists and google for how to change database password in the JNDI data source and couldn't find anything. Can it be done? If not, then can JMX MBean be extended with an operation

Re: Can datasource password be changed in jdbc-pool?

2011-02-22 Thread Filip Hanik - Dev Lists
needed support to refresh the pool with configuration changes. I will open a Bugzilla enhancement request, and we can get this implemented. best Filip On 02/22/2011 10:54 AM, Nicholas Sushkin wrote: Hi, I am checking out the new Tomcat's jdbc-pool. So far it's great. I like JMX monitoring feature

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
...@christopherschultz.net] Sent: 17 November 2010 16:44 To: Tomcat Users List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rob, On 11/17/2010 7:07 AM, Rob Gregory wrote: Is it possible to just store my existing

Re: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Pid
List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools Rob, On 11/17/2010 7:07 AM, Rob Gregory wrote: Is it possible to just store my existing collection of datasources in some global context? I.e. initCtx = new InitialContext(); Context envCtx = (Context

Re: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Mark Thomas
On 18/11/2010 09:34, Rob Gregory wrote: Thanks Chris, After messing around with JNDI yesterday I came to the same conclusion that Tomcat is doing some isolation Random thoughts that may or may not help. If you look in the DataSourceRealm you will see some code that lets a web-app use a

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
Thanks Pid, That’s two suggestions for me to try. Many thanks for your assistance. Rob -Original Message- From: Pid [mailto:p...@pidster.com] Sent: 18 November 2010 10:26 To: Tomcat Users List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools On 18/11

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
: 18 November 2010 10:30 To: Tomcat Users List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools On 18/11/2010 09:34, Rob Gregory wrote: Thanks Chris, After messing around with JNDI yesterday I came to the same conclusion that Tomcat is doing some isolation

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
(dataSourceName, datasource); Thanks again for the push in the right direction. Rob -Original Message- From: Mark Thomas [mailto:ma...@apache.org] Sent: 18 November 2010 10:30 To: Tomcat Users List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools On 18/11/2010 09:34

Re: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Mark Thomas
To: Tomcat Users List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools On 18/11/2010 09:34, Rob Gregory wrote: Thanks Chris, After messing around with JNDI yesterday I came to the same conclusion that Tomcat is doing some isolation Random thoughts that may or may

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
To: Tomcat Users List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools On 18/11/2010 16:54, Rob Gregory wrote: Spot on Mark. I have been googling and playing around for over a day on this, Following your suggestion it boils down to a couple of lines of code

Re: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Mark Thomas
. Mark Thanks Again. Rob -Original Message- From: Mark Thomas [mailto:ma...@apache.org] Sent: 18 November 2010 16:59 To: Tomcat Users List Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools On 18/11/2010 16:54, Rob Gregory wrote: Spot on Mark. I have been

Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-17 Thread Rob Gregory
Tomcat Users, We are trying to migrate a web application from a single context containing multiple JDBC datasources to a web application deployed over multiple contexts but without duplicating the shared datasources. Reading the docs at http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-17 Thread Rob Gregory
); or something along those lines? Thanks Rob -Original Message- From: Rob Gregory [mailto:rob.greg...@ibsolutions.com] Sent: 17 November 2010 11:09 To: Tomcat Users List Subject: Dynamic GlobalNamingResources / Shared JDBC connection pools Tomcat Users, We are trying to migrate

Re: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-17 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rob, On 11/17/2010 7:07 AM, Rob Gregory wrote: Is it possible to just store my existing collection of datasources in some global context? I.e. initCtx = new InitialContext(); Context envCtx = (Context)initCtx.lookup(java:/comp/env);

Error in configuring JDBC Datasource

2010-11-14 Thread Jayaprakash Ramsaran
=/ without resource name definition. Context docBase=C:\springsource\tc-server-developer-2.0.4.RELEASE\spring-insight-instance\wtpwebapps\myapp path=/myapp reloadable=true source=org.eclipse.jst.jee.server:myapp Resource name=jdbc/postgres auth=Container type=javax.sql.DataSource

Re: Error in configuring JDBC Datasource

2010-11-14 Thread Jayaprakash Ramsaran
) { System.out.println(JNDI failure: + ex); ex.printStackTrace(); } } I get the below error. before initialcontext Before Context list org.apache.naming.NamingContext jdbc org.apache.naming.NamingContext jdbc JNDI failure: javax.naming.NamingException

Re: Error in configuring JDBC Datasource

2010-11-14 Thread Konstantin Kolinko
2010/11/14 Jayaprakash Ramsaran jayaprakash.ramsa...@gmail.com: Sever: Springsource tc server-developer-2.1.0/ tomcat-6.0.29.B O/S: Windows Vista I am using Springsource Tool Suite 2.5.1 and tc server 2.1. I am trying to configure a data source to PostgresSql. I followed the steps outlined in 

Re: Error in configuring JDBC Datasource

2010-11-14 Thread Jayaprakash Ramsaran
Sorry. Please find the full URL below. http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html#PostgreSQL On Sun, Nov 14, 2010 at 10:44 AM, Konstantin Kolinko knst.koli...@gmail.com wrote: 2010/11/14 Jayaprakash Ramsaran jayaprakash.ramsa...@gmail.com: Sever: Springsource

JDBC Leak Prevention and Security Manager

2010-10-08 Thread George Sexton
I'm running Tomcat 6.0.29 with the security manager enabled. I'm getting these entries in my log: 2010-10-07 12:09:01,710 WARN http-80-76 org.apache.catalina.loader.WebappClassLoader - JDBC driver de-registration failed for web application [] java.lang.reflect.InvocationTargetException

Re: JDBC Leak Prevention and Security Manager

2010-10-08 Thread Mark Thomas
On 08/10/2010 21:20, George Sexton wrote: Could any give me a hint as to what I need to add to the catalina.policy file to make this work? Should I file this as a bug? https://issues.apache.org/bugzilla/show_bug.cgi?id=49209 Mark

Re: Is it possible to have shared JDBC resources in Tomcat 6.0 cluster?

2010-09-18 Thread Peter Rossbach
HI, you can check HA JDBC. http://ha-jdbc.sourceforge.net/doc.html Peter Am 10.09.2010 um 10:59 schrieb Michael Knümann: Hi I'm currently working on migrating single server web application for deployment in a cluster. We have JDBC connection pools to talk with several databases. I'm

Is it possible to have shared JDBC resources in Tomcat 6.0 cluster?

2010-09-10 Thread Michael Knümann
Hi I'm currently working on migrating single server web application for deployment in a cluster. We have JDBC connection pools to talk with several databases. I'm going to divide the max db connection attribute for each by the number of nodes then. But I'm wondering if it is possible

Re: Is it possible to have shared JDBC resources in Tomcat 6.0 cluster?

2010-09-10 Thread Mark Thomas
On 10/09/2010 09:59, Michael Knümann wrote: Hi I'm currently working on migrating single server web application for deployment in a cluster. We have JDBC connection pools to talk with several databases. I'm going to divide the max db connection attribute for each by the number of nodes

RE: Tomcat Thread BLOCKED due to JDBC getConnection

2010-08-17 Thread Sunil Sharma
Hi All, Kindly help me to resolve an issue in our production system, where tomcat is frequenctly getting hunged and axis request threads are been in BLOCKED state. Below is the snaphot of jstack during hunged state. Tomcat : 5.5 MySQL : 5

Re: Tomcat Thread BLOCKED due to JDBC getConnection

2010-08-17 Thread sasidhar prabhakar
Post your JDBC code On Tue, Aug 17, 2010 at 4:23 PM, Sunil Sharma sunil.sharm...@hotmail.comwrote: Hi All, Kindly help me to resolve an issue in our production system, where tomcat is frequenctly getting hunged and axis request threads are been in BLOCKED state. Below is the snaphot

RE: Tomcat Thread BLOCKED due to JDBC getConnection

2010-08-17 Thread Caldarale, Charles R
From: Sunil Sharma [mailto:sunil.sharm...@hotmail.com] Subject: RE: Tomcat Thread BLOCKED due to JDBC getConnection Kindly help me to resolve an issue in our production system, where tomcat is frequenctly getting hunged and axis request threads are been in BLOCKED state. Below

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-22 Thread yuccanel
david.sm...@cornell.edu Sent: Monday, June 21, 2010 2:54 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN! I do not see the mistake that you see I didn't say I saw

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-22 Thread Pid
)initContext.lookup(java:/comp/env); DataSource ds = (DataSource)envContext.lookup(jdbc/my_db_name_here); Connection conn = ds.getConnection(); From: http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html p -- From: David Smith david.sm

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-21 Thread Mark Thomas
On 20/06/2010 21:49, akhlaqur Rahman wrote: How do I unsubscribe from this list? I have tried following the unsubscribe link in the emails and it has not worked... Any tips would be appreciated. Ask one of the list owners for help. I'll unsubscribe you in a sec. Mark

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-21 Thread yuccanel
To: Tomcat Users List users@tomcat.apache.org Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN! On 20/06/2010 21:49, akhlaqur Rahman wrote: How do I unsubscribe from this list? I have tried following the unsubscribe link

RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-21 Thread Martin Gainty
. This is not good. I have even moved host provider in hope that it was previous fult tomcat install from dailyrazor (tomcat 6 does not hav common/lib) and is meant to have tomcat/lib I can say that my new container is correct and that I am 100% sure that all mus jdbc configuration is correct in zml

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-21 Thread yuccanel
-- From: Martin Gainty mgai...@hotmail.com Sent: Monday, June 21, 2010 1:16 PM To: Tomcat Users List users@tomcat.apache.org Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-21 Thread David Smith
: -- From: Martin Gainty mgai...@hotmail.com Sent: Monday, June 21, 2010 1:16 PM To: Tomcat Users List users@tomcat.apache.org Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-21 Thread yuccanel
Hello, I have done as David suggested and has not fixed issue. If you visit thejarbar.org you will see the test page that confirms the jdbc has been opned and therefore the lib is present I found a possible reason in hibernate .cfg and fixed it but still got error after redeployment 1 my databse

RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-20 Thread akhlaqur Rahman
: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN! On 6/19/2010 1:31 PM, yucca...@live.co.za wrote: I have no choice left but to not let hibernate use my tomcat datasource. This is not good. I have even moved host provider in hope

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-19 Thread yuccanel
I moved hosting provider and have found eapps to be excellent. Despite the same version of tomcat and same layout, I am unable to resolve this exception. my databases are correct, the jdbc jar is in tomcat/lib. I don't know what more to do

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-19 Thread yuccanel
is correct and that I am 100% sure that all mus jdbc configuration is correct in zml after having gone though it at least 20 times and checked the wiki that was linked here earlier and still have issues. Yes mysql jdbc bin is in tomcat/lib so that is not cause of the error. /the error is very weird

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-19 Thread David Smith
to have tomcat/lib I can say that my new container is correct and that I am 100% sure that all mus jdbc configuration is correct in zml after having gone though it at least 20 times and checked the wiki that was linked here earlier and still have issues. Yes mysql jdbc bin is in tomcat/lib so

Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-17 Thread marble4u
@gurkan Chris: actually I don't want to use the resource directly in a servlet or JSP - due to architectural reasons - so is there a way to inject resources into plain java classes? @Pid: Thanks for the Information. I will check out the spec and hope that it is not too much to read ;-) And

Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-17 Thread Gurkan Erdogdu
To: users@tomcat.apache.org Sent: Thu, June 17, 2010 6:37:56 PM Subject: Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource) @gurkan Chris: actually I don't want to use the resource directly in a servlet or JSP - due to architectural reasons - so is there a way to inject

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-16 Thread yuccanel
AM To: Tomcat Users List users@tomcat.apache.org Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' Ok, no need to accuse me of lying, please see screenshot showing common/lib and other screenie showing there is no tomcat

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-16 Thread yuccanel
To: Tomcat Users List users@tomcat.apache.org Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' production is tomcat 6.0.20 thanks for the reply. had to call it a night so sorry for delay in reply

Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-16 Thread marble4u
;/welcome-filegt; lt;/welcome-file-listgt; lt;resource-refgt; lt;descriptiongt;testDblt;/descriptiongt; lt;res-ref-namegt;jdbc/testDblt;/res-ref-namegt; lt;res-typegt;javax.sql.DataSourcelt;/res-typegt; lt;res-authgt;Containerlt;/res-authgt; lt;/resource

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-16 Thread yuccanel
Documentation at /docs/jndi-resources-howto.html -- GlobalNamingResources !-- Editable user database that can also be used by UserDatabaseRealm to authenticate users -- Resource name=jdbc/auth description=The Jar Bar user authentication type

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-16 Thread Pid
also be used by UserDatabaseRealm to authenticate users -- Resource name=jdbc/auth description=The Jar Bar user authentication type=javax.sql.DataSource auth=Container driverClassName=com.mysql.jdbc.Driver maxActive=30 maxIdle=10

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-16 Thread yuccanel
: Wednesday, June 16, 2010 1:18 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' - To unsubscribe, e-mail: users

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-16 Thread David Smith
enough to try a connection directly (no jdbc pool) just to see if the jar is found. Lastly (and maybe I missed it in the thread), could you post a complete stack trace including any root causes and related exceptions from when the webapp was started? --David On 6/16/10 7:08 AM, yucca...@live.co.za

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-16 Thread David Smith
, 2010 1:18 PM To: Tomcat Users List users@tomcat.apache.org Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' - To unsubscribe, e-mail: users-unsubscr

Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-16 Thread Gurkan Erdogdu
What is a TestClass? Tomcat has no knowledge about your class for injection occurs. Please define some servlet and try with it, class TestClass extends HttpServlet{ private @Resource(name=jdbc/TestDb) DataSource datasource; @PostConstruct public void postConstruct

Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-16 Thread marble4u
Thank you, that helped a lot! I am new to j2ee... I have a lot of application logic that will be used without representation as a jsp or a servlet: objects that extend TimerTask and register at a timer objekt. they execute code which accesses a database (importer classes that collect data from

Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-16 Thread Pid
On 16/06/2010 23:13, marble4u wrote: Thank you, that helped a lot! I am new to j2ee... I have a lot of application logic that will be used without representation as a jsp or a servlet: objects that extend TimerTask and register at a timer objekt. they execute code which accesses a database

Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-16 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gurkan, On 6/16/2010 10:44 AM, Gurkan Erdogdu wrote: Please define some servlet and try with it, class TestClass extends HttpServlet{ private @Resource(name=jdbc/TestDb) DataSource datasource; @PostConstruct public void

Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource)

2010-06-16 Thread Gurkan Erdogdu
...@christopherschultz.net To: Tomcat Users List users@tomcat.apache.org Sent: Thu, June 17, 2010 2:37:05 AM Subject: Re: Resource Annotation has no effect but JNDI Lookup works (JDBC Resource) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gurkan, On 6/16/2010 10:44 AM, Gurkan Erdogdu wrote: Please define some

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-15 Thread yuccanel
I have tried to check why this exception is thrown in production but not development The difference between production snd development server is: development) put mysql jar into CATALINA/lib (tomcat 6.0.26) production) choice of common/lib or share/lib exception is thrown by hibernate

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-15 Thread Mark Eggers
Are you developing on 6.0.x but deploying on 5.?.x (5.0 or 5.5)? What version is running in production? --- On Tue, 6/15/10, yucca...@live.co.za yucca...@live.co.za wrote: From: yucca...@live.co.za yucca...@live.co.za Subject: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-15 Thread yuccanel
: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' Are you developing on 6.0.x but deploying on 5.?.x (5.0 or 5.5)? What version is running in production? --- On Tue, 6/15/10, yucca...@live.co.za yucca...@live.co.za wrote: From: yucca

RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-15 Thread Caldarale, Charles R
From: yucca...@live.co.za [mailto:yucca...@live.co.za] Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' production is tomcat 6.0.20 Then there's no common/lib or shared/lib in production either. Get your story

Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

2010-06-15 Thread yuccanel
users@tomcat.apache.org Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' From: yucca...@live.co.za [mailto:yucca...@live.co.za] Subject: Re: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver

<    4   5   6   7   8   9   10   11   12   13   >