Subject executing stored procedure with driver 1.5
Author Marco Parmeggiani
Hi guys, sorry i i ask a FAQ but i've ignored the driver development
during last months as my code "actually works" and so there was no need
to pay attention to the latest development. Now, i'm in a bit of trouble
as i am trying to switch to the 1.5 driver a piece of code that works
perfectly with 1.0... but i need to do that. I'm using driver 1.5.5
against a 1.5.2 Firebird server.

this is the snippet:

String query = "SELECT * FROM \"proc_listaOrganizzatori\"";
try {
PreparedStatement cs = dbconn.getConn().prepareCall(query);
rs = cs.executeQuery();
while(rs.next()) {
Organizzatore o = Organizzatore.getOrganizzatore(rs);
if(o != null) v.add(o);
}
rs.close();
cs.close();
} catch (SQLException ex) {
dbconn.showSQLException(ex);
ex.printStackTrace();
return null;
}


and this is the error:

GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 19
SELECT
Error Code: 335544569
SQL State: HY000
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic
SQL Error
SQL error code = -104
Token unknown - line 1, char 19
SELECT



thanks,
ciao