Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem
От | Ralf Lehmann |
---|---|
Тема | Re: [INTERFACES] JDBC/Netscape/PostgreSQL Problem |
Дата | |
Msg-id | 38B15DD7.6B923BD0@lehmann.cc обсуждение исходный текст |
Ответ на | JDBC/Netscape/PostgreSQL Problem ("Allan Huffman" <huffmana@ppc.pims.org>) |
Список | 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 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. > 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.
В списке pgsql-interfaces по дате отправления: