java.sql.SQLException: Invalid column index

Oracle Community | 709972 | 5 years ago
  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

    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
  3. 0

    Invalid column index

    GitHub | 4 years ago | rafael-alcantara
    java.sql.SQLException: Invalid column index
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    validating JTextField data from result set

    Stack Overflow | 4 years ago | Craig Hogan
    java.sql.SQLException: Invalid column index
  6. 0

    Invalid column index , update using PreparedStatement

    Stack Overflow | 5 years ago | invariant
    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