[solved] Blob subtype 0 creates "org.firebirdsql.jdbc.FBCachedBlob cannot be cast to org.firebirdsql.jdbc.FBBlob" on select [JDBC168] #212
Comments
Modified by: Dr. Schorsch (xorx)Version: Jaybird 2.2 [ 10053 ] Version: Jaybird 2.1.6 [ 10285 ] => |
|
Commented by: Dr. Schorsch (xorx) We have tested the same database using a Java program to connect to it. There was some issue with the code generation for a table containing the binary blob, but an image control does display the image and there is no type cast error message. Therefore I think we have to look in OOo base for the reason of this failure. |
Modified by: Dr. Schorsch (xorx)priority: Major [ 3 ] => Trivial [ 5 ] timeestimate: 0 [ 0 ] timeoriginalestimate: 0 [ 0 ] summary: Blob subtype 0 creates "org.firebirdsql.jdbc.FBCachedBlob cannot be cast to org.firebirdsql.jdbc.FBBlob" on select => [solved] Blob subtype 0 creates "org.firebirdsql.jdbc.FBCachedBlob cannot be cast to org.firebirdsql.jdbc.FBBlob" on select |
Modified by: Roman Rokytskyy (rrokytskyy)Fix Version: Jaybird 2.2 [ 10053 ] |
|
Commented by: Roman Rokytskyy (rrokytskyy) The issue is related to the fact how OO works with JDBC. It violates the specification in some places, therefore we have a special driver for OO users that tolerates those violations in expense of memory (basically, it makes all statements cached, which means that each result set will be fully fetched to the client). So, with version from HEAD you can use another URL - jdbc:firebirdsql:oo: , driver will do the rest. |
Modified by: Roman Rokytskyy (rrokytskyy)status: Open [ 1 ] => Closed [ 6 ] resolution: Fixed [ 1 ] |
Submitted by: Dr. Schorsch (xorx)
Assigned to: Roman Rokytskyy (rrokytskyy)
I have a database table with a column of type Blob, subtype 0, containing an image.
When I do a select on this table it works fine. Open office shows "<OBJECT>" in the table view for the image column and it displays the image in the form.
Now I created the following query:
SELECT "Auflagen".*, "Techniken"."TechnikD", "Techniken"."TechnikE", "Werkgruppen"."WerkgruppeD", "Werkgruppen"."WerkgruppeE", "Werke"."TitelD", "Auflagen"."BildHoehe", "Werke"."TitelE", "Werke"."Jahr", "Werke"."Beschreibung", "Werke"."Bild" FROM "Auflagen" AS "Auflagen", "Werke" AS "Werke", "Techniken" AS "Techniken", "Werkgruppen" AS "Werkgruppen" WHERE "Auflagen"."WerkID" = "Werke"."ID" AND "Techniken"."ID" = "Werke"."TechnikID" AND "Werkgruppen"."ID" = "Werke"."WerkGruppeID" ORDER BY "Werkgruppen"."WerkgruppeD" ASC, "Werke"."TitelD" DESC, "Auflagen"."BildHoehe" DESC
This request works fine from FlameRobin.
Performing this query from openoffice via firebird JDBC does produce the following error:
org.firebirdsql.jdbc.FBCachedBlob cannot be cast to org.firebirdsql.jdbc.FBBlob
When I remove the column "Werke"."Bild", which is the blob containing the image, the request works fine again.
Any ideas around?
Thanks,
Georg
The text was updated successfully, but these errors were encountered: