Most stuff works OK after changing the driver and database URL strings.
Most people find hat migration is pretty painless.

The big advantage is that JayBird is supported and no one is currently
supporting the open source version of Interclient.

Rick

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

> I'm migrating from interclient 2.01 to JayBird 1.0.0RC2.
> Before doing massive code changings i have a question:
>
> i use a lot of stored procedures primarly in two forms:
> 1) EXECUTE PROCEDURE "xxx" (a, b) (for single row sp)
> 2) SELECT "a","b","c" FROM "xxx" (for multiple rows sp)
>
> All these calls are now made through a CallableStatement that worked
> fine with interclient.
> With JayBird i get, with type 2 calls, these errors:
> - multiple rows in singleton select
> - attempt to fetch past the last record in a record stream
>
> Reading the FAQ i found that the correct way to handle type 2 calls is
> to use PreparedStatement.
>
> Should i pay attention to other details or can i just convert
> CallableStatement in PreparedStatement and then live happy?
>
> Thanks in advance
> ciao