No, I didn't modify my database. Here is I model class:
===============================================================
/**
* @return the moTa
*/
@Lob
@Basic(fetch = FetchType.LAZY)
@Column(name = "MO_TA")
public String getMoTa() {
return moTa;
}
/**
* @param moTa
* the moTa to set
*/
public void setMoTa(String moTa) {
this.moTa = moTa;
}
===============================================================
Then I run: mvn hibernate3:hbm2ddl to generate the schema to my database.
Here is my SLQ dump script of the above property.
===============================================================
insert into ALL_TAB_COLUMNS (OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE,
DATA_TYPE_MOD, DATA_TYPE_OWNER, DATA_LENGTH, DATA_PRECISION, DATA_SCALE,
NULLABLE, COLUMN_ID, DEFAULT_LENGTH, DATA_DEFAULT, NUM_DISTINCT, LOW_VALUE,
HIGH_VALUE, DENSITY, NUM_NULLS, NUM_BUCKETS, LAST_ANALYZED, SAMPLE_SIZE,
CHARACTER_SET_NAME, CHAR_COL_DECL_LENGTH, GLOBAL_STATS, USER_STATS,
AVG_COL_LEN, CHAR_LENGTH, CHAR_USED, V80_FMT_IMAGE, DATA_UPGRADED) values
('JVN', 'DOI_TUONG', 'MO_TA', 'CLOB', null, null, 4000, null, null, 'Y', 6,
null, null, null, null, null, null, null, null, null, null, 'CHAR_CS', 4000,
'NO', 'NO', null, 0, null, 'NO', 'YES');
===============================================================
You can see the data_length of this CLOB property is only 4000. I don't know
why? You can see my attached file.
http://www.nabble.com/file/p13871828/DoiTuong.java DoiTuong.java
http://www.nabble.com/file/p13871828/doi_tuong_table.sql doi_tuong_table.sql
Thanks
Allan Ang wrote:
>
> You modified the type in Oracle right? CLOB allows storage of up to 4MB so
> I'm pretty sure a CLOB will work. Perhaps you could include your model
> class and also the SQL dump of your table and I'll have a look.
>
>
>
--
View this message in context:
http://www.nabble.com/How-to-insert-a-large-character-object-into-Oracle-database-from-Appfuse.-tf4833863s2369.html#a13871828
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
