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