Communication failure during handshake
hi all, i am using tomcat4.1.29 with mysql with deafault conection pooling. i get this error. Communication failure during handshake. Is there a server running on localhost:3306? can any one please tell me what could be wroung? Bopanna - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Communication failure during handshake. Is there a server running on localhost:3306?
hi all, i configured tomcat 4.1.29 with mysql 4.1 . when i try to use the default connection pooling of tomcat i get the following error. can some one help me solve this? Thanks Bopanna javax.servlet.ServletException: Cannot create PoolableConnectionFactory, cause: Communication failure during handshake. Is there a server running on localhost:3306? at org.apache.jasper.runtime.PageContextImpl.handlePageException (PageContextImpl.java:536) at org.apache.jsp.test_jsp._jspService(test_jsp.java:67) at org.apache.jasper.runtime.HttpJspBase.service (HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java:210) at org.apache.jasper.servlet.JspServlet.serviceJspFile (JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service (JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service (CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCon nection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt (PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:666) at java.lang.Thread.run(Thread.java:536) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Communication failure during handshake. Is there a server running on localhost:3306?
At 08:23 PM 12/5/2003 +0530, you wrote: hi all, i configured tomcat 4.1.29 with mysql 4.1 . when i try to use the default connection pooling of tomcat i get the following error. can some one help me solve this? Thanks Bopanna Port 3306 is the mysql port, so you should be checking whether your mysql server is running. Also, the java server is expecting to find it on the same system. If you have it on a different system, you need to configure Tomcat to look for it elsewhere. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
java.sql.SQLException: Communication failure during handshake
I am getting this repeatedly, not sure what is causing it, using dbcp and tomcat. I searched on google and it looks like other people have had it as well. Does anybody know what could be causing this or how to fix it? Thre are my connection pool settings. This is a high traffic site so I have set it to keep 50 threads in teh pool and grow as needed (and I assume it will shrink when idle back down to 50) connectionPool = new GenericObjectPool(null); connectionPool.setMaxActive(50); byte b = 2; connectionPool.setWhenExhaustedAction(b); connectionPool.setMaxIdle(50); connectionPool.setNumTestsPerEvictionRun(5); connectionPool.setTestWhileIdle(true); connectionPool.setTimeBetweenEvictionRunsMillis(2); connectionPool.setTestOnBorrow(false); connectionPool.setTestOnReturn(false); Travis Reeder Space Program http://www.spaceprogram.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: java.sql.SQLException: Communication failure during handshake
I was seeing this with MySQL connector/j 2.x. Installing 3.0.6 cleared it up. On Thursday, Feb 27, 2003, at 19:55 US/Central, [EMAIL PROTECTED] wrote: I am getting this repeatedly, not sure what is causing it, using dbcp and tomcat. I searched on google and it looks like other people have had it as well. Does anybody know what could be causing this or how to fix it? Thre are my connection pool settings. This is a high traffic site so I have set it to keep 50 threads in teh pool and grow as needed (and I assume it will shrink when idle back down to 50) connectionPool = new GenericObjectPool(null); connectionPool.setMaxActive(50); byte b = 2; connectionPool.setWhenExhaustedAction(b); connectionPool.setMaxIdle(50); connectionPool.setNumTestsPerEvictionRun(5); connectionPool.setTestWhileIdle(true); connectionPool.setTimeBetweenEvictionRunsMillis(2); connectionPool.setTestOnBorrow(false); connectionPool.setTestOnReturn(false); Travis Reeder Space Program http://www.spaceprogram.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]