Hi,
I'm using LongVarchar for one of my CMP fields.
here is my configuration
Jboss 3.0.3
DB - Oracle8
Oracle9 Client OCI driver
Tables not created using Jboss
When i try to insert a record in Oracle, the longvarchar field value gets chopped at a arbitary location. The same thing works fine with MYSQL. Since java.lang.String maps to JDBC types VARCHAR AND LONGVARCHAR, i'm using java.lang.String as the datatype for the LONGVARCHAR CMP field. Have also tried adding a mapping for LONGVARCHAR in standardjboss template under Oracle8
<java-type>java.lang.String</java-type>
<jdbc-type>LONGVARCHAR</jdbc-type>
<sql-type>LONG</sql-type>
if you have any ideas, pls let me know.
Thanks
shankar