2 Replies Latest reply on Jun 30, 2002 3:16 PM by Dain Sundstrom

    Storing CLOB

    Alice Newbie

      How can I stor CLOB using jaws?

      For example, for Oracle 8 we have the following type mapping:

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


      Now I have void setComment(String comment) and String getComment() that can store very huge strings (thus requiring CLOB). Now if I change the jdbc-type & sql-type in type mapping to CLOB for java.lang.String java-type, it will unnecessarily store small Strings as CLOB where it should have stored them in VARCHAR2.

      Please advise.

      Thanks!!