db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MikeRam <ing.ramu...@tiscali.it>
Subject Why exception exporting parametric query result on Derby ?
Date Sun, 27 Apr 2008 17:31:40 GMT

q="SELECT * FROM "+dbTable+" WHERE "+FieldName+" BETWEEN ? AND ? ORDER BY
ID";
q="CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY('"+q+"','"+OutFile+"', null, null,
null)";
stm=cn.conn.prepareCall(q);
stm.setString(1, sd.StringDataOraInizio);
stm.setString(2, sd.StringDataOraFine);
stm.execute();

I use Apache Derby but,
When i execute the attached code i receive an exception
java.sql.SQLException: No input parameters.

Parametric query are usable in stored procedure ?
as i see from ref guide:


-- 
View this message in context: http://www.nabble.com/Why-exception-exporting-parametric-query-result-on-Derby---tp16926173p16926173.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message