[unixODBC-support] No suitable driver" from JAVA programm running IBM JDK 1.4.2

[Nick Gorham]

Philippe Couas wrote:

>Hi,
>
>Could you precise "registered the bridge", it's into JDK 1.4.2 ?
>That's ok on same server when i use JDK 1.5 ?
>
>Regards
>Philippe
>  
>

Well, given that I try and avoid java where possible, but the jdbc DM 
will try and search though its loaded classes for one that is happy with 
the jdbc:odbc prefix, if you are not finding one, then its becasue the 
java version of the DM doesn't have that in it slist of classes. You may 
not be explicitly loading the class, but if its in your exp directory, 
or generally around the classpath in one case, but not the other it 
could explain whats going on.

To quote Sun:

> The Bridge is used by opening a JDBC connection using a URL with the 
> |odbc| subprotocol. See below for URL examples. Before a connection 
> can be established, the bridge driver class, 
> |sun.jdbc.odbc.JdbcOdbcDriver|, must either be added to the 
> |java.lang.System| property named |jdbc.drivers|, or it must be 
> explicitly loaded using the Java class loader. Explicit loading is 
> done with the following line of code:
>
>    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
>  
>

-- 
Nick