Hi, we have a strange error here which seems to only occur on win2000.

For a long time we were using the JDBC driver 1.5.0Beta3. We finally
got around to installing 1.5.4. This appears to work without any
issues on WinXP and the Mac, but when running the identical
application on Win2000 we get errors for some operations.
For example, when calling ResultSet .next(), the following error occurs:

Error org.firefirdsql.jdbc.FBSQLException: GDS Exception. 335544569.
Dynamic SQL Error
SQL error code = -504
Cursor

Hmmm...
The application & database are typically on the same machine, hence I
run this on XP or the Mac with no problems. Both of these can use the
database on Win2000 with no problem. But running the code on Win2000,
it doesn't matter whether the code points to a local database or one
on the Mac or XP, the error occurs, so it definitely appears to be a
client-side error when calling next().
The code is simply:
ResultSet rs = myStatement.executeQuery(queryStr);
if(rs.next())

Where the query is (not mine ;-) ):

SELECT b.PREBUILTBARCODE, b.LAST_NAME || ', ' || b.FIRST_NAME,
w.TEXT as DEPARTMENT, w2.TEXT as NEXTDEPARTMENT, b.CANBORROW, b.PIN,
w3.TEXT as YEARGROUP, w4.TEXT as VERTICALGROUP, bt.DESCRIPTION,
w5.TEXT as GENDER, b.BORROWER_SN
FROM BORROWERS b
LEFT OUTER JOIN WORDSTORE w ON b.DEPARTMENT_SN = w.WORDSTORE_SN
LEFT OUTER JOIN WORDSTORE w2 ON b.NEXTDEPARTMENT_SN = w2.WORDSTORE_SN
LEFT OUTER JOIN WORDSTORE w3 ON b.YEARGROUP_SN = w3.WORDSTORE_SN
LEFT OUTER JOIN WORDSTORE w4 ON b.VERTICALGROUP_SN = w4.WORDSTORE_SN
LEFT OUTER JOIN WORDSTORE w5 ON b.GENDER_SN = w5.WORDSTORE_SN
LEFT OUTER JOIN BORROWERTYPES bt ON b.BORROWERTYPE_SN = bt.BORROWERTYPE_SN
WHERE b.RECORDSTATUS = 1 ORDER BY UPPER(b.PREBUILTBARCODE)


Any ideas?
Thanks...