Re: No DB connection in Netscape ? Please help.

I could be on thin ice, but applets can only make connections to the site
that they were loaded from. I noticed a security... something or other in
the java console o/p (just a quick look). Maybe that explains why you can
connect on one machine, and not the other....

On Fri, 14 Aug 1998, Kapoor, Nishikant X wrote:

> Hello friends
>
> I have apache-1.1.3-3 and PostgreSQL-6.3.2 running on my Linux RH4.2,
> kernel 2.0.30 (genx). I have a Java Applet that tries to connect to
> PostgreSQL
> using JDBC, from NS-4.5b1 on an IBM RISC6000, AIX-4.1.4 (mm01).
>
> Typing "mm01: netscape http://genx/PrfApplet.htm" brings up the applet
> in the NS
> but the database connection is not established. The Java console shows:
>
> openDb(PrfDb):Connecting to Database URL = jdbc:postgresql:prfdb...
> openDb(PrfDb): Could not connect. e= security.Couldn't connect to
> 'localhost' with origin from 'genx'.
>
> The same problems exits when I start NS from the same machine where the
> PostgreSQL
> server is running i.e. the Linux box(genx).
>
> *** But, when I use "genx: netscape http://127.0.0.1/PrfApplet.htm" on
> genx, the
> *** database connection gets established.
>
> The two machines genx and mm01 are on the same network and can ping each
> other
> using the hostnames.
>
> THE CLASSPATH IS *NOT* SET ON RISC MACHINE (mm01) and the postgresql.jar
> is already
> in mm01:$MOZILLA_HOME/java/classes. The JDBC interface is as follows:
>
>     // Load the driver
>     try {
>       Class.forName(PrfConstants.DB_DRVR);
>     } catch(Exception e) {
>         System.out.println("openDb(PrfDb): Class.forName() failed. e= "
> + e.getMessage());
>         return (false);
>       }
>
>     // Connect to database
>     System.out.println("openDb(PrfDb):Connecting to Database. URL =
> jdbc:postgresql:prfdb...");
>     try {
>       connect = DriverManager.getConnection("jdbc:postgresql:prfdb",
> "postgres", "");
>     } catch (SQLException e) {
>         System.out.println("openDb(PrfDb): Could not connect to
> database. e=" + e.getMessage() );
>         connect = null;
>         return (false);
>       } catch (Exception e) {
>           System.out.println("openDb(PrfDb): Could not connect. e= " +
> e.getMessage());
>           connect = null;
>           return (false);
>         }
>
> Can someone please help me. This has been much more complicated than
> what I'd anticipated.
>
> I'm not sure if this is a problem at Java end or the PostgreSQL end. So,
> please
> excuse me if I've posted this problem to the wrong group. I'm just
> desperate for help !!!
>
> Thanks much in advance.
> Nishi
>
> --------To err is human but to really mess it up is computer--------
> mailto:nishikant.x.kapoor@nspco.com   http://www.c3ipros.com/nkapoor
> -----------------------------------~~~------------------------------
>