Mqsql DB connection Issue

[Meet Gaurav]

While accessing the Mqsql DB am facing this issue. Please help me to resolve this issue. I tried changing the my sql driver from 5.1 to 5.08. But same error.

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnection
Factory (Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection timed out: connect

STACKTRACE:

java.net.ConnectException: Connection timed out: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:529)
        at java.net.Socket.connect(Socket.java:478)
        at java.net.Socket.<init>(Socket.java:375)
        at java.net.Socket.<init>(Socket.java:218)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:256)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:285)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(
DriverConnectionFactory.java:37)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Pool
ableConnectionFactory.java:290)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory
(BasicDataSource.java:877)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat
aSource.java:851)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:540)
        at com.academicone.utility.DBServiceConnection.getConnection(DBServiceCo
nnection.java:48)
        at com.academicone.dao.LoginValidateDAO.validatePassword(LoginValidateDA
O.java:235)
        at com.academicone.common.ClassUtil.validatePassword(ClassUtil.java:21)
        at com.academicone.common.LoginGlobalUser.validateUseridPassword(LoginGl
obalUser.java:46)
        at com.academicone.actionhandler.WorkFlowHandler.handleLoginDetails(Work
FlowHandler.java:64)
        at com.academicone.actionhandler.WorkFlowHandler.process(WorkFlowHandler
.java:34)
        at com.academicone.actionhandler.LoginHandler.execute(LoginHandler.java:
47)
        at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:484)
        at com.academicone.processor.action.ProcessHandler.processActionPerform(
ProcessHandler.java:132)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148
2)
        at com.academicone.processor.action.ApplicationController.doPost(Applica
tionController.java:58)
        at com.academicone.processor.action.ApplicationController.doGet(Applicat
ionController.java:31)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:228)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:212)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:634)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
5)
        at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat
aSource.java:855)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:540)
        at com.academicone.utility.DBServiceConnection.getConnection(DBServiceCo
nnection.java:48)
        at com.academicone.dao.LoginValidateDAO.validatePassword(LoginValidateDA
O.java:235)
        at com.academicone.common.ClassUtil.validatePassword(ClassUtil.java:21)
        at com.academicone.common.LoginGlobalUser.validateUseridPassword(LoginGl
obalUser.java:46)
        at com.academicone.actionhandler.WorkFlowHandler.handleLoginDetails(Work
FlowHandler.java:64)
        at com.academicone.actionhandler.WorkFlowHandler.process(WorkFlowHandler
.java:34)
        at com.academicone.actionhandler.LoginHandler.execute(LoginHandler.java:
47)
        at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:484)
        at com.academicone.processor.action.ProcessHandler.processActionPerform(
ProcessHandler.java:132)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148
2)
        at com.academicone.processor.action.ApplicationController.doPost(Applica
tionController.java:58)
        at com.academicone.processor.action.ApplicationController.doGet(Applicat
ionController.java:31)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:228)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:212)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:634)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
5)
        at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure d
ue to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection timed out: connect

STACKTRACE:

java.net.ConnectException: Connection timed out: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:529)
        at java.net.Socket.connect(Socket.java:478)
        at java.net.Socket.<init>(Socket.java:375)
        at java.net.Socket.<init>(Socket.java:218)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:256)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:285)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(
DriverConnectionFactory.java:37)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Pool
ableConnectionFactory.java:290)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory
(BasicDataSource.java:877)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat
aSource.java:851)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
urce.java:540)
        at com.academicone.utility.DBServiceConnection.getConnection(DBServiceCo
nnection.java:48)
        at com.academicone.dao.LoginValidateDAO.validatePassword(LoginValidateDA
O.java:235)
        at com.academicone.common.ClassUtil.validatePassword(ClassUtil.java:21)
        at com.academicone.common.LoginGlobalUser.validateUseridPassword(LoginGl
obalUser.java:46)
        at com.academicone.actionhandler.WorkFlowHandler.handleLoginDetails(Work
FlowHandler.java:64)
        at com.academicone.actionhandler.WorkFlowHandler.process(WorkFlowHandler
.java:34)
        at com.academicone.actionhandler.LoginHandler.execute(LoginHandler.java:
47)
        at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:484)
        at com.academicone.processor.action.ProcessHandler.processActionPerform(
ProcessHandler.java:132)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148
2)
        at com.academicone.processor.action.ApplicationController.doPost(Applica
tionController.java:58)
        at com.academicone.processor.action.ApplicationController.doGet(Applicat
ionController.java:31)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:228)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:212)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:634)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
5)
        at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:285)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(
DriverConnectionFactory.java:37)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Pool
ableConnectionFactory.java:290)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory
(BasicDataSource.java:877)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat
aSource.java:851)
        ... 28 more

[Paul Clapham]

Like the message says, the driver can't connect to wherever the configuration says the MySQL server is running. This is a network configuration problem and no amount of futzing with software will fix it. Perhaps you don't have a MySQL server running. Or perhaps the configuration isn't pointing to it. Or perhaps there's a firewall or some other network artifact which prevents the connection.

[Meet Gaurav]

Even I tried disabling the firewall, but no difference... any other suggestion please.
my context.xml

<Context path="/weblogicDS" 
         docBase="weblogicDS" 
         debug="5"
         reloadable="true" 
         crossContext="true">
      <Resource name="weblogicDS"
                auth="Container"
                type="javax.sql.DataSource"
                maxActive="100" 
                maxIdle="30" 
                maxWait="10000" 
                username="ranchco" 
                password="ranch123" 
                driverClassName="com.mysql.jdbc.Driver" 
                url="jdbc:mysql://180.121.22.22:1800/abuse_DEV"/>
</Context>

[Paul Clapham]

Any suggestions? Like the other suggestions which I mentioned but you ignored?

Okay. One small step at a time. Is there a MySQL server running at 180.121.22.22? Is it listening at port 1800?

[Meet Gaurav]

yes it's running and listening... I tested the db connection by using a small program. I guess the program is by using connection pool.

[Paul Clapham]

May I ask whether you ran that "small program" on the same computer where this problem is occurring, or on a different computer?

[Meet Gaurav]

You are right.. I ran that in diff computer (server were DB is running). I guess some issues on my computer.

But I tried disabling the firewall on my computer (It's windows 7 64 bit). Any other suggestion please