java.sql.SQLException

[IBM][JDBC Driver] CLI0627E The result set is not scrollable.


Solutions on the web13644

Solution icon of oraclecommunity
via Oracle Community by 843830, 1 year ago
[IBM][JDBC Driver] CLI0627E The result set is not scrollable.

Solution icon of oraclecommunity
via Oracle Community by 3004, 1 year ago
[IBM][JDBC Driver] CLI0627E The result set is not scrollable.

Solution icon of oraclecommunity
via Oracle Community by 843859, 8 months ago
[IBM][JDBC Driver] CLI0627E The result set is not scrollable. 6900690 SystemErr R

Solution icon of googlegroups
via Google Groups by John, 1 year ago
[IBM][JDBC Driver] CLI0626E Updatable result set is not supported in this version of DB2 JDBC 2.0 driver.

Solution icon of stackoverflow
[IBM][JDBC Driver] CLI0626E getDatabaseMajorVersion is not supported in this version of DB2 JDBC 2.0 driver.

Solution icon of stackoverflow
[IBM][JDBC Driver] CLI0626E getDatabaseMajorVersion is not supported in this version of DB2 JDBC 2.0 driver.

Solution icon of googlegroups
via Google Groups by Dinesh Sanghvi, 2 weeks ago
The result set type is not supported.

Solution icon of stackoverflow
The result set type is not supported.

Solution icon of oraclecommunity
via Oracle Community by 843854, 9 months ago
The result set type is not supported.

Solution icon of oraclecommunity
via Oracle Community by 843854, 1 year ago
The result set type is not supported.

Stack trace

  • java.sql.SQLException: [IBM][JDBC Driver] CLI0627E The result set is not scrollable. at kodo.jdbc.sql.SQLExceptions.getDataStore(SQLExceptions.java:63) at kodo.jdbc.sql.SQLExceptions.getDataStore(SQLExceptions.java:51) at kodo.jdbc.runtime.AbstractSelectResultObjectProvider.handleCheckedException(AbstractSelectResultObjectProvider.java:150) at com.solarmetric.rop.WindowResultList.getInternal(WindowResultList.java:165) at com.solarmetric.rop.AbstractNonSequentialResultList.get(AbstractNonSequentialResultList.java:59) at com.verafin.component.user.model.UserManager.getUsers(UnknownSource) at com.verafin.component.user.web.controller.SearchUsersAction._execute(UnknownSource) at com.verafin.core.web.controller.DefaultAction.execute(UnknownSource) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:480) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:502) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: [IBM][JDBC Driver] CLI0627E The result set is not scrollable. at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throwNotScrollable(UnknownSource) at COM.ibm.db2.jdbc.net.DB2ResultSet.absolute(Unknown Source) at com.solarmetric.jdbc.DelegatingResultSet.absolute(DelegatingResultSet.java:481) at kodo.jdbc.sql.ResultSetResult.absolute(ResultSetResult.java:136) at kodo.jdbc.sql.SelectResult.absolute(SelectResult.java:51) at kodo.jdbc.runtime.AbstractSelectResultObjectProvider.absolute(AbstractSelectResultObjectProvider.java:98) at com.solarmetric.rop.WindowResultList.getInternal(WindowResultList.java:124) ... 39 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.