|Re: EL 1.2 / Oracle10: Empty String automatically converted to a Whitespace [message #507037 is a reply to message #506964]
||Mon, 11 January 2010 18:27
| Hans Harz
Registered: July 2009
Hi James, |
thank you for your answer. I don't think that it is the JDBC driver.
The Value column is a not null CLOB value. I think that first a "dummy" value is inserted, and afterwards the real value should be inserted with a select for update.
Again, I would expect a exception, because I entered '' in a not null column.
Here is a detailed log:
PersistenceLayer_Terminology - on Persist UserSetting testuser with value ''
assign sequence to the object (152 -> ...UserSettingEjb@8395b17d)
begin unit of work commit
Execute query InsertObjectQuery(...UserSettingEjb@8395b17d)
NSERT INTO USERSETTINGEJB (ID, USERID, EXPLICITVERSION, name, VALUE, UUID, EXTERNAL_ID, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
bind => [152, testuser, 2, foo, , 7ae939c7-1fab-46e8-a156-29c5b9e07223, 1263232915794, 1]
SELECT VALUE FROM USERSETTINGEJB WHERE (ID = ?) FOR UPDATE
bind => 
Writing CLOB value(size = 1 bytes) through the locator to the table field: VALUE
PersistenceLayer_Terminology - onPostPersist UserSetting testuser with value ''
Powered by FUDForum
. Page generated in 0.01737 seconds