Hi Bruno,

Bruno CROS wrote:
  Hi,

I need a little documentation on CLOB too.

To start, does someone can tell me which java type i have to use (to map)
with a jdbc-type CLOB ?

java.sql.Clob? as the OJB types mapping board shows it. but java.sql.Clob is
only an interface. What object to create so ? ( is there a Clob
implementation ?)

String (or StringBuffer)? does OJB always load all the data on queries !?
oups !

Byte[] ? as BLOB. I need some special character, only found in UNICODE.
byte[] means that content is in "bad" ASCII for me.

any other type ?

you are right, currently the CLOB/BLOB support isn't very sophisticated (BLOB columns mapped to byte[], CLOB mapped to String - see JdbcTypesHelper class). Currently we think about to introduce JdbcType classes which handle the Clob/Blob interfaces instead of the materialized String/byte[] objects.
Any suggestions are welcome.


regards,
Armin



Thanks for any ligtht.


On 1/4/06, Armin Waibel <[EMAIL PROTECTED]> wrote:
Hi Vamsi,

sorry for the late reply.
I added an JIRA issue (maybe someone can spend time to adapt this
section).

regards,
Armin


Vamsi Atluri wrote:
Hello all,

In our application we use OJBs extensively. However, we have a CLOB
field
that needs to be populated within the application. I was trying to find
documentation about OJB's support for *LOB objects at this link:
http://db.apache.org/ojb/docu/howtos/howto-use-lobs.html

However, all I could find was this:

Strategy 1: Using streams for LOB I/O

########## to be written #########
Strategy 2: Embedding OJB content in Java objects

########## to be written #########
Querying CLOB content

########## to be written #########


Is there any documentation out there that explains these concepts?  Any
help is greatly appreciated. Thanks.

Regards,
-Vamsi

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to