liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:derby://localhost:1527/emconex;create=trueINSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE): Syntax error: BOOLEAN.

JIRA | Phil Denis | 5 years ago
  1. 0

    When using Derby as the target database, liquibase fails to create the DatabaseChangeLog table. liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:derby://localhost:1527/emconex;create=trueINSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE): Syntax error: BOOLEAN. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70) at liquibase.database.AbstractDatabase.checkDatabaseChangeLogLockTable(AbstractDatabase.java:564) at liquibase.lockservice.LockService.acquireLock(LockService.java:94) ... 116 more Caused by: java.sql.SQLSyntaxErrorException: Syntax error: BOOLEAN. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Statement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 120 more Caused by: org.apache.derby.client.am.SqlException: Syntax error: BOOLEAN. at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source) at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source) at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source) at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source) at org.apache.derby.client.am.Statement.flowExecute(Unknown Source) at org.apache.derby.client.am.Statement.executeX(Unknown Source) ... 125 more

    JIRA | 5 years ago | Phil Denis
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:derby://localhost:1527/emconex;create=trueINSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE): Syntax error: BOOLEAN.
  2. 0

    When using Derby as the target database, liquibase fails to create the DatabaseChangeLog table. liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:derby://localhost:1527/emconex;create=trueINSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE): Syntax error: BOOLEAN. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70) at liquibase.database.AbstractDatabase.checkDatabaseChangeLogLockTable(AbstractDatabase.java:564) at liquibase.lockservice.LockService.acquireLock(LockService.java:94) ... 116 more Caused by: java.sql.SQLSyntaxErrorException: Syntax error: BOOLEAN. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Statement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 120 more Caused by: org.apache.derby.client.am.SqlException: Syntax error: BOOLEAN. at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source) at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source) at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source) at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source) at org.apache.derby.client.am.Statement.flowExecute(Unknown Source) at org.apache.derby.client.am.Statement.executeX(Unknown Source) ... 125 more

    JIRA | 5 years ago | Phil Denis
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:derby://localhost:1527/emconex;create=trueINSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE): Syntax error: BOOLEAN.
  3. 0

    Migration's parser is causing causing false syntax error on certain comments

    GitHub | 2 years ago | GoogleCodeExporter
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered ";" at line 1, column 51.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 216#76674645

    GitHub | 2 years ago | aojava
    javax.ejb.EJBException: javax.ejb.CreateException: Initialization failed for Singleton PrepareDatabase
  6. 0

    Apache Derby Users - importing

    nabble.com | 1 year ago
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "/" at line 1, column 53.

    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. org.apache.derby.client.am.SqlException

      Syntax error: BOOLEAN.

      at org.apache.derby.client.am.Statement.completeSqlca()
    2. Apache Derby Client JDBC Driver
      Statement.execute
      1. org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
      2. org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
      3. org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
      4. org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
      5. org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
      6. org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
      7. org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
      8. org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
      9. org.apache.derby.client.am.Statement.executeX(Unknown Source)
      10. org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      11. org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      12. org.apache.derby.client.am.Statement.execute(Unknown Source)
      12 frames
    3. Commons DBCP
      DelegatingStatement.execute
      1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2 frames
    4. Liquibase Core
      LockService.acquireLock
      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:62)
      4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
      5. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70)
      6. liquibase.database.AbstractDatabase.checkDatabaseChangeLogLockTable(AbstractDatabase.java:564)
      7. liquibase.lockservice.LockService.acquireLock(LockService.java:94)
      7 frames