liquibase.exception.DatabaseException: A syntax error has occurred. [Failed SQL: CREATE TABLE jxclean351:ngp.country_type (id INT8 NOT NULL, value VARCHAR(100(100) NOT NULL)]

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 JIRA by Lyle H. Gray, 1 year ago
A syntax error has occurred. [Failed SQL: CREATE TABLE jxclean351:ngp.country_type (id INT8 NOT NULL, value VARCHAR(100(100) NOT NULL)]
via JIRA by Lyle H. Gray, 1 year ago
Primary key already exists on the table. [Failed SQL: ALTER TABLE jxclean351:ngp.military_service ADD CONSTRAINT PRIMARY KEY (id) CONSTRAINT pk_military_service]
via JIRA by Lyle H. Gray, 1 year ago
Index (idx_mil_country_type_id) already exists in database. [Failed SQL: CREATE INDEX jxclean351:ngp.idx_mil_country_type_id ON jxclean351:ngp.military_service(country_type_id)]
via Stack Overflow by Bohdan Olehovich
, 2 years ago
Table 'database.batch_job_execution' doesn't exist [Failed SQL: CREATE INDEX JOB_START_STATUS ON database.batch_job_execution(STATUS, START_TIME)]
via Stack Overflow by Ray Chen
, 1 year ago
ORA-02275: such a referential constraint already exists in the table [Failed SQL: ALTER TABLE CRDM_RCHEN.SOME_TABLE ADD CONSTRAINT SOME_TABLE_FK FOREIGN KEY (COLUMN_2) REFERENCES CRDM_RCHEN.SOME_OTHER_TABLE (COLUMN_1)]
via GitHub by brianhatchl
, 1 year ago
Error executing SQL DROP TYPE IF EXISTS nwr_enum: ERROR: cannot drop type nwr_enum because other objects depend on it Detail: table current_relation_members column member_type depends on type nwr_enum Hint: Use DROP ... CASCADE to drop the dependent objects too.
liquibase.exception.DatabaseException: A syntax error has occurred. [Failed SQL: CREATE TABLE jxclean351:ngp.country_type (id INT8 NOT NULL, value VARCHAR(100(100) NOT NULL)]
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3982)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2698)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2614)
at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2491)
at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2466)
at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:394)
at com.informix.jdbc.IfxStatement.a(IfxStatement.java:1333)
at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1303)
at com.informix.jdbc.IfxStatement.c(IfxStatement.java:1007)
at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:893)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
at liquibase.Liquibase.update(Liquibase.java:214)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.integration.commandline.Main.doMigration(Main.java:1126)
at liquibase.integration.commandline.Main.run(Main.java:184)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
5 more bugmates

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