Re: ClientPreparedQueryBindings setInt method convert int directly to byte array
Posted by: Filipe Silva
Date: December 16, 2021 10:51AM

Hi Chen,

You could use setBytes() but probably it wouldn't be any better.

The ClientPreparedQueryBindings does keep this internal byte[] representation for all parameters. This has be like so since the early days of the Connector when server prepared statements weren't supported, and this is something we are also trying to improve, I just can't say when or if it will ever be done.

It is more common, though, to use ServerPreparedQueryBindings which has been worked out differently. Client (emulated) prepared statements have been kept mostly as a fail-safe solution for when no more server prepared statements can be created.

I hope this clarifies it.

Options: ReplyQuote

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.