Skip site navigation (1) Skip section navigation (2)

JDBC/Netscape/PostgreSQL Problem

From: "Allan Huffman" <huffmana(at)ppc(dot)pims(dot)org>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC/Netscape/PostgreSQL Problem
Date: 2000-02-21 07:37:12
Message-ID: 38B0EB27.41E8B2D8@ppc.pims.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
Java Database Connection Problem

Environment:
The hope.class, java application is working under the Visual Café (Data
Base Edition 3.0c) environment using jdbc6_5-1_1.jar (loaded in the
Internal VM in the Environmental Options, as a classpath setting).  The
PostgreSQL database (Version 6.5.2) is running on the Sun Sparc
demo.ppc.pims.org.  The web server is running Netscape Suitespot 3.5.1
on another Sparc.  Our user’s will access the web server using Netscape
Communicator 4.5 or higher from a PC running Windows NT 4.0 Service Pack
4 or 5.

Suitespot Administrator Setup
      An additional Directory is made with the Suitespot Administrator
as follows:
      ADDITIONAL DOCUMENT DIRECTORY
      Prefix /hope
      Directory /vol1/HTML/pass

The Suitespot Administrator configuration is:
       Primary: Directory /vol1/HTML
       Index Filenames: index.html,home.html,index.htm

The following is in the script for starting the Suitespot server, the
https-default “start” script:

CLASSPATH=$CLASSPATH:/export/home/huffmana/postgresql.jar:/export/home/huffmana:

      /vol1/HTML/pass:/vol1/HTML/pass/postgresql.jar

I’ve also set the CLASSPATH in the UNIX shell before starting “nohup
postmaster –i”

HTML
       <HTML>
      <HEAD>
      <TITLE>hope.html</TITLE>
      </HEAD>
      <BODY>
      <APPLET CODE="hope.class" archive="postgresql.jar" WIDTH=665
HEIGHT=631></APPLET>
      </BODY>
      </HTML>

Running from Netscape Communicator
      Netscape Communications Corporation -- Java 1.1.5
      Type '?' for options.
      Symantec Java! ByteCode Compiler Version 210.065
      Copyright (C) 1996-97 Symantec Corporation
      ===>INSTANTIATE CONNECTIONMGR<===
      {{{{{{{{{{{{{{{{{JDBCConnection 1}}}}}}}}}}}}}}}}}}}
      {{{{{{{{{{{{{{{{{INITIALIZATION 1}}}}}}}}}}}}}}}}}}}
      {{{{{{{{{{{ATTEMPT CONNECTION demo.ppc.pims.org}}}}}}}}}}}}}
      java.lang.NullPointerException
        at postgresql.util.PSQLException.translate(Compiled Code)
        at postgresql.util.PSQLException.<init>(Compiled Code)
        at postgresql.Driver.connect(Compiled Code)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at ConnectionMgr1.<init>(Compiled Code)
        at hope.init(Compiled Code)
      * at
netscape.applet.DerivedAppletFrame$InitAppletEvent.dispatch(Compiled
Code)
        at
java.awt.EventDispatchThread$EventPump.dispatchEvents(Compiled Code)
        at java.awt.EventDispatchThread.run(Compiled Code)
        at
netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(Compiled
Code)

Java Code
       The null pointer occurs at the getConnection statement
            Connection con;
            con = DriverManager.getConnection(
                "jdbc:postgresql://demo.ppc.pims.org/cpass",
                "postgres",
                "postgres");

I’ve tried using the IP address with the same results.  Any ideas?

Allan from Belgium




Responses

pgsql-interfaces by date

Next:From: Robert EsserDate: 2000-02-21 09:33:42
Subject: Problems with PostgreSQL ODBC-Driver
Previous:From: Artur KulińskiDate: 2000-02-21 07:34:05
Subject: PGaccess Cannot connect to DB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group