[jbosscache-issues] [JBoss JIRA] (JBCACHE-1610) JDBCCacheLoader doesn't work with Oracle

[Dennis Reed (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/JBCACHE-1610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12649699#comment-12649699 ] 

Dennis Reed commented on JBCACHE-1610:
--------------------------------------

Resolved by adding a new cache loader flag "cache.jdbc.node.useSetBlob" that uses PreparedStatement.setBlob instead of PreparedStatement.setBinaryStream, to work around issues with the Oracle setBinaryStream implementation and large obects.

                
> JDBCCacheLoader doesn't work with Oracle
> ----------------------------------------
>
>                 Key: JBCACHE-1610
>                 URL: https://issues.jboss.org/browse/JBCACHE-1610
>             Project: JBoss Cache
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Cache loaders
>    Affects Versions: 3.2.8.GA
>            Reporter: Dennis Reed
>            Assignee: Dennis Reed
>         Attachments: test.war
>
>
> The Oracle driver throws the exception "java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column"
> when the cacheloader tries to save more than a couple KB of data

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira