How to check resultset is null in java

How do you check is Result set is null. Bhasker Reddy. Optional 'thank-you' note:. Roopa Bagur. Fei Ng. Agree with Roopa. Hope this help. Date, java. Timestamp, and java. Date in JDBC? Date to java. Date in Java? If you found this example helpful please share it with your friends and colleagues. I would really appreciate it. Email This BlogThis! Share to Twitter Share to Facebook. Labels: core java interview question , JDBC. This comment has been removed by the author.

Thank you again October 10, at AM javin paul said November 29, at AM Anonymous said Its very useful. Was wondering why the 1st row is always missing. May 5, at PM Brandon said Thanks for taking the time to do the write-up June 27, at PM. Newer Post Older Post Home. Subscribe to: Post Comments Atom. Subscribe for Discounts and Updates Follow. Search This Blog. Interview Questions core java interview question data structure and algorithm 80 Coding Interview Question 75 interview questions 70 design patterns 35 SQL Interview Questions 34 object oriented programming 34 thread interview questions 30 spring interview questions 28 collections interview questions 25 database interview questions 16 servlet interview questions 15 Programming interview question 6 hibernate interview questions 6.

This happen when database operation is done in a separate class where statement. I have confronted with this error and that is the reason why I am writing. This can be a great problem when we do a batch process where one out of execution causes an exception in my case:. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Can a ResultSet be 'null' in Java? Ask Question. Asked 8 years, 5 months ago. Active 3 years, 2 months ago. Viewed 26k times. Improve this question. BalusC BalusC 1. No, but it will construct an unnecessary Integer object in the non-null case. It depends on fetch size. In most drivers, the default is 10 rows and once the fetch has been retrieved, they will be processed, but the next fetch won't be retrieved until processing has been finished.

I'm surprise that your answer is not the better answer :- I vote up because it is the proper answer that avoid the very tricky unsafe wasNull method. For me it is a supplementary reason to stop using Java ;- and to continue to use VB. Net where RecordSet has solved this easy problem since more than 10 years!

Peter Tillemans Peter Tillemans Just an update with Java Generics. If you're calling getObject , that returns a reference type which can already answer null. Unless you have an unusual driver or datatype answering some kind of non-null 'empty' objects, I would expect wasNull to only be useful after reading an integer or other primitive type whether the return-type cannot directly represent null.

Can you please go into more detail about how this solves the question? Edit that into your answer and delete the comment after the edit and you have yourself a good answer : — Sterling Archer. George George 6, 8 8 gold badges 29 29 silver badges 41 41 bronze badges. It needs to have the additional check of if rs.

Jacob Crofts Jacob Crofts 4 4 silver badges 12 12 bronze badges. Gilson Araujo Gilson Araujo 66 4 4 bronze badges. Chad Juliano Chad Juliano 1, 9 9 silver badges 3 3 bronze badges. Barth 8, 71 71 gold badges 48 48 silver badges 63 63 bronze badges. Chris Chris 1, 1 1 gold badge 10 10 silver badges 8 8 bronze badges.

I voted down this answer since it is very likely to cause problems for lots of people. An int column if defined as nullable has a set of values consisting of positive numbers, zero, negative numbers and NULL. At any point in time one can simply insert valid row of data containing this magic number and all of the sudden things will go bad.