Re: Trouble with jdbc drivers in TC 7 - fixed

2011-04-07 Thread Konstantin Kolinko
2011/4/8 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

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 java.util.zip.

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 to 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, unless there's some very subtle difference I'm no

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Filip Hanik - Dev Lists
The config has changed from to 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 installation DB: Sybase ASA 9.0.2.3951, x64 version DB server and TC are both installed on this same machine. I'm tryi

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Christopher Schultz
JRE: 1.6.0_24 x64 >>>> TC: 7.0.11, installed in c:\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, >>

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 b

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Christopher Schultz
51, 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 might be) often have a native component. Could you be missing a shared library from your j

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,

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

Re: Trouble with jdbc drivers in TC 7

2011-04-07 Thread David kerber
On 4/7/2011 2:16 PM, Caldarale, Charles R wrote: From: David kerber [mailto:dcker...@verizon.net] Subject: Trouble with jdbc drivers in TC 7 All my database pooling is done in the application, so I thought putting the jodbc.jar in the WEB-INF/lib of the app would work with no need to edit my

RE: Trouble with jdbc drivers in TC 7

2011-04-07 Thread Caldarale, Charles R
> From: David kerber [mailto:dcker...@verizon.net] > Subject: Trouble with jdbc drivers in TC 7 > All my database pooling is done in the application, so I > thought putting the jodbc.jar in the WEB-INF/lib of the > app would work with no need to edit my configuration files I th

Trouble with jdbc drivers in TC 7

2011-04-07 Thread David kerber
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 installation DB: Sybase ASA 9.0.2.3951, x64 version DB server and TC are both installed on this same machine. I'm trying to port my app from tc 5.5.someth

Re: JDBC Pool Disconnections

2011-04-07 Thread Pid
you mean "validates it"? what does it do, exactly? > > Thanks > Hila > > > 2011/4/6 Filip Hanik - Dev Lists > >> On 4/5/2011 7:31 AM, הילה wrote: >> >>> name="jdbc/com/vstechnology/appname >>> scope="Shareable" >>

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 su

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
validations are limited >>> >>> Filip >>> >>> >>> >>> >>> On 4/6/2011 1:36 PM, הילה wrote: >>> >>> I wanted to add it, bu the company that developed the application that >>>> runs >>>> &

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
ssues. what do you mean "validates it"? what does it do, exactly? Thanks Hila 2011/4/6 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:

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
mean "validates it"? what does it do, exactly? >> >> Thanks >> Hila >> >> >> 2011/4/6 Filip Hanik - Dev Lists >> >> On 4/5/2011 7:31 AM, הילה wrote: >>> >>> name="jdbc/com/vstechnology/appname >>>> sco

Re: JDBC Pool Disconnections

2011-04-06 Thread Filip Hanik - Dev Lists
Thanks Hila 2011/4/6 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=fa

Re: JDBC Pool Disconnections

2011-04-06 Thread הילה
te: > >> name="jdbc/com/vstechnology/appname >> scope="Shareable" >> type="javax.sql.Datasource" >> >> url="jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false" >> factory="org

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

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 tag in xml configuration [conf/catalina/localhost/Appname.xml] I specified the factory name, as you can see below- name="jdbc/com/vstechnology/ap

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, מאת הילה : > Sure, when I'll have a final results and see tha

Re: Cleaning up after tomcat jdbc-pool?

2011-03-09 Thread הילה
uction 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 >> behaviour in t

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 wai

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

Re: Cleaning up after tomcat jdbc-pool?

2011-03-09 Thread Filip Hanik - Dev Lists
ew pool 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 F

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 kn

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 > On 3/7/2011 3:48 AM, Mark Thomas wrote: > >> On 07/03/2011 10:39, הילה wrote: >> >>> I found this >>> http://p

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

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 do

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, מאת הילה :

Re: Cleaning up after tomcat jdbc-pool?

2011-03-07 Thread הילה
t;> > 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 > I guess that will be merged into the Tomcat docs eventually. > > -- O

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-06 Thread הילה
ad resource factory class >> > why is that? >> > how can I define my application to clean up the pool? >> > >> > Thanks >> > Hila >> >> The Factory we were talking about was from Tomcat's new jdbc pool, not >> from >> the de

Re: Cleaning up after tomcat jdbc-pool?

2011-03-06 Thread Nicholas Sushkin
hat? > how can I define my application 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 you

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

Re: Cleaning up after tomcat jdbc-pool?

2011-03-04 Thread Nicholas Sushkin
On Thursday, March 03, 2011 19:24:11 Olivier Lefevre wrote: > Can we see the relevant part of your context.xml, too? Sure. It's something like: At build time, I run the file through ant target that replaces @*@ tokens with actual values. I build using "ant -propertyfile myinstance.prop

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

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

Re: Cleaning up after tomcat jdbc-pool?

