--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> Hi,
>
> > Hi, we have a strange error here which seems to only occur on
> > win2000.
> In theory you should get Dynamic SQL Error in executeQuery(), not in
> next()... Can you post full stack trace here?

I /knew/ I should have included a stacktrace, stupid me... the Win2k
box is a work colleagues, but I may be able to pop back into the
office before next week and get a trace.

>
> > Error org.firefirdsql.jdbc.FBSQLException: GDS Exception. 335544569.
> > Dynamic SQL Error
> > SQL error code = -504
> > Cursor
>
> Is this issue reproducable? Can you prepare small test case that

reproduces

> the above described problem?

Yes, every time with the same query, and with some others also... but
some shorter queries run ok before this occurs.
Because I don't know what it is about that particular query that
causes the problem, I don't know how easy it will be to create a
simple stand-alone test case.
One thing that may be a factor - it is possible that the person who
wrote that bit of code may have requested updateable and/or
bi-directional scrollable cursor when creating the statement. Could
that be the problem? I warned them not to because I think some docs
said some of those features were unsupported, but some of it /did/
work with the 1.5.0beta3 driver (and I assumed that would be temporary!).

>
> Thanks!
> Roman

One other interesting thing I noticed when changing from the
1.5.0beta3 driver to 1.5.4: I run a large migration program and with
the new driver it complained about a char column truncation (the old
driver didn't). That's a good thing because I wasn't aware of the
problem in the data which I've now fixed... was the 1.5.0beta3 driver
allowing some column truncation to pass silently?

Thanks,
Phil