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 users 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
Ive 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");
Ive tried using the IP address with the same results. Any ideas?
Allan from Belgium
