Subject | Stored Procedure Caching in FB 2 |
---|---|
Author | Guido Klapperich |
Post date | 2007-07-17T13:40:38Z |
In the past with Firebird 1.5 I have done developing stored procedures
quite often like this:
- connect with my client app to the database
- change and compile the sp
- run the sp from the client, check the results and commit transaction
As I said, this worked fine with FB 1.5.
Now I have switched to FB 2.01 and I always have to reconnect to the
database with my client app to see the changes to the sp, after I have
compiled it. When I switch back to FB 1.5, all works fine again.
Now my question: Has FB 2 some kind of caching, so that my client has to
reconnect to see the changes done to the sp?
Regards
Guido
quite often like this:
- connect with my client app to the database
- change and compile the sp
- run the sp from the client, check the results and commit transaction
As I said, this worked fine with FB 1.5.
Now I have switched to FB 2.01 and I always have to reconnect to the
database with my client app to see the changes to the sp, after I have
compiled it. When I switch back to FB 1.5, all works fine again.
Now my question: Has FB 2 some kind of caching, so that my client has to
reconnect to see the changes done to the sp?
Regards
Guido