No, I have no test case. I try to get the Image as binary data from DB
to send it to a report. For the Report I use Freereport and Pentaho
System. The complete message is:
11:49:49,399 ERROR [SQLResultSet] SQLResultSet.ERROR_0005 - Kann die
nächste reihe im Resultset nicht erreichen.
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544329. invalid
BLOB ID
at
org.firebirdsql.jdbc.field.FBBlobField.getBytesInternal(FBBlobField.java:165)
at
org.firebirdsql.jdbc.field.FBBlobField.getBytes(FBBlobField.java:113)
at org.firebirdsql.jdbc.field.FBField.getObject(FBField.java:577)
at
org.firebirdsql.jdbc.FBResultSet.getObject(FBResultSet.java:515)
at
org.pentaho.data.connection.sql.SQLResultSet.next(SQLResultSet.java:83)
at
org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:274)
at
org.pentaho.plugin.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:189)
at
org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:422)
at
org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:993)
at
org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:965)
at
org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:881)
at
org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:837)
at
org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:743)
at
org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:659)
at
org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:268)
at
org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:212)
at
org.pentaho.core.solution.SolutionHelper.execute(SolutionHelper.java:93)

In FireBird I use Blob Sub_Type 0. This is correct or?

--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@...> wrote:

>
> > 09:51:07,078 ERROR [SQLResultSet] SQLResultSet.ERROR_0005 - Kann die
> > nächste reihe im Resultset nicht erreichen.
> > org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544329. invalid
> > BLOB ID
> > ...
> > What did it mean??
>
> That for some reason it does not know the BLOB ID. Do you have a

test case

> for the error?
>
> Roman
>