FetchResponse cannot be cast to GenericResponse

[Stefan Schmaltz]

Jaybird 6.0.3 Firebird 5.0.3

SELECT UGR_PARENTID,UGR_ID,UGR_GROUPNAME FROM USERGROUPS

java.lang.ClassCastException: class org.firebirdsql.gds.ng.wire.FetchResponse cannot be cast to class org.firebirdsql.gds.ng.wire.GenericResponse (org.firebirdsql.gds.ng.wire.FetchResponse and org.firebirdsql.gds.ng.wire.GenericResponse are in unnamed module of loader 'app')

at org.firebirdsql.gds.ng.wire.version10.V10Statement.execute(V10Statement.java:305)

at org.firebirdsql.jdbc.FBStatement.internalExecute(FBStatement.java:861)

at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute(FBPreparedStatement.java:579)

at org.firebirdsql.jdbc.FBPreparedStatement.executeQuery(FBPreparedStatement.java:199)

at org.firebirdsql.jdbc.FBPreparedStatement.executeQuery(FBPreparedStatement.java:191)

at komet3.DB.Komet3PreparedStatement.executeQuery(Komet3PreparedStatement.java:133)

at com.borland.dx.sql.dataset.PreparedStmt.executeQuery(PreparedStmt.java:119)

at komet3.DB.entityTools.Komet3EntityTools.getEntitiesByQuery(Komet3EntityTools.java:1636)

at komet3.DB.entityTools.Komet3EntityTools.getEntitiesByQuery(Komet3EntityTools.java:1595)

[Mark Rotteveel]

Please provide a reproducible example. As far as I know, there shouldn't be a FetchResponse there, so there is something really wrong if one does happen.

Mark

-- 
Mark Rotteveel

[Stefan Schmaltz]

Just running the sql in a loop. Looks like it's working 200x, than I got this error.

[Mark Rotteveel]

On 09/12/2025 08:14, Stefan Schmaltz wrote:
> Just running the sql in a loop. Looks like it's working 200x, than I got
> this error.

Do you prepare it once, and then execute it 200x, or do you prepare it
on each iteration? Do you also fetch some rows, or all rows, or just
execute? Are you in auto-commit mode, or is auto-commit disabled?

Do you also cancel in between (e.g. referring to thread
https://groups.google.com/g/firebird-java/c/WDsY8fBLmyo/m/r56MBQefAAAJ),
or otherwise access or use the statement or connection from multiple
threads?

This is *why* I ask for a reproducible example, so I don't have to guess
at things like this, and other things I might not even be thinking of
right now.

Mark

--
Mark Rotteveel

[Mark Rotteveel]

On 09/12/2025 08:14, Stefan Schmaltz wrote:

> Just running the sql in a loop. Looks like it's working 200x, than I got
> this error.

I really need a reproduction recipe, because just executing 200x (or
more) does not reproduce the problem.

Mark
--
Mark Rotteveel