2011-03-03 Thread Filip Hanik - Dev Lists
On 3/3/2011 11:44 AM, Olivier Lefevre wrote: On 3/3/2011 5:17 PM, Filip Hanik - Dev Lists wrote: If it is configured in the application context, then this simply means you forgot to call DataSource.close on the connection pool when your web application is stopped. This is confusing advice becau

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 y

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 [/…] appear

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 monitori

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

Re: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Mark Thomas
e should be a 7.0.5 fairly soon. 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 / Sh

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
010 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 googling and playing around for over a day on this, Following > your sug

Re: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Mark Thomas
rom: 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, Rob Gregory wrote: >>> Thanks Chris, >>> >>>

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 >

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
@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, Rob Gregory wrote: > > Thanks Chris, > > > > After messing around with JNDI yesterday I came to the

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 p

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 Pid
z [mailto:ch...@christopherschultz.net] >> Sent: 17 November 2010 16:44 >> To: Tomcat Users List >> Subject: Re: Dynamic GlobalNamingResources / Shared JDBC connection pools >> > Rob, > > On 11/17/2010 7:07 AM, Rob Gregory wrote: >>>> Is it possibl

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-18 Thread Rob Gregory
er Schultz [mailto:ch...@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

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

RE: Dynamic GlobalNamingResources / Shared JDBC connection pools

2010-11-17 Thread Rob Gregory
_test", objTestDatasource); 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 connecti

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: Error in configuring JDBC Datasource

2010-11-14 Thread Jayaprakash Ramsaran
to define it as a global resource though the >> Apache link warns that it some time does not work. The definition is >> given below. >> >>     >>        > >> 3. Then I add the resource reference in web.xml as below. >> >>   >>    postgreSQL Datasource

Re: Error in configuring JDBC Datasource

2010-11-14 Thread Konstantin Kolinko
Apache link warns that it some time does not work. The definition is > given below. > >     >         > 3. Then I add the resource reference in web.xml as below. > >   >    postgreSQL Datasource example >    jdbc/postgres >    javax.sql.DataSource >    Container >

Re: Error in configuring JDBC Datasource

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

Error in configuring JDBC Datasource

2010-11-14 Thread Jayaprakash Ramsaran
. 2. Then I attempted to define it as a global resource though the Apache link warns that it some time does not work. The definition is given below. 3. Then I add the resource reference in web.xml as below. postgreSQL Datasource example jdbc/postgres

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 -

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

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

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 attr

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

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 s

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 wrote: > > 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 js

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: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' AGAIN!

2010-06-22 Thread Pid
w InitialContext(); Context envContext = (Context)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-howt

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

2010-06-22 Thread yuccanel
avid Smith" Sent: Monday, June 21, 2010 2:54 PM To: "Tomcat Users List" 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

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-21 Thread David Smith
co.za wrote: > > -- > From: "Martin Gainty" > Sent: Monday, June 21, 2010 1:16 PM > To: "Tomcat Users List" > Subject: RE: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > JDBC driver of class &#

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" Sent: Monday, June 21, 2010 1:16 PM To: "Tomcat Users List" 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 Martin Gainty
is > 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 c

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

2010-06-21 Thread yuccanel
ot;Tomcat Users List" 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

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

2010-06-20 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-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 p

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

2010-06-19 Thread David Smith
gt; 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 after having gone though it at least > 20 times and checked the wiki that was linked here earlier and still have > issues. Yes

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

2010-06-19 Thread yuccanel
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'

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

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

2010-06-17 Thread Gurkan Erdogdu
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 resour

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 tha

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

2010-06-16 Thread Gurkan Erdogdu
List 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 servlet and try with it, > > class

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

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 dat

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 di

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 pos

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

2010-06-16 Thread David Smith
t; > Sent: Wednesday, June 16, 2010 1:18 PM > To: "Tomcat Users List" > 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'

2010-06-16 Thread David Smith
easy 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.

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

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

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

2010-06-16 Thread Pid
ER: > > > > > > > > > SSLEngine="on" /> > > > > className="org.apache.catalina.core.JreMemoryLeakPreventionListener" /> > > className="org.apache.catalina.mbeans.ServerLifecycleListener" /> >

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

2010-06-16 Thread yuccanel
Servlet javax.faces.webapp.FacesServlet 1 This is a MySQL database connection jdbc/auth javax.sql.DataSource Container Faces Servlet *.jsf index.jsp RegisteredUser Admin loggedInUser /pa

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

2010-06-16 Thread marble4u
;welcome-file>default.html</welcome-file> <welcome-file>default.htm</welcome-file> <welcome-file>default.jsp</welcome-file> </welcome-file-list> <resource-ref> <description>testDb</description> <res-ref-name>jdbc/

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

2010-06-16 Thread yuccanel
List" 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.

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

2010-06-15 Thread yuccanel
omcat Users List" 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 sho

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

2010-06-15 Thread yuccanel
t" 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 of class

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

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

2010-06-15 Thread yuccanel
t" Subject: Re: 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 wro

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 wrote: > From: yucca...@live.co.za > Subject: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC > driver of class '

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