> it *mostly* works. The only problem seems to be 
> that Oracle 
> apparently does not distinguish between zero-length strings 
> and NULL, so

I have run into this before with Oracle. Very yucky.

> if you initialize the CLOB with Hibernate.createClob(""), the actual 
> database column is nullified and the subsequent getClob() 
> call returns 
> null, making the clob.getCharacterOutputStream() fail with a NPE.
> 
> As a quick&dirty hack, I've changed createClob("") to createClob(" ") 
> and everything seems to work ok. 

Ugo, would you please produce a page documenting your approach to this
for the Wiki. Other people will also need to know this stuff.

> However, I was wondering if it is 
> really necessary to open a new session. Couldn't we somehow reuse the 
> former session?

Well, not currently. Occasionally other people have requested things
like Session.refresh(), which I have stubbornly not implemented because
I never saw a really compelling use case. ( *This* is a good use case
for refresh(). )

For Hibernate 2, should we add one or both of:

Session.evict(foo); //remove foo from the Session-level cache
Session.refresh(foo); //reload foo's state from the database

There *would* be some exotic cases (like this one) where they could
be useful....

Opinions?


********** CAUTION - Disclaimer **********
This message may contain privileged and confidential
information. If you are not the intended recipient of this
message (or responsible for delivery of the message to
such person) you are hereby notified that any use,
dissemination, distribution or reproduction of this message
is prohibited. If you have received this message in error,
you should destroy it and kindly notify the sender by reply
e-mail. Please advise immediately if you or your employer
do not consent to Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this
message that do not relate to the official business of
Expert Information Services Pty Ltd ("The Company")
shall be understood as neither given nor endorsed by it.

The Company advises that this e-mail and any attached
files should be scanned to detect viruses. The Company
accepts no liability for loss or damage (whether caused
by negligence or not) resulting from the use of any
attached files.
**EIS******** End of Disclaimer **********



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

Reply via email to