Hi Marco,

I write something up for the FAQ concerning this to try to help out new
users.

Rick

----- Original Message -----

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