Allan is correct, you need a CLOB, or a LOB. If you are using Hibernate you
won't need to worry about which of the Clob data structures you'll use, as
hibernate will choose it for you based on your database's dialect.
The annotations for a String object like this might look like:
@Lob
@Basic(fetch = FetchType.LAZY)
@Column
private String cachedXml;
public String getCachedXml() {
return cachedXml;
}
public void setCachedXml(String cachedXml) {
this.cachedXml = cachedXml;
}
Note that I'm using FetchType.LAZY because quering large items like this
using Hibernate will really slow down the system and eat away at memory
otherwise.
I hope it helps,
Jason
phamvubinh wrote:
>
> There are many clob type in java:
> - java.sql.Clob.
> - oracle.sql.Clob.
> - com.mysql.jdbc.Clob.
> - org.hibernate.type.ClobType.
> Which one can I use.
>
> I have tried some types of Clob, but the data_length in database just is
> 4000. It's not enough for my data.
>
>
> Allan Ang wrote:
>>
>> CLOB
>>
>
>
--
View this message in context:
http://www.nabble.com/How-to-insert-a-large-character-object-into-Oracle-database-from-Appfuse.-tf4833863s2369.html#a13851791
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
