By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

SQLException on

P: n/a

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
[ResultSet@153e9cf] next () called
SQLException: SQLState(null) vendor code(-99999) Query processing has been terminated due to
error on the server.
at weblogic.jdbc.wrapper.ResultSet_com_ibm_db2_jcc_c_ Source)
Our database: IBM DB2 8.1 (Linux)
Our JDBC driver: IBM type 4

Thank you
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.