Re: "blobSendChunkSize" property does not work
Posted by: Mark Matthews
Date: October 15, 2012 06:05PM

John,

There are other things at play here. The description for blobSendChunkSize states: "Chunk to use when sending BLOB/CLOBs via ServerPreparedStatements", server prepared statements are not enabled by default in the JDBC driver for various legacy reasons too long to go into here.

If you want to enable them so that you can use this parameter, you add "useServerPrepStmts=true" to enable them globally for the connection, or you can use them on a case-by-case basis by casting your connection to a com.mysql.jdbc.Connection and calling serverPrepareStatement(...) instead of prepareStatement(...), which will cause that call, and only that call to use a server-side prepared statement.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Written By
Posted
Re: "blobSendChunkSize" property does not work
October 15, 2012 06:05PM


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.