Postgres Pro
Downloads
Home   >   mailing lists

Thread: JDBC/Netscape/PostgreSQL Problem

JDBC/Netscape/PostgreSQL Problem

From
"Allan Huffman"
Date:
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.
SymantecJava! 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(CompiledCode)     * 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

Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem

From
Ralf Lehmann
Date:

Allan Huffman schrieb:
> 
> 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");


try again wiht con = DriverManager.getConnection(
>                 "jdbc:postgresql://demo.ppc.pims.org:port/cpass",  //the port who postresql runs most 5432
>                 "postgres",
>                 "postgres");


mfg
ralf lehmann

PS:look in the jdbc sources at
/pqsql/src/interfaces/jdbc/postgresql/driver.java
there are comments to the getConnection func.