RE: Connection problems

>From: "Panon, Paul-Andre" <Paul-AndrePanon(at)SierraSystems(dot)com>
>To: 'mall' <listkeeper23(at)hotmail(dot)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(at)hotmail(dot)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