Unanswered: Db2 9.7 SP4 error code 840 with Hibernate
We are using hibernate (annotations) with DB2 9.7. We have a parent table with many child tables (a lot, and this will not be changed). When hibernate creates a select query, the select statement list gets so large that DB2 throws error code 840.
Has anyone had experience with similar problem? Thanks.
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
The error code states that too many records are retrieved with the select statement. However, if I end the statement with "FETCH FIRST 1 ROWS ONLY", it doesn't alter the result, I still get the same error code.
Therefore I still believe the problem is in that the select statement in itself is simply too large.