Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-4053531

JDBC-ODBC bridge times out on server connection

    Details

    • Subcomponent:
    • Resolved In Build:
      kestrel
    • CPU:
      generic
    • OS:
      solaris_2.5.1

      Description

      After upgrading to JDK 1.1.2 B(eta) on Solaris all database connections
      via a previously working ODBC interface to a Sybase 4.9.2 SQL Server
      database stopped working and generates the following error message

      SQL Server connection timed out.


      The specific details are using the JDK 1.1.2 B(eta) together with
      Intersolv's ODBC driver manager (bundled with Solaris) and their drivers
      (version 2.11b, 2.11s and 2.2) and connecting to a Sybase 4.9.2 SQL
      Server the connection to the database does appear to work anymore.
       
      The following example piece of code demonstrates the failure

      import java.sql.*;
      import java.util.*;
       
      public class DatabaseDemo {
              private static final String url = "jdbc:odbc:dayplanner";
              private static final String user = "useruser";
              private static final String password = "xxxxxx";
              private static final String server = "SAQQARA";
              private static final String db = "personplanner";
       
              DatabaseDemo() {
                      Connection con;
                      Statement stmt;
                      ResultSet rs;
                      Properties prop;
       
                      try {
                              // load driver
                              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                              prop = new Properties();
                              prop.put("user", user);
                              prop.put("password", password);
                              prop.put("server", server);
                              prop.put("db", db);
       
                              // debug - remove
                              DriverManager.setLogStream(System.out);
       
                              con = DriverManager.getConnection(url, prop);
       
                              // submit a query
                              stmt = con.createStatement();
                              rs = stmt.executeQuery("select name from sysusers");
       
                              while (rs.next()) {
                                      System.out.println(rs.getString("name"));
                              }
                      } catch (Exception e) {
                              System.err.println(e);
                      }
              }
       
              public static void main(String args[]) {
                      new DatabaseDemo();
              }
      }

      The odbc ini file was defined as ..

         ;
         ; @(#)odbc.ini 1.1 97/04/09.
         ;
       
         [ODBC Data Sources]
         dayplanner=Dayplanner database on karnak.uk - 4.9.2 Sybase
       
         [dayplanner]
         Driver=/opt/ISLIodbc/odbc/dlls/qess08.so
         Description=INTERSOLV Sybase Version ODBC Driver
         ServerName=SAQQARA
       
      The important bits of the environment used were ;

         LD_LIBRARY_PATH= /opt/java/JDK/1.1.2B/lib/sparc/green_threads:
                       /opt/ISLIodbc/odbc/dlls:
                       /opt/ISLIodbc/odbc/lib

         PATH included the database, and jdk bin directories

         CLASSPATH=.:/opt/java/JDK/1.1.2B/lib/classes.zip

      The complete error message generated were ;

      % java DatabaseDemo

      DriverManager.getConnection("jdbc:odbc:dayplanner")
          trying driver [className=sun.jdbc.odbc.JdbcOdbcDriver, context=null,
                         sun.jdbc.odbc.JdbcOdbcDriver @1dc60759]
      *Driver.connect (jdbc:odbc:dayplanner)
      JDBC to ODBC Bridge: Checking security
      No SecurityManager present, assuming trusted application/applet
      JDBC to ODBC Bridge 1.1001
      Current Date/Time: Tue May 20 17:39:25 GMT+01:00 1997
      Loading JdbcOdbc library
      Allocating Environment handle (SQLAllocEnv)
      hEnv=915672
      Allocating Connection handle (SQLAllocConnect)
      hDbc=917840
      Connecting (SQLDriverConnect), hDbc=917840, szConnStrIn=DSN=dayplanner;UID=dayplan;PWD=dDaAyY
      RETCODE = -1
      ERROR - Generating SQLException...
      SQLException: SQLState(S1T00) vendor code(0)
      java.sql.SQLException: [INTERSOLV][ODBC SQL Server driver][SQL Server]SQL Server connection timedout.
              at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3669)
              at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:3822)
              at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:1037)
              at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:153)
              at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:173)
              at java.sql.DriverManager.getConnection(DriverManager.java:91)
              at DatabaseDemo.<init>(DatabaseDemo.java:29)
              at DatabaseDemo.main(DatabaseDemo.java:44)
      Closing connection (SQLFreeConnect), hDbc=917840
      Closing environment (SQLFreeEnv), hEnv=915672
      getConnection failed: java.sql.SQLException: [INTERSOLV][ODBC SQL Server driver][SQL Server]SQL Server connection timed out.
      java.sql.SQLException: [INTERSOLV][ODBC SQL Server driver][SQL Server]SQL Server connection timedout.

        Attachments

          Activity

            People

            • Assignee:
              jellissunw Jon Ellis (Inactive)
              Reporter:
              duke J. Duke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Imported:
                Indexed: