Subject Re: [Firebird-Java] Empty blob query problem
Author Blas Rodriguez Somoza
Hello

I'm analizing your problem, as soon as there is an answer I'll post it to the list.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "William L. Thomson Jr." <support@...>
To: "Firebird-Java" <Firebird-Java@yahoogroups.com>
Sent: Wednesday, July 24, 2002 1:36 AM
Subject: Re: [Firebird-Java] Empty blob query problem


> Has the problem below been resolved yet or not. I did not receive or
> seen any feedback on it?
>
> I do need it addressed ASAP if it has not been resolved.
>
> Thank you.
>
> On Fri, 2002-07-19 at 12:51, William L. Thomson Jr. wrote:
> > I am having problems with queries that return empty blob fields. They
> > worked fine with InterClient, and I only had to check the
> > resultset.getBytes() to see if it was null or not.
> >
> > Now with the Firebird JDBC driver I keep getting the following
> > exception, which is driving me nutz.
> >
> > java.sql.SQLException: You can't read a new blob
> >
> > First of all, it's not a new blob but an empty one.
> >
> > So if it was to return an exception it should be
> > You can't read a null or empty blob.
> >
> > Now to go one step further, an exception should not be thrown at all. As
> > I will check the resultset to see if it is null or not. Like I could
> > with InterClient.
> >
> > This is causing some features of my Java apps that depend on retrieving
> > multiple blob fields to fail. Even though some of the blob fields are
> > full, it only takes on empty one to get this exception.
> >
> > Could this be changed, or addressed ASAP. As I do not want to have to
> > use InterClient, and this is the only reason why I would go back to
> > InterClient.
> >
> > Thanks
> >
> >
> > --
> > Sincerely,
> > William L. Thomson Jr.
> > Support Group
> > Obsidian-Studios Inc.
> > 439 Amber Way
> > Petaluma, Ca. 94952
> > Phone 707.766.9509
> > Fax 707.766.8989
> > http://www.obsidian-studios.com
> >
> >
> >
> > 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/
> >
> >
> --
> Sincerely,
> William L. Thomson Jr.
> Support Group
> Obsidian-Studios Inc.
> 439 Amber Way
> Petaluma, Ca. 94952
> Phone 707.766.9509
> Fax 707.766.8989
> http://www.obsidian-studios.com
>
>
>
> 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/
>
>
>