No DB connection in Netscape ? Please help.

Поиск
Список
Период
Сортировка
От Kapoor, Nishikant X
Тема No DB connection in Netscape ? Please help.
Дата
Msg-id C7DCBA49A357D11196A500805F851ACD0146165C@MNMAIL04
обсуждение исходный текст
Ответы Re: No DB connection in Netscape ? Please help.  (Kenny Freeman <freeman@cs.dal.ca>)
Re: [INTERFACES] No DB connection in Netscape ? Please help.  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-general
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
-----------------------------------~~~------------------------------


В списке pgsql-general по дате отправления:

Предыдущее
От: James Olin Oden
Дата:
Сообщение: Re: [GENERAL] getting the currval of a sequence
Следующее
От: Kenny Freeman
Дата:
Сообщение: Re: No DB connection in Netscape ? Please help.