Issue 105086 - base cannot write into Oracle blob fields from a form
Summary: base cannot write into Oracle blob fields from a form
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m58
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
: 105087 (view as issue list)
Depends on:
Reported: 2009-09-15 11:35 UTC by eberlein
Modified: 2017-05-20 10:24 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description eberlein 2009-09-15 11:35:36 UTC
to reproduce:
Connect to Oracle via jdbc from an WindowsXP-Client.
The table must have a column of type BLOB not null.
Create a form with a graphic control.
Select a picture and try to update/insert.
Message ORA:ORA: cannot update field to NULL.
Comment 1 Frank Schönheit 2009-09-15 22:26:22 UTC
confirming, grabbing, targeting
Comment 2 Frank Schönheit 2009-09-15 22:40:17 UTC
fs->oj: There seems to be some inconsistency in how binary streams are handled
in the RowSet (or perhaps the driver returns wrong meta data?) ...

The form calls updateBinaryStream at the RowSet, with a stream containing the
complete image. The RowSet decides to store this as byte sequence, since it
thinks that the respective column is of type VARCHAR. When insertRow is called,
the cache tries to pass the stream as statement parameter, it recognizes the
column is of type BLOB, and thus tries to extract a stream from the column value
- which fails, since the RowSet wrote a by sequence.

So, what astonishes me is that the RowSet and the RowSetCache have different
opinions on the type of the column. This should either be fixed, and/or the
RowSetCache code which tries to write a BLOB should be able to handle byte
sequences, too.
Comment 3 ocke.janssen 2009-11-13 12:31:22 UTC
Fixed in cws dba33b. 

The BLOB type wasn't supported very well.
Comment 4 ocke.janssen 2009-12-14 12:52:31 UTC
Please verify in cws dba33b. Thanks.
Comment 5 marc.neumann 2010-01-13 08:56:05 UTC
verified in CWS dba33b

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
Comment 6 r4zoli 2010-03-10 12:37:58 UTC
*** Issue 105087 has been marked as a duplicate of this issue. ***