[garyg]

Hi

i’m trying to create a standalone spring-hibernate application using Eclipse and Apache Tomcat 5.0.28 with MySql at the backend. I’m constantly bugged by this error and unable to find a solution. I’ve added the “mysql-connector-java-3.0.1-beta-bin.jar” to WEB-INF lib as well as to Tomcat common/lib as well as shared lib. Dunno why this is happening ? Given below is my console error

Feb 22, 2007 5:33:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 0, SQLState: null
Feb 22, 2007 5:33:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Cannot create PoolableConnectionFactory (Communication failure during handshake. Is there a MySQL server running on localhost:3306?)
Feb 22, 2007 5:33:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 0, SQLState: null
Feb 22, 2007 5:33:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Cannot create PoolableConnectionFactory (Communication failure during handshake. Is there a MySQL server running on localhost:3306?)
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at TestDAO.storeEmployee(TestDAO.java:43)
at TestController.onSubmit(TestController.java:60)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:258)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:249)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communication failure during handshake. Is there a MySQL server running on localhost:3306?)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
… 40 more
Caused by: java.sql.SQLException: Communication failure during handshake. Is there a MySQL server running on localhost:3306?
at com.mysql.jdbc.MysqlIO.init(MysqlIO.java:628)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1621)
at com.mysql.jdbc.Connection.connectionInit(Connection.java:901)
at com.mysql.jdbc.Driver.connect(Driver.java:311)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
… 43 more

[Haris Peco]

garyg,

Can you access to MySQL from MyEclipse DbExplorer ?
It look sthat your MySQl server is not installed correctly or your JDBC/hibernate parameters aren’t good.

Regards,

[garyg]

Hi,

Yes, I can access MySql from MyEclipse DbExplorer.
I did not get any error while configuring my MySql instance.
Mrever when i chek in srvice, it shows that mysql server has been started and also
at the commnd prmpt i culd see that the TCP port at 3306 is listening.

Could it be that due to firewall i’m not able to connct to the port ?

attached below is my hibernate config in ApplicationContext.xml

<bean id=”exampleHibernateProperties” class=”org.springframework.beans.factory.config.PropertiesFactoryBean”>
<property name=”properties”>
<props>
<property name=”hibernate.connection.driver_class”>com.mysql.jdbc.Driver</property>
<property name=”hibernate.connection.url”>jdbc:mysql://localhost:3306/test</property>
<property name=”hibernate.connection.username”>xyz</property>
<property name=”hibernate.connection.password”>xyz</property>
<property name=”dialect”>org.hibernate.dialect.MySQLDialect</property>
<property name=”show_sql”>true</property>
<property name=”transaction.factory_class”>org.hibernate.transaction.JDBCTransactionFactory</property>
<property name=”hibernate.cache.provider_class”>org.hibernate.cache.HashtableCacheProvider </property>
<prop key=”hibernate.jdbc.use_streams_for_binary”>true</prop>
<prop key=”hibernate.show_sql”>false</prop>
</props>
</property>
</bean>

Do tell me whether its ok?

Regards-
gary

[Haris Peco]

It looks fine.Try use newer jdbc driver (3.1.14 or 5.0.4)

Regards,

[garyg]

Hi,

Thanks a lot … was able to solve the problem.
I added the “mysql-connector-java-3.1.14-bin.jar” in my
“jakarta-tomcat-5.0.28\shared\lib” as well as “common\lib”
and was able to solve the error.

Regards-
Gary G

[Author]

Posts