You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Daniel Scheibe (Updated) (JIRA)" <ji...@apache.org> on 2012/02/07 10:31:59 UTC
[jira] [Updated] (CAY-1664) Integrate support for streaming data
types as extension to byte[] buffers into Cayenne
[ https://issues.apache.org/jira/browse/CAY-1664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Scheibe updated CAY-1664:
--------------------------------
Description:
Whenever BLOB data is accessed it has to happen through byte[] buffers at the moment. It would be great to gain the advantage of using streams to store BLOB data to the underlying database. The JDBC API supports streaming data types and certain JDBC Drivers implement it in a proper way already. Another benefit would be to handle binary and object data together inside a real transaction.
Comments:
- MYSQL doesn't support this right know (see max_packet_size limit and the JDBC Driver simply reads the whole stream data into a ByteBufferStream before transfer so theres no advantage)
- Microsoft SQL Server 2008 offers a FileStream data type which allows to handle large binary data via the Database Server so this would be a great benefit)
was:
Whenever BLOB data is accessed it has to happen through byte[] buffers at the moment. It would be great to gain the advantage of using streams to store BLOB data to the underlying database. The JDBC API supports streaming data types and certain JDBC Drivers implement it in a proper way already. Another benefit would be to handle binary and object data together inside a real transaction.
Comments:
- MYSQL doesn't support this right know (see max_packet_size limit and the JDBC Driver simply reads the whole stream data into a ByteBufferStream before transfer so theres no advantage)
- Microsoft SQL Server 2080 offers a FileStream data type which allows to handle large binary data via the Database Server so this would be a great benefit)
> Integrate support for streaming data types as extension to byte[] buffers into Cayenne
> --------------------------------------------------------------------------------------
>
> Key: CAY-1664
> URL: https://issues.apache.org/jira/browse/CAY-1664
> Project: Cayenne
> Issue Type: Improvement
> Components: Database integration
> Affects Versions: Short term future
> Reporter: Daniel Scheibe
> Priority: Minor
> Fix For: Undefined future
>
>
> Whenever BLOB data is accessed it has to happen through byte[] buffers at the moment. It would be great to gain the advantage of using streams to store BLOB data to the underlying database. The JDBC API supports streaming data types and certain JDBC Drivers implement it in a proper way already. Another benefit would be to handle binary and object data together inside a real transaction.
> Comments:
> - MYSQL doesn't support this right know (see max_packet_size limit and the JDBC Driver simply reads the whole stream data into a ByteBufferStream before transfer so theres no advantage)
> - Microsoft SQL Server 2008 offers a FileStream data type which allows to handle large binary data via the Database Server so this would be a great benefit)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira