Apache OpenOffice (AOO) Bugzilla – Issue 116992
Binary blob column does work in table but not in view
Last modified: 2013-01-29 21:43:38 UTC
to reproduce: Connect to a database (in my case firebird) via jdbc (Jaybird 2.2) from any client (I tested WindowsXP-Client and mac OS X). The table must have a column e.g. "IMAGE" of type BLOB sub_type 0 not null. Create a view on the table showing the blob colum "IMAGE". Display the table in oo base -> Works fine Display the view in oo base -> Error message: org.firebirdsql.jdbc.FBCachedBlob cannot be cast to org.firebirdsql.jdbc.FBBlob This problem might be similar to resolved issue #105086 I have checked the connection via JDBC with a small java program and it works fine for both table and view. So JDBC should not be the reason here.
I can confirm it with OOo 3.3 this happens and only with view. To reproduce it, open file connected to firebird server with JDBC. add image field to any table with BLOB sub_type 0. Create form, add any image through form, to table, you can add image without problem. You can open table without any problem. Create view select all fields from table, save it. When double click on view you get error: org.firebirdsql.jdbc.FBCachedBlob cannot be cast to org.firebirdsql.jdbc.FBBlob Same happens in DEV300m100. If I open in cws dba34d version downloadable from qa-upload, if I click on table the table not opens, give same error message what I get when open view. Something went wrong in cws dba34c or d with Blobs.
The same error shows up not only with views but also with a query from OO base of the same kind.