JTDS jdbc driver

[Venkatesh Kumar]

Hi All:

I am getting the following exception when I run a simple jdbc pgm which is appended below.the exception is

ava.sql.SQLException: Network error IOException: Connection refused: connectat et.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:307)at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)

has anyone faced such an issue ,any help is appreciated.

Thanks,

import java.sql.*;
public class Connect
  {
  private java.sql.Connection con = null;
  private final String portNumber = "1433";
  private final String databaseName = "Test1";
  private final String userName = "sa";
  private final String password = "password";
  private final String selectMethod = "cursor";
  // Constructor
  public Connect()
    {
    }
  private String getConnectionUrl()
    {
    return "jdbc:jtds:sqlserver://ABC:1433/Test1";
    }
  private java.sql.Connection getConnection()
    {
    try
      {
      Class.forName("net.sourceforge.jtds.jdbc.Driver");
      con = java.sql.DriverManager.getConnection(getConnectionUrl(),      userName, password);
      if (con != null) System.out.println("Connection Successful!");
      }
    catch (Exception e)
      {
      e.printStackTrace();
      System.out.println("Error Trace in getConnection() : " + e.getMessage());
      }
    return con;
    }
  
  public void displayDbProperties()
    {
    java.sql.DatabaseMetaData dm = null;
    java.sql.ResultSet rs = null;
    try
      {
      con = this.getConnection();
      if (con != null)
        {
        dm = con.getMetaData();
        System.out.println("Driver Information");
        System.out.println("\tDriver Name: " + dm.getDriverName());
        System.out.println("\tDriver Version: " + dm.getDriverVersion());
        System.out.println("\nDatabase Information ");
        System.out.println("\tDatabase Name: " + dm.getDatabaseProductName());
        System.out.println("\tDatabase Version: " + dm.getDatabaseProductVersion());
        System.out.println("Avalilable Catalogs ");
        rs = dm.getCatalogs();
        while (rs.next())
          {
          System.out.println("\tcatalog: " + rs.getString(1));
          }
        rs.close();
        rs = null;
        closeConnection();
        }
      else
        System.out.println("Error: No active Connection");
      }
    catch (Exception e)
      {
      e.printStackTrace();
      }
    dm = null;
    }
  
  private void closeConnection()
    {
    try
      {
      if (con != null)
        con.close();
      con = null;
      }
    catch (Exception e)
      {
      e.printStackTrace();
      }
    }
  public static void main(String[] args) throws Exception
    {
    Connect myDbTest = new Connect();
    myDbTest.displayDbProperties();
    }
  }  

[edited to add code tags]
[ December 09, 2004: Message edited by: Jeanne Boyarsky ]

[Paul Sturrock]

Assuming you username and password are correct that looks OK. Check your connection parameters - make sure your servername is correct and your database name is correct too.