Subject Re: [Firebird-Java] Empty blob query problem
Author William L. Thomson Jr.
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