Обсуждение: JDBC JAR Problem
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
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