Subject Re: null blob causes exception
Author adobni
Here is it. Are we doing something wrong?

Select * from Release where idPublicacion='"+idPublicacion+"' ORDER BY
fechaHora DESC;

the table:
CREATE TABLE release (





idRelease VARCHAR(12) NOT NULL ,





idPublicacion VARCHAR(12) NOT NULL ,





descripcion VARCHAR(100) ,





fechaHora TIMESTAMP ,





fechaHoraAlta TIMESTAMP ,





pathRaiz VARCHAR(100) ,





ejecutaAntes blob,





ejecutaDespues blob,





PRIMARY KEY (idRelease,idPublicacion));


--- In Firebird-Java@yahoogroups.com, Luca Lafranchi
<luca.lafranchi@r...> wrote:
> Hi :)
>
> Could you at least provide the statement which fails?
>
>
> adobni wrote:
> > Trying to execute a query causes the following exception if a record
> > has a null blob field. Seems like a bug, could it be corrected?
> >
> > java.sql.SQLException: You can't read a new blob
> > at
> > org.firebirdsql.jdbc.FBBlob$FBBlobInputStream.<init>(FBBlob.java:343)
> > at
> > org.firebirdsql.jdbc.FBBlob$FBBlobInputStream.<init>(FBBlob.java:338)
> > at org.firebirdsql.jdbc.FBBlob.getBinarySt
> > ream(FBBlob.java:158)
> > at
> > org.firebirdsql.jdbc.FBBlobField.getBytesInternal(FBBlobField.java:12
> > 5)
> > at
> > org.firebirdsql.jdbc.FBBlobField.getCachedObject(FBBlobField.java:172
> > )
> > at
> > org.firebirdsql.jdbc.FBCachedFetcher.<init>(FBCachedFetcher.java:119)
> > at org.firebirdsql.jdbc.FBResultSet.<init>
> > (FBResultSet.java:122)
> > at
> > org.firebirdsql.jdbc.FBStatement.getCachedResultSet(FBStatement.java:
> > 565)
> > at
> > org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:107)
> > at
> > com.sibs.sf2.server.controller.comandos.CmdUltimoRelease.execute(CmdU
> > ltimoRelease.java:34)
> > at webService.SF2ServerImpl.login(Unknown Source)
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >