You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a webapp I am migrating from weblogic to tomcat.I have the app deployed on the Tomcat, after adding the EclipseLink jars.
The JPA entities and the Database queries that get the result set work perfectly fine.
But I have few queries that invoke Oracle DB functions which return REF CURSORS. I am running into the below exception in such cases.
java.sql.SQLException: Closed Resultset: next
at oracle.jdbc.driver.InsensitiveScrollableResultSet.ensureOpen(InsensitiveScrollableResultSet.java:112)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:400)
Code snippet that is failing.
Query query = em.createNativeQuery("SELECT rse_parameter_calc.get_run_type_overview() from dual");
rs_lst =query.getResultList();
rs = rs_lst.get(0);
}
while (rs.next()) --> The code fails here.
The same code works perfectly fine weblogic.
I am using the same ojdb8 drivers in both the servers .Any pointers would be helpful
Tried with both the versions: EclipseLink 2.6 , EclipseLink 2.7.13
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have a webapp I am migrating from weblogic to tomcat.I have the app deployed on the Tomcat, after adding the EclipseLink jars.
The JPA entities and the Database queries that get the result set work perfectly fine.
But I have few queries that invoke Oracle DB functions which return REF CURSORS. I am running into the below exception in such cases.
java.sql.SQLException: Closed Resultset: next
at oracle.jdbc.driver.InsensitiveScrollableResultSet.ensureOpen(InsensitiveScrollableResultSet.java:112)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:400)
Code snippet that is failing.
Query query = em.createNativeQuery("SELECT rse_parameter_calc.get_run_type_overview() from dual");
rs_lst =query.getResultList();
rs = rs_lst.get(0);
}
while (rs.next()) --> The code fails here.
The same code works perfectly fine weblogic.
I am using the same ojdb8 drivers in both the servers .Any pointers would be helpful
Tried with both the versions: EclipseLink 2.6 , EclipseLink 2.7.13
Beta Was this translation helpful? Give feedback.
All reactions