Issue 105086

Summary:	base cannot write into Oracle blob fields from a form
Product:	Base	Reporter:	eberlein <pet.ebe>
Component:	code	Assignee:	marc.neumann
Status:	CLOSED FIXED	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	DEV300m58
Target Milestone:	OOo 3.3
Hardware:	All
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33b

Comment 6 r4zoli 2010-03-10 12:37:58 UTC

*** Issue 105087 has been marked as a duplicate of this issue. ***