Does rewriteBatchedStatements rewrite into prepared statements or regular ones?
Posted by: Juan Antonio Farré Basurte
Date: September 01, 2011 01:48PM

Hi!
I'm working with mysql and java and use rewriteBatchedStatements in some cases.
My question is, when a batched statement is rewritten, does the connector use a new client-side prepared statement for the new statement generated from the batch? Or this new statement just has all the info inside it (instead of using placeholders for params) and is directly executed without preparing it?
If it's a prepared statement, then I have two doubts:
- Does it use ? placeholders for params or it inlines data?
- Is this prepared statement cacheable? Will it be cached if cachePrepStmts=true?
Thanks!

Juan

Options: ReplyQuote


Subject
Written By
Posted
Does rewriteBatchedStatements rewrite into prepared statements or regular ones?
September 01, 2011 01:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.