Received: from mta2.snfc21.pbi.net (mta2.snfc21.pbi.net [206.13.28.123])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0AKWeB58626
	for <pgsql-interfaces@postgresql.org>;
	Wed, 10 Jan 2001 15:32:40 -0500 (EST)
	(envelope-from listkeeper23@hotmail.com)
Received: from slurm ([63.204.72.17])
	by mta2.snfc21.pbi.net (Sun Internet Mail Server
	sims.3.5.2000.01.05.12.18.p9)
	with SMTP id <0G6Y00L58RF8L5@mta2.snfc21.pbi.net> for
	pgsql-interfaces@postgresql.org; Wed, 10 Jan 2001 12:25:56 -0800 (PST)
Date: Wed, 10 Jan 2001 12:32:00 -0800
From: mall <listkeeper23@hotmail.com>
Subject: Connection problems
To: pgsql-list <pgsql-interfaces@postgresql.org>
Message-id: <000d01c07b44$627bd890$3b2d8484@slurm>
MIME-version: 1.0
X-Mailer: Microsoft Outlook Express 5.00.3018.1300
Content-type: multipart/alternative;
	boundary="----=_NextPart_000_000A_01C07B01.542C3160"
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
X-Priority: 3
X-Archive-Number: 200101/93
X-Sequence-Number: 702

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C07B01.542C3160
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Hi i've posted this message before but i'm adding new information to it. Ho=
pefully some of the JDBC driver developers=20
can help me figure out what is going wrong.


previous message :

"
hi, i've just installed recently installed an rpm version of postgresql (po=
stgresql-server-7.0.2-6mdk.i586.rpm) and it's client.
I've added just 1 user

with the=20
=20
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 a=
nd 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 th=
is 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 m=
e what i'm doing wrong?=20
"

All  users and Databases, tables were created using lower case letters. I'v=
e 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 fro=
m psql???? Even the database "postgres" Doesn't exist
as far as the JDBC driver is concerned.=20


------=_NextPart_000_000A_01C07B01.542C3160
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3019.2500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#d8d0c8>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Hi i've posted this message before but i'm=
 adding=20
new information to it. Hopefully some of the JDBC driver developers=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>can help me figure out what is going=20
wrong.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>previous message :</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>hi, i've just installed recently installed=
 an rpm=20
version of postgresql (postgresql-server-7.0.2-6mdk.i586.rpm) and it's=20
client.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I've added just 1 user</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>with the </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>unix_shell&gt;createuser -P apprentice</FO=
NT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>and a database with</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>unix_shell&gt;createdb -U=20
apprentice&nbsp;papers</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>i created a few tables and was able to check them out using this=20
command</DIV>
<DIV>&nbsp;</DIV>
<DIV>unix_shell&gt;psql papers apprentice</DIV>
<DIV>&nbsp;</DIV>
<DIV>now i need to write a small java program that can connect to the datab=
ase=20
and retreive some information</DIV>
<DIV>but the jdbc driver i have (jdbc7.0-1.2.jar) keeps throwing this excep=
tion=20
when i try to connect with this URL</DIV>
<DIV><FONT size=3D2>
<P>(jdbc:postgresql:papers)</P></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>Something unusual has occured to cause the driver to fail. Please repo=
rt=20
this exception: java.sql.SQLException: FA<BR>TAL 1:&nbsp; Database "papers"=
 does=20
not exist in the system catalog.</DIV>
<DIV>&nbsp;</DIV>
<DIV>hmm, i'm sure the database and the tables all exist....&nbsp; can anyb=
ody=20
tell me what i'm doing wrong? </DIV>
<DIV>"</DIV>
<DIV>&nbsp;</DIV>
<DIV>All&nbsp; users and Databases, tables were created using lower case=20
letters. I've tried connecting to other databases with other</DIV>
<DIV>user names but get the same exception. Both postmaster and my java pro=
gram=20
are running on the same machine. I'm using</DIV>
<DIV>JDK 1.3.0 from <A href=3D"http://www.blackdown.org">www.blackdown.org<=
/A>=20
with Mandrake 7.2. I've also tried jdbc7.0-1.1.jar but i get the same excep=
tion=20
... why would</DIV>
<DIV>it report that the DB&nbsp;doesn't exist in the catalog when i can acc=
ess=20
it from psql???? Even the database "postgres" Doesn't exist</DIV>
<DIV>as far as the JDBC driver is concerned. </DIV>
<DIV>&nbsp;</DIV></FONT></DIV></FONT></DIV></BODY></HTML>

------=_NextPart_000_000A_01C07B01.542C3160--