Received: from smtp.myokay.net (db.myokay.net [195.211.211.74])
	by hub.org (8.9.3/8.9.3) with SMTP id KAA01212
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 21 Feb 2000 10:48:11 -0500 (EST) (envelope-from ralf@lehmann.cc)
Received: (qmail 13137 invoked for bounce); 21 Feb 2000 15:48:04 -0000
Received: from unknown (HELO lehmann.cc) (194.29.45.56)
	by smtp.myokay.net with SMTP; 21 Feb 2000 15:48:04 -0000
Message-ID: <38B15DD7.6B923BD0@lehmann.cc>
Date: Mon, 21 Feb 2000 16:46:31 +0100
From: Ralf Lehmann <ralf@lehmann.cc>
Reply-To: ralf@lehmann.cc
X-Mailer: Mozilla 4.7 [de]C-NECCK  (Win98; I)
X-Accept-Language: de, en,en-US
MIME-Version: 1.0
To: Allan Huffman <huffmana@ppc.pims.org>
CC: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem
References: <38B0EB27.41E8B2D8@ppc.pims.org>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit



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.