I am using "com.ibm.db2.jcc.DB2Driver" to connect to DB2 Server. After executing a query I'm getting null as a resultSet. The query should return 0 records. I have checked it via a database client Aqua Data Studio.
As far as I know that resultSet shouldn't be null, anyway. Am I right??
ResultSets cannot be null when executed by the database, except when they are wrapped in a method as above where any failure in the method fsexecuteQuery will return a null ResultSet.
Originally posted by David O'Meara: ResultSets cannot be null when executed by the database
Know that quite well.
except when they are wrapped in a method as above where any failure in the method fsexecuteQuery will return a null ResultSet.
Cent percent valid point.
It was my carelessness. I didn't tried hard to figure it out. Legacy code screws most of the time.
Actually it was faced by one of my colleague and I posted the question. When Shailesh asked for code, then I realized that mistake is somewhere inside that method.