Hi,
we have a query that returns only a few rows, but has a lot of columns in
group by clause. In some cases we receive an SQL Exception.
Here is the trace
[PreparedStatement@1d226a7] setString (1, 20040928001) called
[PreparedStatement@1d226a7] setString (2, 200409160000000000071168) called
[PreparedStatement@1d226a7] setDouble (3, 4701298.0) called
[PreparedStatement@1d226a7] setMaxRows (5001) called
[PreparedStatement@1d226a7] executeQuery () called
[ibm][db2][jcc][t4] SEND BUFFER: OPNQRY
....
[ibm][db2][jcc][t4] RECEIVE BUFFER: OPNQRYRM
....
[PreparedStatement@1d226a7] executeQuery () returned ResultSet@153e9cf
[ResultSet@153e9cf] getMetaData () called
[ResultSet@153e9cf] getMetaData () returned com.ibm.db2.jcc.a.j@1e7c4d4
[ResultSet@153e9cf] next () called
SQLException: SQLState(null) vendor code(-99999)
com.ibm.db2.jcc.a.SqlException: Query processing has been terminated due to
error on the server.
at com.ibm.db2.jcc.c.c.A(c.java:1041)
at com.ibm.db2.jcc.c.c.a(c.java:499)
at com.ibm.db2.jcc.c.c.b(c.java:205)
at com.ibm.db2.jcc.a.o.a(o.java:190)
at com.ibm.db2.jcc.a.cj.c(cj.java:304)
at com.ibm.db2.jcc.a.cj.next(cj.java:279)
at weblogic.jdbc.wrapper.ResultSet_com_ibm_db2_jcc_c_ g.next(Unknown Source)
Our database: IBM DB2 8.1 (Linux)
Our JDBC driver: IBM type 4
Thank you
Eckard