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 f0A5xEB86297
	for <pgsql-interfaces@postgresql.org>;
	Wed, 10 Jan 2001 00:59:14 -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 <0G6X002TDMZJ8Z@mta2.snfc21.pbi.net> for
	pgsql-interfaces@postgresql.org; Tue,  9 Jan 2001 21:52:31 -0800 (PST)
Date: Tue, 09 Jan 2001 21:58:34 -0800
From: mall <listkeeper23@hotmail.com>
Subject: connection problems
To: pgsql-list <pgsql-interfaces@postgresql.org>
Message-id: <000801c07aca$5e4ef830$3b2d8484@slurm>
MIME-version: 1.0
X-Mailer: Microsoft Outlook Express 5.00.3018.1300
Content-type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C07A87.4FF34310"
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
X-Priority: 3
X-Archive-Number: 200101/82
X-Sequence-Number: 691

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C07A87.4FF34310
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


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

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



------=_NextPart_000_0005_01C07A87.4FF34310
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><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>&nbsp;</DIV>
<DIV></FONT>&nbsp;</DIV></DIV></BODY></HTML>

------=_NextPart_000_0005_01C07A87.4FF34310--