Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    7

    Unanswered: Connection Timed out error

    I'm using some db replication tool written in JAVA. Where in the config file I have entered db driver, db url, sa and password. This tool lies in ubuntu. I couldn't able to connect to MS SQL server. What might be the possible reasons?

  2. #2
    Join Date
    Aug 2012
    Posts
    7
    -------------------------------------------------------------------------------
    An exception occurred. Please see the following for details:
    -------------------------------------------------------------------------------
    java.net.ConnectException: Connection timed out
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(Abstrac tPlainSocketImpl.java:327)
    at java.net.AbstractPlainSocketImpl.connectToAddress( AbstractPlainSocketImpl.java:193)
    at java.net.AbstractPlainSocketImpl.connect(AbstractP lainSocketImpl.java:180)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:384)
    at java.net.Socket.connect(Socket.java:546)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:616)
    at net.sourceforge.jtds.jdbc.SharedSocket.createSocke tForJDBC3(SharedSocket.java:305)
    at net.sourceforge.jtds.jdbc.SharedSocket.<init>(Shar edSocket.java:255)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(C onnectionJDBC2.java:323)
    [wrapped] java.sql.SQLException: Network error IOException: Connection timed out
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(C onnectionJDBC2.java:395)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(C onnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.ja va:184)
    at org.apache.commons.dbcp.DriverConnectionFactory.cr eateConnection(DriverConnectionFactory.java:3
    at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.dbcp.BasicDataSource.validateCo nnectionFactory(BasicDataSource.java:1556)
    at org.apache.commons.dbcp.BasicDataSource.createPool ableConnectionFactory(BasicDataSource.java:1545)
    [wrapped] org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out)
    at org.apache.commons.dbcp.BasicDataSource.createPool ableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createData Source(BasicDataSource.java:138
    at org.apache.commons.dbcp.BasicDataSource.getConnect ion(BasicDataSource.java:1044)
    at org.jumpmind.symmetric.AbstractCommandLauncher.tes tConnection(AbstractCommandLauncher.java:325)
    [wrapped] java.lang****ntimeException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out)
    at org.jumpmind.symmetric.AbstractCommandLauncher.tes tConnection(AbstractCommandLauncher.java:329)
    at org.jumpmind.symmetric.AbstractCommandLauncher.get DatabasePlatform(AbstractCommandLauncher.java:336)
    at org.jumpmind.symmetric.DbImportCommand.executeWith Options(DbImportCommand.java:104)
    at org.jumpmind.symmetric.AbstractCommandLauncher.exe cute(AbstractCommandLauncher.java:130)
    at org.jumpmind.symmetric.DbImportCommand.main(DbImpo rtCommand.java:65)
    -------------------------------------------------------------------------------

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    It can be several things.

    1) Can you resolve the name of the SQL Server from the Ubuntu machine?
    2) Is the SQL Server listening on TCP/IP (is the TCP/IP protocol enabled)?
    3) Is the firewall on either machine running, and have the correct ports been opened up?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •