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

[Dennis Reed (JIRA)]

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

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

To run attached test case (which requires Oracle), do one of the following:
- configure DefaultDS to point to the Oracle instance
- configure an alternative datasource to point to the Oracle instance and modify the datasource name in WEB-INF/classes/cache.xml
- comment out the datasource name in WEB-INF/classes/cache.xml and configure the cache.jdbc parameters to point to Oracle

Deploy the war, and load http://$JBOSS_IP:8080/test
If the test succeeds, the page will not show any errors, and will say "SUCCESS".

                
> 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
>             Fix For: 3.2.9.GA
>
>         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