0 Replies Latest reply on Jan 8, 2003 7:15 PM by shankar

    Oracle and LongVarchar

    shankar Newbie

      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