I'm using Hibernate for database access. I have a Hibernate query which appears valid, and appears to generate valid SQL.

When trying to execute the query, I get an exception:

Tracing back to the call:

result = conn.prepareStatement(sql);

The Hibernate query is:

And the generated SQL is:

I can execute the statement in another query tool, and filling in a value for the '?' I get two rows of output, which matches my dataset - so the query itself does work.

For the query, I left out most result fields not relevant for testing the problem. There's still a JOIN which doesn't make sense in this dressed-down version of the query, but which is introduced by Hibernate.

For the purpose of this query, the tables and relevant fields are (in my opinion):

- Organisation (id: PK)

- Process(id: PK)

- ProcessingPersonalData(id: PK & FK to Process(id) ) - extension table of Process

- PPD_Exec_Org(PPD_ID: FK to ProcessingPersonalData(id), Organisation_ID: FK to Organisation(id) ) - link table to express m:n relation between entities Organisation & ProcessingPersonalData

The Hibernate version, in case it's relevant, is 3.6.10. Firebird version 2.5.4 for MacOS, JDBC driver version is 2.2.8 JDK8.

All the columns in this query have data type java.lang.Long in Java, Numeric(18,0) in the database.

I can probably make a workaround using a direct SQL query, but I'd appreciate if I could work with Hibernate.

I would appreciate if anyone can give some advice on what is wrong, if this is a bug in the driver, or elsewhere.

If more information is required I'd be happy to provide it.

Kind regards,

--Tim van der Leeuw

The full stack trace is: