EJB's and Oracle Long Raw Fields

[magic]

Hi all!

I am using Oracle 8.1.7 and JBoss 3.0.2. My Task is to write an String in a Oracle Longraw-Field. I am using EJB's to manage Databasethings. The Beans were created by the Oracle JDeveloper. I got 2 Methods for the Longraw-Field void setItem(String item) and String getItem(). Now my Problem...i want to write a String into the Databasefield with the setItem-Method from the EJB. But when i do that i got an Error Message from the JBOSS or the JDBC Driver ORA-01465 Illegal Hexcount.............

[scoy]

You need:

<cmp-field>
<field-name>myFieldName</field-name>
<column-name>myColumnName</column-name>
<jdbc-type>LONGVARCHAR</jdbc-type>
<sql-type>LONG</sql-type>
</cmp-field>

in your jbosscmp-jdbc.xml file.

Also, you must use the OCI JDBC drivers if you expect this to work with more than about 4k of text.