Invalid column index : while updating & commiting a VO
638240Jul 27 2010 — edited Jul 29 2010I am running in to below exception (Caused by: java.sql.SQLException: Invalid column index) when i try to update a column in a row.
The code snippet lookis like...
VOImpl voImpl=getMyVOImpl();
voImpl.executeQuery();
while(voImpl.hasNext())
{
VOROWImpl voRow=voImpl.next();
voRow.setColumnData( someData);
}
getDBTransaction().commit();
Any help please
SEVERE: JBO-26041: Failed to post data to database during "Update": SQL Statement "BEGIN UPDATE SOME_TABLE SET.............; END;".
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:582)
at oracle.jbo.server.EntityImpl.doDMLWithLOBs(EntityImpl.java:8115)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8048)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6373)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3172)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2980)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2018)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2277)
at sni.bcs.locationupdate.model.services.BCSLocationUpdateServiceImpl.updateLatLong(BCSLocationUpdateServiceImpl.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at sni.foundation.bcextensions.internal.ApplicationModuleInvocationHandler.invoke(ApplicationModuleInvocationHandler.java:193)
at $Proxy0.updateLatLong(Unknown Source)
at sni.bcs.locationupdate.model.util.LocationLatLongUpdateUtil.runLocationLatLongUpdateUtil(LocationLatLongUpdateUtil.java:23)
at sni.bcs.locationupdate.model.util.LocationLatLongUpdateUtil.main(LocationLatLongUpdateUtil.java:18)
Caused by: java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:123)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:289)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:380)
at oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1568)
at oracle.jbo.server.OracleSQLBuilderImpl.bindUpdateStatement(OracleSQLBuilderImpl.java:2234)
at oracle.jbo.server.EntityImpl.bindDMLStatement(EntityImpl.java:9931)
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:412)
... 16 more
## Detail 0 ##
java.sql.SQLException: Invalid column index
Edited by: mchepuri on Jul 27, 2010 6:27 AM
Edited by: mchepuri on Jul 28, 2010 5:03 AM
Edited by: mchepuri on Jul 28, 2010 5:04 AM