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 2080 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

        

Reply via email to