java.sql.SQLException: Invalid column index

Oracle Community | 709972 | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    How to use DB queries inside a schedule task - OIM

    Oracle Community | 5 years ago | 709972
    java.sql.SQLException: Invalid column index
  2. 0

    Create weblogic user and assign roles from database to weblogic server

    Stack Overflow | 1 month ago | 5extremers
    java.sql.SQLException: Invalid column index
  3. 0

    Delegated Access quartz job is unable to complete execution due to special characters contained in the site's property value. {quote} 2014-11-12 16:31:13,017 ERROR QuartzScheduler_Worker-4 org.sakaiproject.delegatedaccess.dao.impl.DelegatedAccessDaoImpl - Error executing query: class org.springframework.jdbc.InvalidResultSetAccessException:PreparedStatementCallback; invalid ResultSet access for SQL [Select ID, title From HIERARCHY_NODE_META where title in ('BIE-B'`ioethics') and hierarchyId = ? and isDisabled = 0]; nested exception is java.sql.SQLException: Invalid column index org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; invalid ResultSet access for SQL [Select ID, title From HIERARCHY_NODE_META where title in ('BIE-B'`ioethics') and hierarchyId = ? and isDisabled = 0]; nested exception is java.sql.SQLException: Invalid column index at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:224) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710) at org.sakaiproject.delegatedaccess.dao.impl.DelegatedAccessDaoImpl.getNodesBySiteRef(DelegatedAccessDaoImpl.java:137) at org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.checkAndAddNode(DelegatedAccessSiteHierarchyJob.java:217) at org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.execute(DelegatedAccessSiteHierarchyJob.java:144) at org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper.execute(SpringJobBeanWrapper.java:70) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534) Caused by: java.sql.SQLException: Invalid column index at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5321) at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5309) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:280) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:132) at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:335) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:217) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:145) at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:51) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) ... 10 more {quote} Steps to reproduce: 1. Edit site properties that are used by Hierarchy tool. For example, change the value of Subject to People's Right. Note the single quote in the text 2. now execute the Delegated Access job and check log.

    Sakai JIRA | 2 years ago | Yi Zhu
    org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; invalid ResultSet access for SQL [Select ID, title From HIERARCHY_NODE_META where title in ('BIE-B'`ioethics') and hierarchyId = ? and isDisabled = 0]; nested exception is java.sql.SQLException: Invalid column index
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid column index

    GitHub | 4 years ago | rafael-alcantara
    java.sql.SQLException: Invalid column index

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid column index

      at oracle.jdbc.driver.SQLStateMapping.newSQLException()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setString
      1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
      2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
      3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
      4. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
      5. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
      6. oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5007)
      7. oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:4997)
      8. oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:277)
      8 frames
    3. weblogic.jdbc.wrapper
      PreparedStatement.setString
      1. weblogic.jdbc.wrapper.PreparedStatement.setString(PreparedStatement.java:745)
      1 frame
    4. com.thortech.xl
      tcDataBase_vhi04i_EOImpl.writePreparedStatement
      1. com.thortech.xl.dataaccess.tcDataBase.writePreparedStatement(Unknown Source)
      2. com.thortech.xl.dataaccess.tcDataBase.writePreparedStatement(Unknown Source)
      3. com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.writePreparedStatement(Unknown Source)
      4. com.thortech.xl.ejb.beans.tcDataBase_vhi04i_EOImpl.writePreparedStatement(tcDataBase_vhi04i_EOImpl.java:4280)
      4 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    6. Thor.API.Base
      SecurityInvocationHandler$1.run
      1. Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source)
      1 frame
    7. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    8. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
      1 frame
    9. weblogic.security
      Security.runAs
      1. weblogic.security.Security.runAs(Security.java:41)
      1 frame
    10. Thor.API.Security
      weblogicLoginSession.runAs
      1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source)
      1 frame
    11. Thor.API.Base
      SecurityInvocationHandler.invoke
      1. Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source)
      1 frame
    12. Unknown
      $Proxy59.writePreparedStatement
      1. $Proxy59.writePreparedStatement(Unknown Source)
      1 frame
    13. com.thortech.xl
      PreparedStatementUtil.executeUpdate
      1. com.thortech.xl.dataaccess.tcDataBaseClient.writePreparedStatement(Unknown Source)
      2. com.thortech.xl.dataobj.PreparedStatementUtil.executeUpdate(Unknown Source)
      2 frames
    14. com.test
      TestUtility.execute
      1. com.test.TestUtility.createUDF(TestUtility)
      2. com.test.TestUtility.execute(TestUtility)
      2 frames
    15. com.thortech.xl
      QuartzWrapper$TaskExecutionAction.run
      1. com.thortech.xl.scheduler.tasks.SchedulerBaseTask.run(Unknown Source)
      2. com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run(Unknown Source)
      2 frames
    16. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    17. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
      1 frame
    18. weblogic.security
      Security.runAs
      1. weblogic.security.Security.runAs(Security.java:41)
      1 frame
    19. Thor.API.Security
      weblogicLoginSession.runAs
      1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source)
      1 frame
    20. com.thortech.xl
      QuartzWrapper.execute
      1. com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
      1 frame
    21. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:178)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:477)
      2 frames