java.sql.SQLSyntaxErrorException: ORA-00904: "HASH_VALUE": invalid identifier

Oracle Community | 801070 | 6 years ago
  1. 0

    cache.cluster.multicast.ip and Installing Oracle Identity Analytics

    Oracle Community | 6 years ago | 801070
    java.sql.SQLSyntaxErrorException: ORA-00904: "HASH_VALUE": invalid identifier
  2. 0

    using foreach to do batch insert with mybatis

    Stack Overflow | 1 year ago | wqzhou
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
  3. 0

    Invalid datatype while calling a procedure from java

    Stack Overflow | 3 years ago | user980956
    java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype</p> <pre><code>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while compiling Interface-ODI

    Oracle Community | 5 years ago | 907554
    java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword
  6. 0

    Issue with the upadted database Schema in ODI 11g ?

    Oracle Community | 3 years ago | 1004146
    java.sql.SQLSyntaxErrorException: ORA-00904: "COUNTRY": invalid identifier

  1. asdasd 2 times, last 3 months ago
  2. Justin 1 times, last 7 months ago
5 unregistered visitors
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.SQLSyntaxErrorException

    ORA-00904: "HASH_VALUE": invalid identifier

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    12. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    13 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.execute
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
    1 frame
  4. com.ibatis.sqlmap
    SqlMapSessionImpl.queryForObject
    1. com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
    2. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
    3. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
    4. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
    5. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
    6. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
    7. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
    8. com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
    8 frames
  5. Spring ORM
    SqlMapClientTemplate.execute
    1. org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273)
    2. org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
    2 frames