java.sql.SQLException: ORA-00933: SQL command not properly ended

JIRA | JC | 5 years ago
  1. 0

    Using formatted SQL and Oracle 10g, when executing a COMMENT on a COLUMN which includes two dashes (--), it throws "ORA-00933: SQL command not properly ended" error Example: COMMENT ON COLUMN MYTABLE.STATUS IS 'status--> p , e, i'; D:\project>install.bat INFO 17/06/11 10:49 AM:liquibase: Successfully acquired change log lock INFO 17/06/11 10:49 AM:liquibase: install.xml is using schema version 1.9 rather than version 2.0 INFO 17/06/11 10:49 AM:liquibase: Reading from DATABASECHANGELOG INFO 17/06/11 10:49 AM:liquibase: Reading from DATABASECHANGELOG SEVERE 17/06/11 10:57 AM:liquibase: Error executing SQL COMMENT ON COLUMN MYTABLE.STATUS IS 'status COMMENT ON COLUMN MYTABLE.CLIENT_ID IS 'CLIENT ID' java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :113) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1192) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja va:1731) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta tement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:101 4) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas e.java:998) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27 ) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.integration.commandline.Main.doMigration(Main.java:684) at liquibase.integration.commandline.Main.main(Main.java:116)

    JIRA | 5 years ago | JC
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  2. 0

    Using formatted SQL and Oracle 10g, when executing a COMMENT on a COLUMN which includes two dashes (--), it throws "ORA-00933: SQL command not properly ended" error Example: COMMENT ON COLUMN MYTABLE.STATUS IS 'status--> p , e, i'; D:\project>install.bat INFO 17/06/11 10:49 AM:liquibase: Successfully acquired change log lock INFO 17/06/11 10:49 AM:liquibase: install.xml is using schema version 1.9 rather than version 2.0 INFO 17/06/11 10:49 AM:liquibase: Reading from DATABASECHANGELOG INFO 17/06/11 10:49 AM:liquibase: Reading from DATABASECHANGELOG SEVERE 17/06/11 10:57 AM:liquibase: Error executing SQL COMMENT ON COLUMN MYTABLE.STATUS IS 'status COMMENT ON COLUMN MYTABLE.CLIENT_ID IS 'CLIENT ID' java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :113) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1192) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja va:1731) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta tement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:101 4) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas e.java:998) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27 ) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.integration.commandline.Main.doMigration(Main.java:684) at liquibase.integration.commandline.Main.main(Main.java:116)

    JIRA | 5 years ago | JC
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  3. 0

    Example SQL: COMMENT ON COLUMN MYTABLE.TYPE IS 'Type of client. Location = L; Velocity = V; LINK = E.'; D:\projects>install.bat INFO 17/06/11 12:48 PM:liquibase: Successfully acquired change log lock INFO 17/06/11 12:48 PM:liquibase: install.xml is using schema version 1.9 rather than version 2.0 INFO 17/06/11 12:48 PM:liquibase: Reading from DATABASECHANGELOG INFO 17/06/11 12:48 PM:liquibase: Reading from DATABASECHANGELOG SEVERE 17/06/11 12:55 PM:liquibase: Error executing SQL COMMENT ON COLUMN MYTABLE.TYPE IS 'Type of client. Location = L; java.sql.SQLException: ORA-01756: quoted string not properly terminated at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :113) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1192) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja va:1731) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta tement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:101 4) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas e.java:998) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27 ) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.integration.commandline.Main.doMigration(Main.java:684) at liquibase.integration.commandline.Main.main(Main.java:116)

    JIRA | 5 years ago | JC
    java.sql.SQLException: ORA-01756: quoted string not properly terminated
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Example SQL: COMMENT ON COLUMN MYTABLE.TYPE IS 'Type of client. Location = L; Velocity = V; LINK = E.'; D:\projects>install.bat INFO 17/06/11 12:48 PM:liquibase: Successfully acquired change log lock INFO 17/06/11 12:48 PM:liquibase: install.xml is using schema version 1.9 rather than version 2.0 INFO 17/06/11 12:48 PM:liquibase: Reading from DATABASECHANGELOG INFO 17/06/11 12:48 PM:liquibase: Reading from DATABASECHANGELOG SEVERE 17/06/11 12:55 PM:liquibase: Error executing SQL COMMENT ON COLUMN MYTABLE.TYPE IS 'Type of client. Location = L; java.sql.SQLException: ORA-01756: quoted string not properly terminated at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :113) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1192) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja va:1731) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta tement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:101 4) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas e.java:998) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27 ) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.integration.commandline.Main.doMigration(Main.java:684) at liquibase.integration.commandline.Main.main(Main.java:116)

    JIRA | 5 years ago | JC
    java.sql.SQLException: ORA-01756: quoted string not properly terminated
  6. 0

    ORA-00933: SQL command not properly ended

    Oracle Community | 9 years ago | 133792
    java.sql.SQLException: ORA-00933: SQL command not properly ended

    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

      ORA-00933: SQL command not properly ended

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.execute
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
      6. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192)
      8. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1731)
      9. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701)
      9 frames
    3. Liquibase Core
      Main.main
      1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
      3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105)
      4. liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1014)
      5. liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:998)
      6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
      7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
      8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
      9. liquibase.Liquibase.update(Liquibase.java:113)
      10. liquibase.integration.commandline.Main.doMigration(Main.java:684)
      11. liquibase.integration.commandline.Main.main(Main.java:116)
      11 frames