From: Ralf Lehmann <ralf@lehmann.cc>
To: Allan Huffman <huffmana@ppc.pims.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem
Date: Mon, 21 Feb 2000 16:46:31 +0100
Message-ID: <38B15DD7.6B923BD0@lehmann.cc> (raw)
References: <38B0EB27.41E8B2D8@ppc.pims.org>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ralf@lehmann.cc, huffmana@ppc.pims.org
Subject: Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem
In-Reply-To: <38B15DD7.6B923BD0@lehmann.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox