[CAY-1664] Integrate support for streaming data types as extension to byte[] buffers into Cayenne

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Fix Version/s: Undefined future
• Component/s: Database integration
• Assignee: Unassigned
• Reporter: Daniel Scheibe
• Created: 07/Feb/12 09:27
• Updated: 07/Feb/12 09:30

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)