Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problems using, IE5 MS-VM and JDBC driver

Problems using, IE5 MS-VM and JDBC driver

From
Georg Ritter
Date:
Hello, 


I wrote a little Java applet which uses jdbc to connect to a 
pg installed on a linux box. 

It works with Nectscape 4.5/6 but when I try to start
the applet with IE5 ( JIT on and off ) I get the SQLException
"No suitable driver found", thrown by the first try block (see
program code below). 

I don't understand where the problem comes from. It seems to 
be correctly done if it works with Netscape? 
Any ideas around there?

The driver is situated in a subdir of the applet: ..../applet/postgres/
( single .class files, structure as in the postgres dist. )

I used jdk1.2 port for linux for compiling the driver.



The code I use to load the driver:
...
import java.sql.*;
import java.net.URL;
import java.net.MalformedURLException;
...   private void initDBconnection()   {       String url = "jdbc:postgresql://a.b.c:5000/mydb?" +
"user=thename?password=thepasswd&auth=password";      String usr = "thename";        String pwd = "thepasswd";
 
       String query = "select kreis, name from locationdata where nummer<10";              try {  Class.forName(
"postgresql.Driver"); }        catch( Exception ex )        {    d( "could not do theSatwebDBnect to SATWeb" + ex, 100
);          Error( "DBError");        }       try        {           theSatwebDB = DriverManager.getConnection( url,
usr,pwd );       }        catch( SQLException ex )        {    d("The connection to SATWeb failed:" +ex+"\n", 100);
 }   }
 

Greetings, 
Georg Ritter
--------------------------------------------------------------------- student at department of physics University of
Innsbruck,Austria            Georg.Ritter@uibk.ac.at

Re: [INTERFACES] Problems using, IE5 MS-VM and JDBC driver

From
Peter T Mount
Date:
On Mon, 14 Jun 1999, Georg Ritter wrote:

[catching up with emails here]

> Hello, 
> 
> 
> I wrote a little Java applet which uses jdbc to connect to a 
> pg installed on a linux box. 
> 
> It works with Nectscape 4.5/6 but when I try to start
> the applet with IE5 ( JIT on and off ) I get the SQLException
> "No suitable driver found", thrown by the first try block (see
> program code below). 

> The driver is situated in a subdir of the applet: ..../applet/postgres/
> ( single .class files, structure as in the postgres dist. )

That should work (as it's the last resort)

> I used jdk1.2 port for linux for compiling the driver.

Ah, this may be a problem, as IE may not exactly be 1.2 compatible (I'm
not sure here).

> The code I use to load the driver:

>         String url = "jdbc:postgresql://a.b.c:5000/mydb?" +
>                      "user=thename?password=thepasswd&auth=password";

Drop the ? and the parameters, as you are supplying them in the
getConnection() method.

Also auth has not been implemented since 6.3 (when the new protocol came
into force), so it's wasting space here. Since 6.3, the protocol
determines the authentication scheme before the driver sends the user &
password.

>             theSatwebDB = DriverManager.getConnection( url, usr, pwd );

--       Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf