Re: "blobSendChunkSize" property does not work
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
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.