2 Replies Latest reply on Aug 13, 2003 9:09 AM by Stefan Heckler

    type mapping for oracle8i

    Stefan Heckler Novice

      The default mapping for String in EJB is VARCHAR(255):


      <java-type>java.lang.String</java-type>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR2(255)</sql-type>


      I would like to have an other String type mapped to VARCHAR(4000) and tried the following:


      <java-type>java.lang.StringBuffer</java-type>
      <jdbc-type>LONGVARCHAR</jdbc-type>
      <sql-type>VARCHAR2(4000)</sql-type>


      This works for update, but not for getting the data from the database :
      java.sql.SQLException: Got a java.lang.String[cl=0, value=Es ist was passiert] while looking for a java.lang.StringBuffer[cl=16671929]

      What would be the correct mapping?

      Stefan