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

GitHub | PascalSchumacher | 3 months ago
  1. 0

    upgrading activiti engine schema from 6.0.0.beta2 to 6.0.0.beta3 fails on oracle

    GitHub | 3 months ago | PascalSchumacher
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  2. 0

    Error executing a Oracle query when connection is fetched from Datasource

    Oracle Community | 4 years ago | 992632
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  3. 0

    Hibernate - Unable to execute command

    Stack Overflow | 6 months ago | Maven Maverick
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [ create table Customer ( customer_id number(10,0) not null, customer_name varchar2(255 char), date varchar2(255 char), primary key (customer_id) )]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error executing a Oracle specific query when connection is fetched from Datasource

    Coderanch | 4 years ago | Rob Eddy
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  6. 0

    liquibase.exception.DatabaseException: ORA-00933: SQL command not properly ended

    Stack Overflow | 9 months ago | Lawson
    liquibase.exception.DatabaseException: Error executing SQL GRANT EXECUTE ON SPT_ADD_SI_EVENT_RECIPIENT TO PROJECT_SUPPORT_RW, APPSUPPORT_RW, PROJECT_ANALYST_RW, DB_DATASUPPORT_RW; : ORA-00933: SQL command not properly ended CODE: CREATE OR REPLACE PROCEDURE SPT_ADD_SI_EVENT_RECIPIENT (eventName IN VARCHAR2, emailAddresses IN VARCHAR2) IS nExists int; BEGIN select count(*) into nExists from SI_RECIPIENT where event = eventName; if nExists = 1 then UPDATE SI_RECIPIENT SET email = emailAddresses WHERE event = eventName; else INSERT INTO SI_RECIPIENT(event,email) VALUES (eventName,emailAddresses); end if; END SPT_ADD_SI_EVENT_RECIPIENT; / GRANT EXECUTE ON SPT_ADD_SI_EVENT_RECIPIENT TO PROJECT_SUPPORT_RW, APPSUPPORT_RW, PROJECT_ANALYST_RW, DB_DATASUPPORT_RW; LOG: [groovy] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:61)

    3 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: : invalid identifier

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      10. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      11. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      12. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)[ojdbc6-11.2.0.4.jar:11.2.0.3.0]
      12 frames
    3. HikariCP-java6
      HikariProxyStatement.execute
      1. com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)[HikariCP-2.4.7.jar:?]
      2. com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)[HikariCP-2.4.7.jar:?]
      2 frames
    4. Activiti - Engine
      CommandContextInterceptor.execute
      1. org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1213)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      2. org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1135)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      3. org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpgrade(DbSqlSession.java:1114)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      4. org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:944)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      5. org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1315)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      6. org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      7. org.activiti.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:38)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      8. org.activiti.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:79)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      9. org.activiti.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:58)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      10. org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:43)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      11. org.activiti.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:48)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      12. org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:63)[activiti-engine-6.0.0.Beta3.jar:6.0.0.Beta3]
      12 frames