Hi,

> In version RC2 of Jaybird (released Dec. 2002), there is a small
> JDBC bug when reading from a view. If that view contains a ''
> mapping, various errors occur upon select, most commonly "out of
> memory."
>
> For example, a view defined as:
>
> CREATE VIEW "TEST" ("SEASON_NO", "EMPTY_CHAR")
> AS
> SELECT SEASON_NO, '' FROM SPREADSHEET_TEST;
>
> Will cause the aforementioned problems. As soon as the '' is
> removed, it works fine.

Can you post a small test case to reproduce the bug? I tried current
CVS version and found other problems when using a this type of view
(request sync. error in autocommit mode, fetch bug with explicit tx
management), but no OutOfMemoryException.

Note, this view definition is not 100% correct because you do not
give a hint to a server what is the size of your EMPTY_CHAR column.
Using CAST('' AS VARCHAR(1)) solves the problem. But I will try to
fix present bugs too.

Thanks!
Roman Rokytskyy