java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by JC,
  • 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)
    via by JC,
  • 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)
    via by JC,
  • 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)
    via by JC,
  • SSO Configuration Assistant failed
    via by user12010880,
  • JDBC connect string and Oracle synonyms
    via Stack Overflow by javaExpert
    ,
    • 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(OracleStatement.java:1192) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1731) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(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:1014) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.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)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    76 more bugmates