--- In Firebird-Java@yahoogroups.com, "docmaruko <marcopar@i...>"
<marcopar@i...> wrote:

> I'm migrating from interclient 2.01 to JayBird 1.0.0RC2.

Thanks to your help i think i've almost done with migration. I want to
share my experience in order to help future users. I know that the
current version in cvs will change the things a bit but here are some
notes i've made during the migration process.

Version of JayBird used 1.0.0RC2

problems regarding stored procedures:

1) call like 'EXECUTE "someProcedure" ... '
you should use CallableStatement in this way:

CallableStatement cs = conn.prepareCall(query);
cs.execute();
rs = cs.getResultSet();

2) call like 'SELECT "bla" FROM "someProcedure"
you should use PreparedStatement in this way:

PreparedStatement ps = conn.prepareCall(query);
rs = ps.executeQuery();

mixing the two things does not work, for example:

PreparedStatement ps = conn.prepareCall(query);
ps.execute();
rs = ps.getResultSet();

won't work. The same for:

CallableStatement cs = conn.prepareCall(query);
rs = cs.executeQuery();

ciao