CLOB fields on CMP 2.0 - JBoss 3.0 RC!

jhvaranda May 13, 2002 5:44 PM

Hello,

I'm currently using jboss 3.0 RC1 and I'd like to know how to implement cmp fields that supports CLOB jdbc/sql types. I've saw on standardjbosscmp-jdbc.xml that there is not a mapping for CLOB/BLOB types.

I have an Entity that has a XML file in a cmp field. I want to persist these field in a clob type column in an Oracle DB because these field may be greater than 255 characters.

Does Jboss 3.0 support these feature? How to use this? If not what's the preferred aproach? Use BMP?

Thanks in advance!

JH

1. Re: CLOB fields on CMP 2.0 - JBoss 3.0 RC!

russelp Jun 26, 2002 1:06 PM (in response to jhvaranda)

Hate doing this, but 'me too'. I'm going to take a look at the source tomorrow, but if Dain or someone else that knows CMP2.x in JBoss 3 could take a look it would help a lot.

Thanks,

Paul
Actions
2. Re: CLOB fields on CMP 2.0 - JBoss 3.0 RC!

dsundstrom Jun 26, 2002 2:33 PM (in response to jhvaranda)

As long a you are not using Oracle, it will work. If you are using Oracle you can't have a CLOB > 2000 characters, because Oracle's JDBC drivers are broken/non-complient (even though they are certified). For normal databases just changed the jdbc-type to CLOB and sql-type to what every your database needs to create a CLOB column in a CREATE TABLE statement.
Actions

Go to original post