Storing CLOB

[alice]

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!!

[dsundstrom]

You can only have it one way.

[dsundstrom]

I forgot. You are using Oracle 8. Because the Oracle drivers are not complient you will be unable to store strings longer then 2000 characters.