On Fri, 23 Jun 2006, Mark Lewis wrote:
> As far as I can tell from reading the JDBC CVS code, the sequence for
> preparing and executing a statement for the first time is:
>
> PREPARE (name=my_statement)
> DESCRIBE STATEMENT (name=my_statement)
> SYNC/FLUSH
> Read Responses
>
> BIND (portal=my_portal)
> DESCRIBE PORTAL (name=my_portal)
> EXECUTE (portal=my_portal)
> SYNC/FLUSH
> Read Responses
>
Nope. There is no Sync in the middle there. The driver sends Parse,
Describe Statement, Bind, Execute, Sync all at once. You may be confused
by the driver's ability to Parse/Describe/Sync a query to implement
ParameterMetaData, but that's an unusual operation, not the normal path.
Kris Jurka