Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem

From: Ralf Lehmann <ralf(at)lehmann(dot)cc>
To: Allan Huffman <huffmana(at)ppc(dot)pims(dot)org>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem
Date: 2000-02-21 15:46:31
Message-ID: 38B15DD7.6B923BD0@lehmann.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Floyd Shackelford 2000-02-21 15:48:24 solved: driver not found error
Previous Message richard clark 2000-02-21 15:18:22 Problems in ODBC driver