Illegal operation on empty result set [duplicate]

by

You are not checking whether your result set has any data or row in it.

ResultSet rs = stmt.executeQuery();
rs.next();
...
...

You should check whether your result is empty or having any row:

ResultSet rs = stmt.executeQuery();
if(rs.next()){
.....
your code
.....
}

More Related Contents:

  1. What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it?
  2. How can I solve “java.lang.NoClassDefFoundError”?
  3. What are the effects of exceptions on performance in Java?
  4. How to generate exceptions from RepaintManager
  5. ClassNotFoundException com.mysql.jdbc.Driver [duplicate]
  6. How to create custom exceptions in Java? [closed]
  7. Given final block not properly padded
  8. Null check chain vs catching NullPointerException
  9. Why does division by zero with floating point (or double precision) numbers not throw java.lang.ArithmeticException: / by zero in Java
  10. When should we create our own Java exception classes? [closed]
  11. How to test that no exception is thrown?
  12. Using Joda Date & Time API to parse multiple formats
  13. How to create a custom exception type in Java? [duplicate]
  14. Why are Exceptions not Checked in .NET?
  15. Java: Exceptions as control flow?
  16. Closing a Scanner throws java.util.NoSuchElementException
  17. “NoClassDefFoundError: Could not initialize class” error
  18. What is a suppressed exception?
  19. In a Java 7 multicatch block what is the type of the caught exception?
  20. What are reasons for Exceptions not to be compatible with throws clauses?
  21. In Java how can I validate a thrown exception with JUnit?
  22. The throws keyword for exceptions in Java
  23. Exception other than RuntimeException
  24. Getting Exception org.apache.logging.slf4j.SLF4JLoggerContext cannot be cast to org.apache.logging.log4j.core.LoggerContext
  25. Exception in thread “main” java.io.FileNotFoundException: Error
  26. Is it a bad idea to use printStackTrace() for caugt Exceptions?
  27. Is there an unhandled exception handler in Java?
  28. The local variable might not have been initialized – Detect unchecked exception throw within a method
  29. org.openqa.selenium.UnhandledAlertException: unexpected alert open
  30. Side effects of throwing an exception inside a synchronized clause?

Leave a Comment