PostgreSQL JDBC - JDBC JAR Problem

Author

JDBC JAR Problem

Rohit Ankushe

2005-07-27, 9:24 am

Hi,

I am using postgres 7.4.5 version database on th linux server and also I am using the postgres 7.4 jdbc 3 jar for the jdbc connection.

When I call my function which are written in postgres using the plpgsql , I got error that "Function does not exist".

I tried same thing using the postgres 8.0 jdbc3 jar but the porblem is not resolved .

Please solve my problem .

Thank you

Regards,
Rohit Ankushe(Software Engineer)
Codec Communication(Pvt.) Ltd.
Pune(India)
cell: +91 9326056605
Desk: +91 20 24221460/70 (Ext.43)
rohit.ankushe@codecindia.com
www.codecindia.com

Xavier Poinsard

2005-07-27, 9:24 am

Rohit Ankushe a écrit :
> Hi,
>
> I am using postgres 7.4.5 version database on th linux server and also I
> am using the postgres 7.4 jdbc 3 jar for the jdbc connection.
>
> When I call my function which are written in postgres using the plpgsql
> , I got error that "*Function does not exist*".

Could you provide the complete error message including stack trace and a
portion of your code ?

>
> I tried same thing using the postgres 8.0 jdbc3 jar but the porblem is
> not resolved .
>
> Please solve my problem .
>
> Thank you
>
>
> Regards,
> *Rohit Ankushe(Software Engineer)*
> Codec Communication(Pvt.) Ltd.
> Pune(India)
> cell: +91 9326056605
> Desk: +91 20 24221460/70 (Ext.43)
> rohit.ankushe@codecindia.com <mailto:rohit.ankushe@codecindia.com>
> ___www.codecindia.com_ <http://www.codecindia.com>
>

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Oliver Jowett

2005-07-27, 8:24 pm

Rohit Ankushe wrote:

> I am using postgres 7.4.5 version database on th linux server and also I
> am using the postgres 7.4 jdbc 3 jar for the jdbc connection.
>
> When I call my function which are written in postgres using the plpgsql
> , I got error that "*Function does not exist*".
>
> I tried same thing using the postgres 8.0 jdbc3 jar but the porblem is
> not resolved .
>
> Please solve my problem .

Please send the code you are executing and the exact exception that you
see. The most likely problems are either a typo in your query, or a
mismatch between the parameter types you're supplying and the parameter
types of the function.

-O

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links