There is a method called setSelectableProcedure(boolean f) in
org.firebirdsql.jdbc.FBCallableStatement

Is there any other way to set callable statments selectable?
E.g. some System.property to set or perhaps some connection property
that makes CallableStatements selectable
by default as you create them?



The reason I ask is that many other databases use procedures that
commonly returns multirow resultsets.
It would be easier to write multi dbplatform code if you hadn't have to
resort to ugly things like this:

if(statement.getClass().getName().equals("org.firebirdsql.jdbc.FBCallableStatement")){
Class paramTypes[]={boolean.class};
Method
m=st.getClass().getMethod("setSelectableProcedure",paramTypes);
Object paramValues[]={Boolean.TRUE};
m.invoke(st,paramValues);
}


Regards
Uno Engborg


[Non-text portions of this message have been removed]