Skip site navigation (1) Skip section navigation (2)

newbie question: loading the jdbc driver & connecting to my db

From: Russ McBride <Russ(at)psyex(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: newbie question: loading the jdbc driver & connecting to my db
Date: 2001-09-17 07:49:31
Message-ID: v04210103b7cb575ebde4@[64.170.121.45] (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-jdbc
I can't seem to make a connection to my postgresql database from 
WebObject's EOModeler.  I'd like to rule out the possibility that the 
driver did not load properly.  If I type

java -Djdbc.drivers=org.postgresql.Driver example.ImageViewer

and I get the following text, then that means that my driver loaded 
properly, correct?

. . . This example tests the large object api of the example. . . .



If the driver loaded properly, and assuming that I started postmaster 
with the -i option for tcp/ip connections, which I did, then as I see 
it there are probably only two remaining reasons why I can't make a 
connection:  either the driver is not in the classpath (it is), or 
I'm not typing in the url correctly.  I've tried these three 
variations (the text below is *exactly* what I type; my database is 
called 'testdb'):

jdbc:postgresql:testdb
jdbc:postgresql://localhost/testdb
jdbc:postgresql://host:5432/testdb


My connection window gives me the option of specifying the name of my 
driver.  When I type in

postgresql.jar

then I get an error message saying that it couldn't find 
postgresql.jar in the classpath and that I should check the 
classpath.  But in that same error window displayed in the classpath 
list is the path to postgresql.jar


Any tips. Thanks in advance.

Russ

ps  I'm running mac os 10.0.4 (Darwin), postgresql 7.1.2, and 
WebObjects 5.0 (just the EOModeler so far)

Responses

pgsql-jdbc by date

Next:From: Vianen, Jeroen vanDate: 2001-09-17 07:59:07
Subject: Re: Fix for broken JDBC's getColumn() (take 2)
Previous:From: Barry LindDate: 2001-09-17 04:45:16
Subject: Re: UpdateableResultSet patch (not finished yet!)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group