🚀 go-pugleaf

MJR <Rao.Mohith@compaq.com> wrote in message
news:7k8ch6$j8u$1@mailint03.im.hou.compaq.com...
> Does anyone know why the following code throws an exception (I got the
code
> straight off the java.sun.com tutorial on JDBC)?
>
> try {
>     Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
> }
> catch( Exception e ) {
>     System.err.println( "Failed to load JDBC/ODBC driver." );
>     return;
> }
>
I had the same problem trying to use the JDBC/ODBC bridge using their
tutorial code.  The following seems to work better :

try
   { Driver jdbcDriver = (Driver)Class.forName(jdbcClassName).newInstance();
    if (jdbcDriver != null)
     { Properties info = new Properties();
      m_Connection = jdbcDriver.connect(connectionString,info);
     }
   }
  catch (ClassNotFoundException e)
   { System.err.println("FATAL ERROR : Failed to obtain jdbc class " +
jdbcClassName  + "\n" + e.getMessage());
    e.printStackTrace();
    return false;
   }
  catch (InstantiationException e)
   { System.err.println("FATAL ERROR : Failed to obtain jdbc class " +
jdbcClassName  + "\n" + e.getMessage());
    e.printStackTrace();
    return false;
   }
  catch (SQLException e)
   { System.err.println("FATAL ERROR : Failed to obtain jdbc connection " +
connectionString  + "\n" + e.getMessage());
    e.printStackTrace();
    return false;
   }
  catch (IllegalAccessException e)
   { System.err.println("FATAL ERROR : Failed to obtain jdbc connection " +
connectionString  + "\n" + e.getMessage());
    e.printStackTrace();
    return false;
   }
  return true;

Hope this helps,
Donald Munro (donaldm@tricom.co.za)