472,811 Members | 1,464 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,811 software developers and data experts.

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 2228

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: gsuns82 | last post by:
hi, my java code: **************** import java.sql.*; public class sqljdbc { public static void main(String args) { try {
by: jazz1 | last post by:
my coding is <% //Connection conn=null; //Statement st=null; //ResultSet rs=null; int msgCount; try { String userid=request.getParameter("application_no");
by: rajamohammed | last post by:
Hi Everyone, I gettiing exception while deleting a record,that java.sql.SQLException: No ResultSet set was produced. But the record is deleted successfully. Please help me. Thanks. Raja...
by: rajamohammed | last post by:
Hi Everyone, I am gettiing exception while deleting a record,that java.sql.SQLException: No ResultSet set was produced. But the record is deleted successfully. Please help me. Thanks, Raja...
by: lunas | last post by:
hi i am trying to update a table selecting a value from another table and ve written the following codes for it.. import java.sql.*; import java.io.*; import java.util.*; public class...
by: madhoriya22 | last post by:
Hi, Here is the query which I am using to get the values from the database:- "SELECT ?, COUNT(*) AS COUNT " + "FROM DEFECT_DETAIL " + "WHERE TARGET_MILESTONE = ? " + "GROUP BY ?"; ...
by: ajos | last post by:
hi frnds, im trying to convert my servlets database configuration from ms access to mysql database.however im getting some error like no driver found exception. to verify this error ive...
by: siladityadash | last post by:
I'am facing a error when populating the resultset i.e java.sql.SQLException:Closed Resultset:next
by: freethinker | last post by:
Hi, I have a database class I use to get and drop db connections: public class Database { protected static Connection c; //.... /// .. c = DriverManager.getConnection .... ...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.