RE: DataSource.getConnection() hangs
org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' is caused from an unrelated error in your server.xml. I fixed the problem with this error not reporting correctly but I just submitted it to be added to CVS. The root cause exception is not being returned currently so just know that it's probably not your driverClassName. Daniel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DataSource.getConnection() hangs
I solved it too. But it seems that mine problem was caused by empty pool validation query string. thanx Maris -Original Message- From: Sean Dockery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 7:27 PM To: Tomcat Users List Subject: RE: DataSource.getConnection() hangs Very very cool thing to know. I've seen this behavior before but never knew what was causing it. At 14:11 2003-02-05 +0100, you wrote: Hi, I had this problem a while ago. Mine was caused by DBCP attempting to open a pool of Db connections when receiving the first getConnection() request - and my Db was not configured to handle that many connections - and it just hung waiting for the maxActive value to become available. I omitted minIdle and maxActive parameters so that they defaulted (in my case 4 and 2) then it worked. I then got my DBA to reconfigure his startup parameters to something realistic. HTH Sean Dockery [EMAIL PROTECTED] Certified Java Web Component Developer Certified Delphi Programmer SBD Consultants http://www.sbdconsultants.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DataSource.getConnection() hangs
Hi Maris I don't use a validation query at all and mine works! I'm using Oracle - maybe different databases have different features when working with DBCP ;-)) -Original Message- From: Maris Orbidans [mailto:[EMAIL PROTECTED]] Sent: Freitag, 07. Februar 2003 12:37 To: Tomcat Users List Subject: RE: DataSource.getConnection() hangs I solved it too. But it seems that mine problem was caused by empty pool validation query string. thanx Maris -Original Message- From: Sean Dockery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 7:27 PM To: Tomcat Users List Subject: RE: DataSource.getConnection() hangs Very very cool thing to know. I've seen this behavior before but never knew what was causing it. At 14:11 2003-02-05 +0100, you wrote: Hi, I had this problem a while ago. Mine was caused by DBCP attempting to open a pool of Db connections when receiving the first getConnection() request - and my Db was not configured to handle that many connections - and it just hung waiting for the maxActive value to become available. I omitted minIdle and maxActive parameters so that they defaulted (in my case 4 and 2) then it worked. I then got my DBA to reconfigure his startup parameters to something realistic. HTH Sean Dockery [EMAIL PROTECTED] Certified Java Web Component Developer Certified Delphi Programmer SBD Consultants http://www.sbdconsultants.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DataSource.getConnection() hangs
I have it: resource-ref descriptionDB Connection/description res-ref-namejdbc/BooksDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref -Original Message- From: Lindomar [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 7:16 PM To: Tomcat Users List Subject: Re: DataSource.getConnection() hangs Put this: == resource-ref descriptionany description/description res-ref-namejdbc/BooksDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref == In web.xml of your application. See too http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasourc e-examples-how to.html Ok. - Original Message - From: Maris Orbidans [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, February 03, 2003 15:47 Subject: DataSource.getConnection() hangs E-mail Premium BOL Antivírus, anti-spam e até 100 MB de espaço. Assine já! http://email.bol.com.br/ ok, I configured data source, wrote those lines you can see below in server.xml, inside Context tag. Now Tomcat just hangs, when I call DataSource method getConnection. I use Tomcat 4.1.18 has anybody experienced this ? Maris Orbidans ResourceParams name=jdbc/BooksDB parameter namevalidationQuery/name value/ /parameter parameter nameurl/name valuejdbc:mysql://localhost/booksdb/value /parameter parameter namepassword/name valuehh/value /parameter parameter namemaxActive/name value16/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter nameusername/name valuepoweruser/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams -Original Message- From: Cristian Draghici [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:07 AM To: Tomcat Users List Subject: RE: Cannot load JDBC driver class 'null' yes it will shutdown tomcat and edit the server.xml file by hand. (add the ResourceParams entry under your context) add the necessary entries, start tomcat and the admin console should work. (at least that's what happens with my tomcat 4.1.18) hope this helps, cristi -Original Message- From: Maris Orbidans [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:03 AM To: Tomcat Users List Subject: Cannot load JDBC driver class 'null' hello I have run into that problem too, I defined a datasource and put driver and common/lib and defined resource-ref in web.xml of my web. app. but if throws exception when I try to get a connection from datasource I have found. I tried to do it at home with different database with the same result, so I dont think I have mistyped something. I know this problem has been adressed before but I havent found any solution from maillist archives. BTW I have found one related thing: If you open Tomcat admin tool, choose host - context - context name - Data sources it will throw an exception: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' so... I there any known solution ? Maris Orbidans www.datapro.lv - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DataSource.getConnection() hangs
Hi, I had this problem a while ago. Mine was caused by DBCP attempting to open a pool of Db connections when receiving the first getConnection() request - and my Db was not configured to handle that many connections - and it just hung waiting for the maxActive value to become available. I omitted minIdle and maxActive parameters so that they defaulted (in my case 4 and 2) then it worked. I then got my DBA to reconfigure his startup parameters to something realistic. HTH -Original Message- From: Maris Orbidans [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 05. Februar 2003 11:33 To: Tomcat Users List Subject: RE: DataSource.getConnection() hangs I have it: resource-ref descriptionDB Connection/description res-ref-namejdbc/BooksDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref -Original Message- From: Lindomar [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 7:16 PM To: Tomcat Users List Subject: Re: DataSource.getConnection() hangs Put this: == resource-ref descriptionany description/description res-ref-namejdbc/BooksDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref == In web.xml of your application. See too http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasourc e-examples-how to.html Ok. - Original Message - From: Maris Orbidans [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, February 03, 2003 15:47 Subject: DataSource.getConnection() hangs E-mail Premium BOL Antivírus, anti-spam e até 100 MB de espaço. Assine já! http://email.bol.com.br/ ok, I configured data source, wrote those lines you can see below in server.xml, inside Context tag. Now Tomcat just hangs, when I call DataSource method getConnection. I use Tomcat 4.1.18 has anybody experienced this ? Maris Orbidans ResourceParams name=jdbc/BooksDB parameter namevalidationQuery/name value/ /parameter parameter nameurl/name valuejdbc:mysql://localhost/booksdb/value /parameter parameter namepassword/name valuehh/value /parameter parameter namemaxActive/name value16/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter nameusername/name valuepoweruser/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams -Original Message- From: Cristian Draghici [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:07 AM To: Tomcat Users List Subject: RE: Cannot load JDBC driver class 'null' yes it will shutdown tomcat and edit the server.xml file by hand. (add the ResourceParams entry under your context) add the necessary entries, start tomcat and the admin console should work. (at least that's what happens with my tomcat 4.1.18) hope this helps, cristi -Original Message- From: Maris Orbidans [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:03 AM To: Tomcat Users List Subject: Cannot load JDBC driver class 'null' hello I have run into that problem too, I defined a datasource and put driver and common/lib and defined resource-ref in web.xml of my web. app. but if throws exception when I try to get a connection from datasource I have found. I tried to do it at home with different database with the same result, so I dont think I have mistyped something. I know this problem has been adressed before but I havent found any solution from maillist archives. BTW I have found one related thing: If you open Tomcat admin tool, choose host - context - context name - Data sources it will throw an exception: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' so... I there any known solution ? Maris Orbidans www.datapro.lv - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
RE: DataSource.getConnection() hangs
Very very cool thing to know. I've seen this behavior before but never knew what was causing it. At 14:11 2003-02-05 +0100, you wrote: Hi, I had this problem a while ago. Mine was caused by DBCP attempting to open a pool of Db connections when receiving the first getConnection() request - and my Db was not configured to handle that many connections - and it just hung waiting for the maxActive value to become available. I omitted minIdle and maxActive parameters so that they defaulted (in my case 4 and 2) then it worked. I then got my DBA to reconfigure his startup parameters to something realistic. HTH Sean Dockery [EMAIL PROTECTED] Certified Java Web Component Developer Certified Delphi Programmer SBD Consultants http://www.sbdconsultants.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: DataSource.getConnection() hangs
Put this: == resource-ref descriptionany description/description res-ref-namejdbc/BooksDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref == In web.xml of your application. See too http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html Ok. - Original Message - From: Maris Orbidans [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, February 03, 2003 15:47 Subject: DataSource.getConnection() hangs E-mail Premium BOL Antivírus, anti-spam e até 100 MB de espaço. Assine já! http://email.bol.com.br/ ok, I configured data source, wrote those lines you can see below in server.xml, inside Context tag. Now Tomcat just hangs, when I call DataSource method getConnection. I use Tomcat 4.1.18 has anybody experienced this ? Maris Orbidans ResourceParams name=jdbc/BooksDB parameter namevalidationQuery/name value/ /parameter parameter nameurl/name valuejdbc:mysql://localhost/booksdb/value /parameter parameter namepassword/name valuehh/value /parameter parameter namemaxActive/name value16/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter nameusername/name valuepoweruser/value /parameter parameter namemaxIdle/name value2/value /parameter /ResourceParams -Original Message- From: Cristian Draghici [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:07 AM To: Tomcat Users List Subject: RE: Cannot load JDBC driver class 'null' yes it will shutdown tomcat and edit the server.xml file by hand. (add the ResourceParams entry under your context) add the necessary entries, start tomcat and the admin console should work. (at least that's what happens with my tomcat 4.1.18) hope this helps, cristi -Original Message- From: Maris Orbidans [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:03 AM To: Tomcat Users List Subject: Cannot load JDBC driver class 'null' hello I have run into that problem too, I defined a datasource and put driver and common/lib and defined resource-ref in web.xml of my web. app. but if throws exception when I try to get a connection from datasource I have found. I tried to do it at home with different database with the same result, so I dont think I have mistyped something. I know this problem has been adressed before but I havent found any solution from maillist archives. BTW I have found one related thing: If you open Tomcat admin tool, choose host - context - context name - Data sources it will throw an exception: org.apache.jasper.JasperException: Exception retrieving attribute 'driverClassName' so... I there any known solution ? Maris Orbidans www.datapro.lv - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]