🚀 go-pugleaf

You can't use the jdbc-odbc bridge the way you proposed from an applet.  Use
a servlet or a middleware proxy server.


Donald Munro wrote in message <7kas0c$kik$1@hermes.is.co.za>...
>
>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)
>
>