hi, i've just installed recently installed an rpm version of postgresql (postgresql-server-7.0.2-6mdk.i586.rpm) and it's client.
I've added just 1 user
with the
unix_shell>createuser -P apprentice
and a database with
unix_shell>createdb -U apprentice papers
i created a few tables and was able to check them out using this command
unix_shell>psql papers apprentice
now i need to write a small java program that can connect to the database and retreive some information
but the jdbc driver i have (jdbc7.0-1.2.jar) keeps throwing this exception when i try to connect with this URL
Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: FA
TAL 1: Database "papers" does not exist in the system catalog.
hmm, i'm sure the database and the tables all exist.... can anybody tell me what i'm doing wrong?