CMP

camel Jul 7, 2004 2:01 AM

My goal is to store large amounts of text in a DB column -- as much as, say, 100,000 characters. So I used an "Object" CMP type and pass in a StringBuffer that just gets serialized. This is working fine, but I noticed that the serialized data type in the DB is org.jboss.invocation.MarshalledValue. This may be a problem if I need to access the data directly, using JDBC for example.

So my question is, (1) is there a better way to store large amounts of character data with CMP, and if not: (2) How can I make the serialized Object NOT be org.jboss.invocation.MarshalledValue, so I can access the data outside of JBoss and CMP?

I searched the forums and only found the following relevant post, with no apparent resolution: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=28910.

Thank you

Chris

1. Re: Serialized CMP goes to org.jboss.invocation.MarshalledVa

camel Jul 7, 2004 2:10 AM (in response to camel)

Sorry about the lame message subject "CMP", I thought I entered a more descriptive one when I posted. The subject should be something like:

Re: Serialized CMP goes to org.jboss.invocation.MarshalledValue -- why?
Actions
2. Re: CMP

aloubyansky Jul 7, 2004 2:59 AM (in response to camel)

Doesn't CLOB/BLOB help?
Actions
3. Re: CMP

aloubyansky Jul 7, 2004 3:13 AM (in response to camel)

Sorry, BLOB is stored as a MarshalledValue. Have you tried CLOB?
Actions

Go to original post