Re: ClientPreparedQueryBindings setInt method convert int directly to byte array

[Filipe Silva]

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.