Do a SELECT COUNT(*) FROM ...
query instead.
OR
int size =0; if (rs != null) { rs.last(); // moves cursor to the last row size = rs.getRow(); // get row id }
In either of the case, you won’t have to loop over the entire data.
Related Posts:
- Efficient way to do batch INSERTS with JDBC
- java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
- java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- DB2 jdbc connection error Connection refused. ERRORCODE=-4499, SQLSTATE=08001
- Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
- What does the following Oracle error mean: invalid column index
- What does the following Oracle error mean: invalid column index
- DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704
- ResultSet exception – before start of result set
- java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
- IO Error: The Network Adapter could not establish the connection
- java.sql.SQLException: No database selected – why?
- Getting java.sql.SQLException: Operation not allowed after ResultSet closed
- Cannot issue data manipulation statements with executeQuery()
- What kind of Java type is “[B”?
- JPA or JDBC, how are they different?
- Hibernate show real SQL
- How to convert java.util.Date to java.sql.Date?
- How does the Java ‘for each’ loop work?
- What does “Could not find or load main class” mean?
- How do I create a file and write to it?
- When to use LinkedList over ArrayList in Java?
- How to convert a char to a String?
- How do you create a dictionary in Java? [closed]
- How do I declare and initialize an array in Java?
- Convert list to array in Java [duplicate]
- Convert String to double in Java
- Initialization of an ArrayList in one line
- Is there a Heap in java?
- “Exception in thread “main” java.lang.IndexOutOfBoundsException: Index: 0, Size: 0″ with ArrayList?
- Raising a number to a power in Java
- Running JAR file on Windows 10
- Iterate through a HashMap [duplicate]
- How to match “any character” in regular expression?
- Double array initialization in Java
- I want to declare an empty array in java and then I want do update it but the code is not working
- Usage of @see in JavaDoc?
- Hadoop “Unable to load native-hadoop library for your platform” warning
- Eclipse: Java was started but returned error code=13
- Why java unknown: import org.apache.commons.codec.binary.Base64;?
- Extracting .jar file with command line
- Unable to create requested service [org.hibernate .engine.jdbc.env.spi.JdbcEnvironment]-MySQL
- Why do I get “Exception; must be caught or declared to be thrown” when I try to compile my Java code?
- Check jdk/JRE is installed and get path for jvm.dll
- What is Java String interning?
- Rename a file using Java
- What is “String args[]”? parameter in main method Java
- “A java exception has occurred” when opening .jar
- Spring Maven clean error – The requested profile “pom.xml” could not be activated because it does not exist
- Java Class File Editor
- Error Importing SSL certificate : Not an X.509 Certificate
- How do I draw a triangle?
- warning: [options] bootstrap class path not set in conjunction with -source 1.5
- “Actual or formal argument lists differs in length”
- TreeMap sort by value
- Encrypt Password in Configuration Files?
- IDEA: javac: source release 1.7 requires target release 1.7
- Can we write our own iterator in Java?
- local variables referenced from a lambda expression must be final or effectively final
- java.lang.IllegalMonitorStateException: object not locked by thread before wait()?
- WebServlet cannot be resolved to a type
- How do I print out the value of this boolean? (Java)
- How to add an object to an ArrayList in Java
- Getting warning “NDK is missing a ‘platforms” directory.’ with no NDK
- No appenders could be found for logger(log4j)?
- ArrayList<> cannot be resolved to a type
- Exception in thread “main” java.lang.StringIndexOutOfBoundsException: String index out of range: 0
- Error: Main method not found in class Calculate, please define the main method as: public static void main(String[] args) [duplicate]
- Android For loop
- Java project in Eclipse: The type java.lang.Object cannot be resolved. It is indirectly referenced from required .class files
- Replace a character at a specific index in a string?
- Error array dimension missing
- How to detect EOF in Java?
- Information about _JAVA_OPTIONS
- Two dimensional array list
- Must issue a STARTTLS command first
- Convert boolean to int in Java
- How to convert a String to CharSequence?
- Aspect Ratio with 800×480
- Cannot invoke toString() on the primitive type int
- Creating a Calendar using javafx
- A tool for calculating the big-O time complexity of Java code? [closed]
- How to print binary tree diagram in Java?
- Must qualify the allocation with an enclosing instance of type GeoLocation
- Unknown version of Tomcat was specified in Eclipse
- How to compare character ignoring case in primitive types
- How can I wait for 10 second without locking application UI in android [duplicate]
- Java error “Value of local variable is not used”
- Convert float to double without losing precision
- Exception in thread “AWT-EventQueue-0” java.lang.OutOfMemoryError: Java heap space
- How do the post increment (i++) and pre increment (++i) operators work in Java?
- Manually throw an exception
- Spring boot: Unable to start embedded Tomcat servlet container
- How does paintComponent work?
- toring and Retrieving ArrayList values from hashmap
- Could not find or load main class with a Jar File
- “uses unchecked or unsafe operations” [duplicate]
- How do I enable index downloads in Eclipse for Maven dependency search?