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

GitHub | PascalSchumacher | 7 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

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

    GitHub | 7 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 | 10 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

    I'm trying to use {{loadData}} to load a CLOB with over 4000 characters. I've attached a snippet of the changeset and the data I'm trying to load. Stacktrace: {{liquibase.exception.DatabaseException: java.sql.SQLSyntaxErrorException: ORA-01704: string literal too long at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:33) at org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask(AbstractLiquibaseUpdateMojo.java:24) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:369) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:132) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:208) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80) at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:120) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:355) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:155) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:584) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:216) at org.apache.maven.cli.MavenCli.main(MavenCli.java:160) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) Caused by: java.sql.SQLSyntaxErrorException: ORA-01704: string literal too long at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 32 more}}

    JIRA | 2 years ago | Edge Dalmacio
    liquibase.exception.DatabaseException: java.sql.SQLSyntaxErrorException: ORA-01704: string literal too long

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