Subject | interclient migration |
---|---|
Author | docmaruko <marcopar@inwind.it> |
Post date | 2002-12-18T10:47:29Z |
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
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