I am trying to create Item Reader, Item Processor and Item Writer in Java EE 7 batch in Weblogic 12.2.2. My Item Reader should fetch the data from the database and Processor should consume the data.
For this, i have defined PreparedStatement, ResultSet as a instance variable in Reader. In Open method inside reader, i am fetching the data from database and setting the resultset. In readItem method, i am trying to do resultset.next but there i am getting exception that Resultset is already closed.
Upon debugging, i found that Resultset as well as Prepared Statement both are closed. Because of this i am not able to access the resultset in readItem() method.
Please help, why Prepared Statement and Resultset is getting closed automatically.
Some code can help. How you setup the PreparedStatement and ResultSet.
K. Tsang CEng MBCS PMP PMI-ACP OCPJEA OCPJP
posted 4 years ago
Connection , Prepared Statement and Result set i have defined as instance variable. And in open method, i am preparing statement and querying the database. This will set the value of resultset (instance Variable).
Now in readItem i am trying to read the resultset and getting "Resultset is closed" exception.
Now able to understand, Why resultset in getting closed.