Re: Blob streamability
Mark Matthews <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ruben Malchow wrote: > > hello list, > > i stumbled across the comments in /com/mysql/jdbc/Blob.java and it > confirmed my suspicions: it really is nothing but a byte array > containing all the data of the blob. so basically, the streaming from > and into the db are still limited by the available memory ... which is > not really the point of a blob. > > is there any information as to when streaming is going to be real, and > when this implementation of java.sql.Blob will actually provide methods > that can modify a blob without loading all it's data into memory first? > the comments are a bit vague about this ... and it would really be a > great improvement! > > .rm > Ruben, The issue is that the problem is not solvable in the client. There needs to be server-side functionality added (LOBs in particular) as well as the streaming of reads of blobs (you can already stream data in server-side prepared statements _to_ the server, and the driver already does this). As far as I know, this functionality is not on the development roadmap for the server. -Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFE4IyKtvXNTca6JD8RAg7ZAKCenZLUPNZQGBVMMYeov/Q2GZGD1QCggEwM 57+SuiSo9oKkoGbOyb4QpMw= =cZ3c -----END PGP SIGNATURE----- -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]