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

GitHub | PascalSchumacher | 5 months ago
  1. 0

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

    GitHub | 5 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 | 8 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 | 11 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)

  1. jpvee 2 times, last 3 weeks ago
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