Error: Invalid Column Index
462402Jan 16 2006 — edited Jan 20 2006Hi all.
I have a problem which started when I added a calculated attribute to my View Object. The VO is not based on an Entitty Object. The new attribute is the last one in the attribute sequence so, I do not expect the sequence to have gotten mixed up.
I tested the Business Components in the BC4J Tester and got this error:
(oracle.jbo.AttributeLoadException) JBO-27021: Failed to load CustomDatum value at index 49 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException.
----- LEVEL 1: DETAIL 0 -----
(java.sql.SQLException) Invalid column index
This is what happens when I run the application: The Invalid Column Index error happens when I access the page even if the calculated attribute is not displayed in the page. This is printed in the log window:
06/01/16 08:48:58 java.sql.SQLException: Invalid column index
06/01/16 08:48:58 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
06/01/16 08:48:58 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java)
06/01/16 08:48:58 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:239)
06/01/16 08:48:58 at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:641)
06/01/16 08:48:58 at oracle.jbo.domain.Number$1$facClass.createDatum(Number.java:103)
06/01/16 08:48:58 at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1085)
06/01/16 08:48:58 at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1525)
06/01/16 08:48:58 at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2205)
06/01/16 08:48:58 at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1031)
06/01/16 08:48:58 at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java)
06/01/16 08:48:58 at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2598)
06/01/16 08:48:58 at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:1871)
06/01/16 08:48:58 at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:1772)
06/01/16 08:48:58 at oracle.jbo.server.QueryCollection.get(QueryCollection.java:1256)
06/01/16 08:48:58 at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3203)
06/01/16 08:48:58 at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2755)
06/01/16 08:48:58 at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2610)
06/01/16 08:48:58 at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1424)
06/01/16 08:48:58 at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java)
06/01/16 08:48:58 at oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java)
06/01/16 08:48:58 at oracle.adf.model.binding.DCIteratorBinding.internalGetCurrentRowInBinding(DCIteratorBinding.java:1646)
06/01/16 08:48:58 at oracle.adf.model.binding.DCIteratorBinding.getCurrentRow(DCIteratorBinding.java:1605)
06/01/16 08:48:58 at oracle.adf.model.binding.DCControlBinding.getCurrentRow(DCControlBinding.java:368)
06/01/16 08:48:58 at oracle.jbo.uicli.binding.JUCtrlAttrsBinding.updateValuesFromRow(JUCtrlAttrsBinding.java:120)
06/01/16 08:48:58 at oracle.jbo.uicli.binding.JUIteratorBinding.updateValuesFromRows(JUIteratorBinding.java:308)
06/01/16 08:48:58 at oracle.adf.model.binding.DCIteratorBinding.refreshControl(DCIteratorBinding.java:682)
06/01/16 08:48:58 at oracle.adf.model.binding.DCBindingContainer.refreshControl(DCBindingContainer.java:1596)
06/01/16 08:48:58 at oracle.adf.controller.lifecycle.PageLifecycle.prepareModel(PageLifecycle.java:205)
06/01/16 08:48:58 at oracle.adf.controller.struts.actions.StrutsPageLifecycle.prepareModel(StrutsPageLifecycle.java:70)
06/01/16 08:48:58 at oracle.adf.controller.struts.actions.DataAction.prepareModel(DataAction.java:295)
06/01/16 08:48:58 at oracle.jheadstart.controller.strutsadf.action.JhsDataAction.prepareModel(JhsDataAction.java:3136)
06/01/16 08:48:58 at oracle.adf.controller.struts.actions.DataAction.prepareModel(DataAction.java:486)
06/01/16 08:48:58 at oracle.adf.controller.lifecycle.PageLifecycle.handleLifecycle(PageLifecycle.java:105)
06/01/16 08:48:58 at oracle.adf.controller.struts.actions.DataAction.handleLifecycle(DataAction.java:223)
06/01/16 08:48:58 at oracle.jheadstart.controller.strutsadf.action.JhsDataAction.handleLifecycle(JhsDataAction.java:389)
06/01/16 08:48:58 at oracle.adf.controller.struts.actions.DataAction.execute(DataAction.java:155)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
06/01/16 08:48:58 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1485)
06/01/16 08:48:58 at oracle.jheadstart.controller.strutsadf.JhsActionServlet.process(JhsActionServlet.java:127)
06/01/16 08:48:58 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:509)
06/01/16 08:48:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
06/01/16 08:48:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
06/01/16 08:48:58 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
06/01/16 08:48:58 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:222)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:1012)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:582)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:260)
06/01/16 08:48:58 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1485)
06/01/16 08:48:58 at oracle.jheadstart.controller.strutsadf.JhsActionServlet.process(JhsActionServlet.java:127)
06/01/16 08:48:58 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:509)
06/01/16 08:48:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
06/01/16 08:48:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
06/01/16 08:48:58 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
06/01/16 08:48:58 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:222)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:1012)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:582)
06/01/16 08:48:58 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:260)
06/01/16 08:48:58 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1485)
06/01/16 08:48:58 at oracle.jheadstart.controller.strutsadf.JhsActionServlet.process(JhsActionServlet.java:127)
06/01/16 08:48:58 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:509)
06/01/16 08:48:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
06/01/16 08:48:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
06/01/16 08:48:58 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
06/01/16 08:48:58 at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
06/01/16 08:48:58 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
06/01/16 08:48:58 at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:239)
06/01/16 08:48:58 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
06/01/16 08:48:58 at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:239)
06/01/16 08:48:58 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
06/01/16 08:48:58 at oracle.jheadstart.controller.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:172)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:659)
06/01/16 08:48:58 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
06/01/16 08:48:58 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
06/01/16 08:48:58 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:285)
06/01/16 08:48:58 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:126)
06/01/16 08:48:58 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
06/01/16 08:48:58 at java.lang.Thread.run(Thread.java:534)