[ http://issues.apache.org/jira/browse/IBATIS-62?page=comments#action_58092 ] Clinton Begin commented on IBATIS-62: -------------------------------------
1) Your JDBC driver may not support the native JDBC API for LOBs. Oracle drivers previous to 10g fell into this category. 2) Your driver may have additional configuration for maximum data sizes. MySQL drivers are in this category. 3) Your driver may require interaction using streams exclusively. I believe a number of drivers are like this, but I'm not sure which ones. iBATIS currently doesn't access blobs using streams, but will in the next release. In the event of any of the above, you can always implement your own typehandler. You can use the BLOB and CLOB type handler source code that is included with the distribution as examples (see the src ZIP file in the /debug folder). > BLOB Handling in IBATIS 2.0.9 > ----------------------------- > > Key: IBATIS-62 > URL: http://issues.apache.org/jira/browse/IBATIS-62 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.0.9 > Reporter: Martin Dawe > Priority: Critical > > We are currently trying to utilise the new BLOB handling features of IBATIS > 2.0.9. We have managed to pull back a BLOB from ORACLE as a byte[], but we're > only pulling back 86bytes (as mentioned in a previous post by another member) > of data for large .pdf documents. > It is unclear from previous posts whether this feature actually works > entirely, but it would be greatly appreciated if we could have some example > implementation of the BLOB handling in IBATIS. > Thanks -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira