I am also having the same problem. I just posted my sever.xml and web.xml to the group. Any help is really appreciated
> > Hi, > i am still trying to configure a datasource with tomcat.. > I have a mysql instance running on my machine, (I can use without any > problem mysql console and mysql gui client), but in tomcat I am still > getting > Following exception.. > > org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFact > ory, cause: > java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. > Is ther > e a MySQL server running on the machine/port you are trying to connect > to? (java > .net.ConnectException) > at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source) > at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown > Source) > at org.gjt.mm.mysql.Driver.connect(Unknown Source) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv > erConnectionFactory.java:82) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable > ConnectionFactory.java:300) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas > icDataSource.java:838) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou > rce.java:821) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource > .java:518) > at org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:64) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper > .java:311) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3 > 01) > at > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) > > I attach again my server.xml... > > Thanx in advance and regards > Marco > > > > > > > -----Original Message----- > From: Marco Mistroni [mailto:[EMAIL PROTECTED] > Sent: 03 March 2004 15:58 > To: 'Shapira, Yoav' > Subject: RE: problem in configuring a Datasource in Tomcat 5.0 > > Hi Yoav, > Thanx, but it worked for half :-( > > Now I am getting this exception : > org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFact > ory, cause: > java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. > Is ther > e a MySQL server running on the machine/port you are trying to connect > to? (java > .lang.NumberFormatException) > at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source) > > this would mean that there is no mysql server running at localhost.. > > however, I have just started one instance, and here is mysql output.. > > InnoDB: The first specified data file .\ibdata1 did not exist: > InnoDB: a new database to be created! > 040303 13:43:50 InnoDB: Setting file .\ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 040303 13:43:50 InnoDB: Log file .\ib_logfile0 did not exist: new to be > created > > InnoDB: Setting log file .\ib_logfile0 size to 5 MB > InnoDB: Database physically writes the file full: wait... > 040303 13:43:51 InnoDB: Log file .\ib_logfile1 did not exist: new to be > created > > InnoDB: Setting log file .\ib_logfile1 size to 5 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new > InnoDB: Doublewrite buffer created > InnoDB: Creating foreign key constraint system tables > InnoDB: Foreign key constraint system tables created > 040303 13:43:54 InnoDB: Started; log sequence number 0 0 > mysqld: ready for connections. > Version: '4.1.1a-alpha-max-debug' socket: '' port: 3306 > > Any suggestions? > > Thanx in advance and regards > marco > > > > > > -----Original Message----- > From: Shapira, Yoav [mailto:[EMAIL PROTECTED] > Sent: 03 March 2004 14:12 > To: Tomcat Users List > Subject: RE: problem in configuring a Datasource in Tomcat 5.0 > > > Hi, > Try moving your TestDB datasource to your context declaration and out of > GlobalNamingResources. > > Yoav Shapira > Millennium ChemInformatics > > -----Original Message----- > From: Marco Mistroni [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 03, 2004 9:10 AM > To: [EMAIL PROTECTED] > Subject: problem in configuring a Datasource in Tomcat 5.0 > > > Hi all, > I am trying to configure a Datasource with tomcat 5.0, and I > keep on getting > Following exception : > > org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of > class ' > ' for connect URL 'null', cause: > java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:243) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou > rce.java:743) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource > .java:518) > at org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:64) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper > .java:311) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3 > 01) > at > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl > icationFilterChain.java:284) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF > ilterChain.java:204) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV > alve.java:257) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > eContext.java:151) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav > a:567) > at > org.apache.catalina.core.StandardContextValve.invokeInternal(Standard > ContextValve.java:245) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextV > alve.java:199) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > eContext.java:151) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica > torBase.java:509) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > eContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav > a:567) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j > ava:184) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv > eContext.java:151) > > > > I attach my server.xml, anyone can help? > > Thanx in advance and regards > Marco > > > > > This e-mail, including any attachments, is a confidential business > communication, and may contain information that is confidential, > proprietary and/or privileged. This e-mail is intended only for the > individual(s) to whom it is addressed, and may not be saved, copied, > printed, disclosed or used by anyone else. If you are not the(an) > intended recipient, please immediately delete this e-mail from your > computer system and notify the sender. Thank you. > > --------------------------------------------------------------------- > 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]
