Обсуждение: JDBC JAR Problem

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>
>

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