Re: Blobs and SQL Locator

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jonathan Baxter wrote:
> Are there any plans for a complete implementation of Blob in the 
> Connector/J package? Specifically, getBytes and setBytes?
> 
> I could find no reference to any plans for SQL Locators on the MySQL 
> web-site, without which we're not likely to get the full Blob either. 
> 
> Cheers,
> 
> Jonathan 
> 
> 

Until the server itself supports locators, setBytes() can't be 
implemented efficiently. It is possible for Connector/J to implement 
this, if there is enough interest (I can put it on my feature list for 
3.1). However, you'll still have to pass the Blob instance back into an 
updatable result set, or a PreparedStatement to persist it. This is 
still JDBC-compliant, as DatabaseMetaData returns true for 
locatorsUpdateCopy().

	-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+SGqjlyjUJM+7nP4RAuH6AJ9EfDVPfEBR6I6qnr0tsRlut+qLagCfcvwS
rC0JuA1zBz4NsyIArutxMUw=
=35Dz
-----END PGP SIGNATURE-----