Subject | Re: null blob causes exception |
---|---|
Author | adobni |
Post date | 2003-06-11T20:35:44Z |
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:
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 :)http://docs.yahoo.com/info/terms/
>
> 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
> >
> >