Oracle BLOB > 4000 bytes 2.4.5

[knorki]

HI

I want to store some byteArrays[] with cmp beans to the database. But as soon as i insert arrays > 4000 bytes i get a heuristic rollback exception.

I know that there where former posts about this issue, but i did not find a solution to this .. :-(

I am using oracle 8 and jboss 2.4.6

jaws mapping:
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>



get & set methods
-> public Object sectionTemplate
is (Object)ByteArray[]

public Object getSectionTemplate()
{

return this.sectionTemplate;

}

public void setSectionTemplate(Object SectionTemplate)
{

this.sectionTemplate = SectionTemplate;

}

Is there a workaround or something?? Or a possible change of the standartjwas mapping??

THANKS FOR HELP

[chappers]

There's a patch at http://sourceforge.net/tracker/index.php?func=detail&aid=525663&group_id=22866&atid=376687

For a quick fix you could change the data type of your blob column to long raw.

[knorki]

THHAANNKS

changing the data type to LONG RAW solved the problem for now.

:-)