Solved

Problems with resultset being to large

Posted on 2004-09-21
8
167 Views
Last Modified: 2010-03-31
We are running a query using jdbc, the total amount of records that could be returned are 100,000. Could this be a problem in our java code?
0
Comment
Question by:inzaghi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 35

Accepted Solution

by:
girionis earned 150 total points
ID: 12111807
> We are running a query using jdbc, the total amount of records that
> could be returned are 100,000. Could this be a problem in our java code?

It depends what do you mean by a problem in your java code. Generally though no, it shouldn't be a problem.

0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 50 total points
ID: 12111817
What are you thinking of?
0
 
LVL 37

Assisted Solution

by:zzynx
zzynx earned 50 total points
ID: 12111835
>> Could this be a problem in our java code?
If e.g. you keep all records in memory that could lead to memory problems
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

Author Comment

by:inzaghi
ID: 12111846
What I meant could an SQLException be thrown if the resultset from the query is to big
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12111866
No
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 12111887
8-)
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12111894
Thanks for accepting
(Fast as lightening)
0
 
LVL 35

Expert Comment

by:girionis
ID: 12111898
:)
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question