From listkeeper23@hotmail.com Wed Jan  10 05:59:14 2001
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--




From listkeeper23@hotmail.com Wed Jan  10 20:32:40 2001
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--




From listkeeper23@hotmail.com Thu Jan  11 00:11:43 2001
Received: from hotmail.com (f111.law12.hotmail.com [64.4.19.111])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0B0BhB73190
	for <pgsql-interfaces@postgresql.org>;
	Wed, 10 Jan 2001 19:11:43 -0500 (EST)
	(envelope-from listkeeper23@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Wed, 10 Jan 2001 16:11:40 -0800
Received: from 63.204.74.148 by lw12fd.law12.hotmail.msn.com with HTTP;
	Thu, 11 Jan 2001 00:11:40 GMT
X-Originating-IP: [63.204.74.148]
From: "fud fudmore" <listkeeper23@hotmail.com>
To: Paul-AndrePanon@SierraSystems.com
Cc: pgsql-interfaces@postgresql.org
Subject: RE: Connection problems
Date: Thu, 11 Jan 2001 00:11:40 -0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F1113SOlbpH71yEXUIE000000e8@hotmail.com>
X-OriginalArrivalTime: 11 Jan 2001 00:11:40.0457 (UTC)
	FILETIME=[12408190:01C07B63]
X-Archive-Number: 200101/96
X-Sequence-Number: 705




>From: "Panon, Paul-Andre" <Paul-AndrePanon@SierraSystems.com>
>To: 'mall' <listkeeper23@hotmail.com>
>Subject: RE: [INTERFACES] Connection problems
>Date: Wed, 10 Jan 2001 14:01:01 -0800
>
>If you installed the Mandrake rpm for postgres, I believe that by default 
>it
>only accepts connections over UNIX pipes, not TCP/IP. You need the latter 
>to
>support jdbc.
>
>To check whether the postmaster backend accept connections over TCP/IP, try
>connecting to it with the command
>psql -p 5432 papers apprentice
>
>If you get a connection error on the above command, you need to modify the
>startup script for postgres. edit /etc/rc.d/init.d and add the -i flag to
>the postmaster command.
>
>P-A
>
>-----Original Message-----
>From: mall [mailto:listkeeper23@hotmail.com]
>Sent: Wednesday, January 10, 2001 12:32 PM
>To: pgsql-list
>Subject: [INTERFACES] Connection problems
>
>
>
>
>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 <http://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.
>

  I did fix the /etc/rc.d/init.d/postgres script to include the -i
parameter to start postgres. After that i was able to connect by
using this commandline.

unix_shell>psql -p 5432 papers apprentice

but when i ran my program again it threw the same exception ... I'm abit
confused at this point. if the jdbc driver was using port 5432 as the 
default port to connect to then why didn't it throw an exception about not 
finding a socket before i added the " -i" option.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com




From listkeeper23@hotmail.com Thu Jan  11 05:09:40 2001
Received: from hotmail.com (f193.law12.hotmail.com [64.4.19.193])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0B59eB97400
	for <pgsql-interfaces@postgresql.org>;
	Thu, 11 Jan 2001 00:09:40 -0500 (EST)
	(envelope-from listkeeper23@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Wed, 10 Jan 2001 21:09:35 -0800
Received: from 63.204.74.148 by lw12fd.law12.hotmail.msn.com with HTTP;
	Thu, 11 Jan 2001 05:09:35 GMT
X-Originating-IP: [63.204.74.148]
From: "fud fudmore" <listkeeper23@hotmail.com>
To: pgsql-interfaces@postgresql.org
Subject: RE: Connection problems
Date: Thu, 11 Jan 2001 05:09:35 -0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F193Vn20lbhsKd6QR7j00007d12@hotmail.com>
X-OriginalArrivalTime: 11 Jan 2001 05:09:35.0957 (UTC)
	FILETIME=[B0E15850:01C07B8C]
X-Archive-Number: 200101/101
X-Sequence-Number: 710


Sorry everybody but i just figured out what my lame butt has done wrong.
after reading the postgresql manual further i discovered the tracing 
features of the db server so i decided to add this entry to pg_options

all=1
verbose=2
query=0
syslog=2

and i found this ...

Jan 10 13:02:06 darktower postgres[3891]: InitPostgres
Jan 10 13:02:06 darktower postgres[3891]: FATAL 1:  Database "papers " does 
not exist in the system catalog.
Jan 10 13:02:06 darktower postgres[3891]: proc_exit(0)
Jan 10 13:02:06 darktower postgres[3891]: shmem_exit(0)
Jan 10 13:02:06 darktower postgres[3891]: exit(0)


"papers " DUH! somewhere in the program a blank space had gotten
in. i fixed it and it works perfectly. Thanks to everybody that replied
to my request for help.

>From: "fud fudmore" <listkeeper23@hotmail.com>
>To: Paul-AndrePanon@SierraSystems.com
>CC: pgsql-interfaces@postgresql.org
>Subject: RE: Connection problems
>Date: Thu, 11 Jan 2001 00:11:40 -0000
>
>
>
>
>>From: "Panon, Paul-Andre" <Paul-AndrePanon@SierraSystems.com>
>>To: 'mall' <listkeeper23@hotmail.com>
>>Subject: RE: [INTERFACES] Connection problems
>>Date: Wed, 10 Jan 2001 14:01:01 -0800
>>
>>If you installed the Mandrake rpm for postgres, I believe that by default
>>it
>>only accepts connections over UNIX pipes, not TCP/IP. You need the latter
>>to
>>support jdbc.
>>
>>To check whether the postmaster backend accept connections over TCP/IP, 
>>try
>>connecting to it with the command
>>psql -p 5432 papers apprentice
>>
>>If you get a connection error on the above command, you need to modify the
>>startup script for postgres. edit /etc/rc.d/init.d and add the -i flag to
>>the postmaster command.
>>
>>P-A
>>
>>-----Original Message-----
>>From: mall [mailto:listkeeper23@hotmail.com]
>>Sent: Wednesday, January 10, 2001 12:32 PM
>>To: pgsql-list
>>Subject: [INTERFACES] Connection problems
>>
>>
>>
>>
>>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 <http://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.
>>
>
>  I did fix the /etc/rc.d/init.d/postgres script to include the -i
>parameter to start postgres. After that i was able to connect by
>using this commandline.
>
>unix_shell>psql -p 5432 papers apprentice
>
>but when i ran my program again it threw the same exception ... I'm abit
>confused at this point. if the jdbc driver was using port 5432 as the
>default port to connect to then why didn't it throw an exception about not
>finding a socket before i added the " -i" option.
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com