liquibase.exception.DatabaseException: java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by adam-ho
, 1 year ago
Table "COUNTRY" not found; SQL statement: ALTER TABLE PUBLIC.location ADD CONSTRAINT fk_location_country_id FOREIGN KEY (country_id) REFERENCES PUBLIC.country (id) [42102-191] [Failed SQL: ALTER TABLE PUBLIC.location ADD CONSTRAINT fk_location_country_id FOREIGN KEY (country_id) REFERENCES PUBLIC.country (id)]
via Stack Overflow by fillg1
, 2 years ago
ORA-00984: column not allowed here [Failed SQL: CREATE TABLE VPP_OWNER.JHI_USER (id NUMBER(38, 0) DEFAULT SEQ_USER.NEXTVAL NOT NULL, login VARCHAR2(50) NOT NULL, "PASSWORD" VARCHAR2(60), first_n ame VARCHAR2(50), last_name VARCHAR2(50), email
via JIRA by Georgi Georgiev, 1 year ago
ERROR: syntax error at or near "0" Position: 385 [Failed SQL: CREATE TABLE reporting.report (id BIGSERIAL NOT
via JIRA by Georgi Georgiev, 1 year ago
ERROR: syntax error at or near "0" Position: 385 [Failed SQL: CREATE TABLE reporting.report (id BIGSERIAL NOT
liquibase.exception.DatabaseException: java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.
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:1221)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1204)

Users with the same issue

Once, 1 year ago
13 times, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.