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
I have it: DB Connection jdbc/BooksDB javax.sql.DataSource Container > -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: > == > > any description > jdbc/BooksDB > javax.sql.DataSource > Container > > == > 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 > > > > > validationQuery > > > > url > jdbc:mysql://localhost/booksdb > > > password > hh > > > maxActive > 16 > > > maxWait > 5000 > > > driverClassName > com.mysql.jdbc.Driver > > > username > poweruser > > > maxIdle > 2 > > > > > > -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 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 -> -> 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]
DataSource.getConnection() hangs
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 validationQuery url jdbc:mysql://localhost/booksdb password hh maxActive 16 maxWait 5000 driverClassName com.mysql.jdbc.Driver username poweruser maxIdle 2 > -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 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 -> -> 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]
RE: Cannot load JDBC driver class 'null'
yeah, as I thought however it's boring , let's hope it will be changed in future releases. Maris > -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 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 -> -> 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]
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 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 -> -> 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]