calling function with String resolves as "Unknown" instead of varchar

From: todd runstein <todd_run(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: calling function with String resolves as "Unknown" instead of varchar
Date: 2004-05-03 21:56:50
Message-ID: 20040503215650.7289.qmail@web13704.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm calling a function with the following signature:

create or replace function
usp_affectedproduct(integer, integer, varchar) RETURNS
int as ...

I'm calling the function with something similar to:

String query = "{? = call usp_affectedproducts(?, ?,
?)}";
Connection conn = null; CallableStatement s = null;
try {
conn = getConnection(datasource);
s = conn.prepareCall(query);
s.registerOutParameter(1,Types.INTEGER);
s.setInt(2,qualityid);
s.setInt(3,submitid);
s.setString(4,products[x].getName());
s.execute();
} catch (SQLException e) {
throw e;
}finally{
<clean up stuff ...>

When I run this, I get an SQLException stating:

function usp_affectedproducts(integer, integer,
"unknown") does not exist

I've also try s.setObject(4, aString, Types.VARCHAR),
also to no avail. I've tried using a
PreparedStatement instead of the CallableStatement -
again, without success.

Any ideas? I'm running 7.4.1 on RedHat 8.0 with JDK
1.4.1_01.

Thanks in advance

=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________

Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________



__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-05-03 22:34:46 Re: calling function with String resolves as "Unknown" instead
Previous Message Ang Kwang Chian 2004-05-03 01:56:20 PGSQL-JDBC DRIVER DOWNLOAD (POSTGRESQL)