Jdbc connection fail with Mysql

Hi All,

I am using my Sql 5.5 for database. While connecting using JDBC i am getting connection failed exception ....

Please see blow code. and exception...

Please help me to resolve this issue.....

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sandeeptest? user=root&password=sandeep&autoReconnect=true");

Statement st = con.createStatement();

ResultSet rs = st.executeQuery("select * from addressbook");

while(rs.next())

{

System.out.println("Name ::::::: "+rs.getString(1));

System.out.println("Address:::::"+rs.getString(2));

}

} catch (Exception ex)

{

ex.printStackTrace();

}

java.sql.SQLException: Server connection failure during transaction.

Attempted reconnect 3 times. Giving up.

at com.mysql.jdbc.Connection.createNewIO(Connection.java:1704)

at com.mysql.jdbc.Connection.<init>(Connection.java:491)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.san.action.HomeAction.execute(HomeAction.java:93)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Unknown Source)

INFO [http-8080-Processor24] (PropertyMessageResources.java:127) - Initializing, config='org.apache.struts.taglib.bean.LocalStrings', returnNull=true

ERROR [http-8080-Processor24] (ApplicationDispatcher.java:704) - Servlet.service() for servlet jsp threw exception

javax.servlet.jsp.JspException: Missing message for key "app.name"

at org.apache.struts.taglib.bean.MessageTag.doStartTag(MessageTag.java:297)

at org.apache.jsp.success_jsp._jspx_meth_bean_message_0(org.apache.jsp.success_jsp:115)

at org.apache.jsp.success_jsp._jspService(org.apache.jsp.success_jsp:69)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)

at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)

at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)

at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)

at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:614)

at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:137)

at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:177)

at org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:756)

at org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:881)

at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:473)

at org.apache.jsp.layout_jsp._jspx_meth_tiles_insert_3(org.apache.jsp.layout_jsp:270)

at org.apache.jsp.layout_jsp._jspService(org.apache.jsp.layout_jsp:119)