[JBPAPP-7709] JDBCCacheLoader doesn't work with Oracle - JBoss Issue Tracker

XML

Word

Printable

Details

Type: Sub-task
Status: Closed (View Workflow)
Priority: Major
Resolution: Done
Affects Version/s: EAP_EWP 5.1.2
Fix Version/s: EAP_EWP 5.2.0
Component/s: Clustering
Labels:
None

Affects:

Release Notes
Release Notes Text:

Hide
Due to issues in the Oracle driver, the JDBCCacheLoader did not work with an Oracle database if the serialized form of the data exceeded a certain size (a couple of KB). The "cache.jdbc.node.useSetBlob" cache loader flag has been added to solve this problem: when the flag is set, JDBC uses a different JDBC call of the Oracle driver implementation and the JDBCCacheLoader works as expected with Oracle databases under these circumstances.

Show
Due to issues in the Oracle driver, the JDBCCacheLoader did not work with an Oracle database if the serialized form of the data exceeded a certain size (a couple of KB). The "cache.jdbc.node.useSetBlob" cache loader flag has been added to solve this problem: when the flag is set, JDBC uses a different JDBC call of the Oracle driver implementation and the JDBCCacheLoader works as expected with Oracle databases under these circumstances.
Release Notes Docs Status:
Documented as Resolved Issue
Docs QE Status:
NEW

Description

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

Gliffy Diagrams

Attachments

Issue Links

is blocked by

JBCACHE-1610 JDBCCacheLoader doesn't work with Oracle

Resolved

Activity

People

Assignee:

Dennis Reed

Reporter:

Dennis Reed

Writer:

Eva Kopalova

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Created:

09/Dec/11 6:16 PM

Updated:

18/Sep/12 10:11 AM

Resolved:

09/Dec/11 6:20 PM