470,638 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

SQLException on ResultSet.next


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
Nov 12 '05 #1
0 2072

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by gsuns82 | last post: by
21 posts views Thread by madhoriya22 | last post: by
2 posts views Thread by siladityadash | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.