Thread: RE: [INTERFACES] JDBC & IE40

RE: [INTERFACES] JDBC & IE40

From
Mikael Hammarin
Date:
> On Mon, 27 Jul 1998, Mikael Hammarin wrote:
>
> > Hello,
> >
> > Since the bug in Internet Explorer 4.0 doesn't allow you to
> > make a Class.forName("portgresql.Driver") to load the postgresql-
> > driver, I now load it manually with DriverManager.registerDriver()
> > instead.  However, now I get a "not-very-wanted" errormsg
> > "cannot access "hostname.com""... ?
>
> Is hostname.com your postgresql server?
>
> I presume you are using:
>
>     java.sql.DriverManager.registerDriver(new Driver());
>
> This is how the driver registers itself
>
Yes, hostname.com *IS* a valid host, and it DOES exist.
I use:
-- snip --
    postgresql.Driver driver = new postgresql.Driver();
    try {
    DriverManager.registerDriver(driver);
    }
    catch(Exception e) {
      textStatus.setText(e.toString());
    }
-- snip --
to register the driver.

This part works though.  The problem is when I try to make
a connection:
    conn = DriverManager.getConnection(connectionURL);

This generate an exception as I mentioned above, and returns
"cannot access <hostname>".  I searched through the java-classes,
but I didn't find this string *anywhere*.  That's why I wondered
where it came from.  (it's not an standard hostnotfound exception)

However, the strange part is, that this *ONLY* happen when I run
my program as an Applet in IE40.  It *DOES* work perfect if I run
the program as an application or in hotjava.  I.e. It only seem
to happen in MSIE40.  In other words, I know that the JDBCURL is
right and that access-lists are correct.

I was thinking that maybe the postgresql driver doesn't work correctly
when you register it with registerDriver() instead of Class.forName()?

Have you got JDBC working in IE40?
Cheers
//Mike

> > Anyone familiar with this? What class generates this msg?
> > (what exception?)
>
> The only place I can think is IOException (unless your
> postgresql server
> is not the same as the web server).

RE: [INTERFACES] JDBC & IE40

From
Peter T Mount
Date:
On Mon, 27 Jul 1998, Mikael Hammarin wrote:

> Yes, hostname.com *IS* a valid host, and it DOES exist.
> I use:
> -- snip --
>     postgresql.Driver driver = new postgresql.Driver();
>     try {
>     DriverManager.registerDriver(driver);
>     }
>     catch(Exception e) {
>       textStatus.setText(e.toString());
>     }

Change the above to:

>       textStatus.setText(e.getClass().getName()+" "+e.toString());

and let me know what exception is being thrown.

> -- snip --
> to register the driver.
>
> This part works though.  The problem is when I try to make
> a connection:
>     conn = DriverManager.getConnection(connectionURL);
>
> This generate an exception as I mentioned above, and returns
> "cannot access <hostname>".  I searched through the java-classes,
> but I didn't find this string *anywhere*.  That's why I wondered
> where it came from.  (it's not an standard hostnotfound exception)

I haven't been able to find it either.

> However, the strange part is, that this *ONLY* happen when I run
> my program as an Applet in IE40.  It *DOES* work perfect if I run
> the program as an application or in hotjava.  I.e. It only seem
> to happen in MSIE40.  In other words, I know that the JDBCURL is
> right and that access-lists are correct.

This sounds like IE40 doesn't like JDBC... I'm actually on holiday this
week, and I don't use IE40 here, so I can't test it.

> I was thinking that maybe the postgresql driver doesn't work correctly
> when you register it with registerDriver() instead of Class.forName()?

Class.forName() simply loads the supplied class into the VM. the
postgresql.Driver class does contain a static initializer which registers
the driver using registerDriver().

> Have you got JDBC working in IE40?

All of my java work is with applications.

I haven't tried it with IE40, although I know people have got the driver
working with Applets - they haven't told me what browsers they were using.
I assume it was both Netscape and IE

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk