Thread: jdbc connection

jdbc connection

From
"N. Khodabakhsh"
Date:
Hello,

I have downloaded the postgresql 8.2 and wanted to make a connection with it. i get error like unknown source.
i send u herewith the source code (see attach). can you help me to fixe it?

Thank you,
Nico Khodabakhsh
Attachment

Re: jdbc connection

From
Guy Rouillier
Date:
N. Khodabakhsh wrote:
> Hello,
>
> I have downloaded the postgresql 8.2 and wanted to make a connection
> with it. i get error like unknown source.
> i send u herewith the source code (see attach). can you help me to fixe it?

You're question is rather generic, and you didn't provide a useful error
message.  So helping is rather difficult.  What exact error are you
receiving?  Your code looks okay.  Since you are specifying "localhost",
is it safe to assume you are running this code on the same box running
PostgreSQL?  Have you verified using psql that you can connect to the
target database using the userid and password you have in this code?

--
Guy Rouillier

Re: jdbc connection

From
Mamoon Rashid
Date:
hi nico,
please check your URL supplied during connection.you have given
URL= "jdbc:postgresql://localhost:5432/postgres"
1.you are assuming your database name as "postgres", plz check this should
be the actual name of your database.
If i am correct u supplied USERID = "postgres" and PASSWD= "showan2000".it
seems ok.
2. Do one more thing, replace localhost with [::1].
if all other things are ok your problem probably lies in connection.
Plz report me whether it worked or not.

mamoon



> Hello,
>
> I have downloaded the postgresql 8.2 and wanted to make a connection with
> it. i get error like unknown source.
> i send u herewith the source code (see attach). can you help me to fixe
> it?
>
> Thank you,
> Nico Khodabakhsh
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate
>