From: mall <listkeeper23@hotmail.com>
To: pgsql-list <pgsql-interfaces@postgresql.org>
Subject: Connection problems
Date: Wed, 10 Jan 2001 12:32:00 -0800
Message-ID: <000d01c07b44$627bd890$3b2d8484@slurm> (raw)
Hi i've posted this message before but i'm adding new information to it. Hopefully some of the JDBC driver developers
can help me figure out what is going wrong.
previous message :
"
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?
"
All users and Databases, tables were created using lower case letters. I've tried connecting to other databases with other
user names but get the same exception. Both postmaster and my java program are running on the same machine. I'm using
JDK 1.3.0 from www.blackdown.org with Mandrake 7.2. I've also tried jdbc7.0-1.1.jar but i get the same exception ... why would
it report that the DB doesn't exist in the catalog when i can access it from psql???? Even the database "postgres" Doesn't exist
as far as the JDBC driver is concerned.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: listkeeper23@hotmail.com
Subject: Re: Connection problems
In-Reply-To: <000d01c07b44$627bd890$3b2d8484@slurm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox