Thread: connection problems

connection problems

From
mall
Date:
 
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

(jdbc:postgresql:papers)

 
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?