[
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
