liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.

JIRA | Brian Preuß | 5 years ago
  1. 0

    <changeSet author="brian.preuss" id="1"> <createTable tableName="ADDRESSEES_AUD"> <column name="ID" type="BIGINT"> <constraints nullable="false"/> </column> <column name="REV" type="INT"> <constraints nullable="false"/> </column> <column name="REVTYPE" type="TINYINT"/> <column name="EMAIL" type="VARCHAR(1000)"/> <column name="NAME" type="VARCHAR(50)"/> </changeSet> liquibase.exception.MigrationFailedException: Migration failed for change set /changelog/db.changelog-0.2.xml::1::brian.preuss: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) 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.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:231) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) ... 76 more Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) 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) ... 82 more Caused by: java.sql.SQLSyntaxErrorException: TYPE 'TINYINT' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.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) ... 86 more Caused by: java.sql.SQLException: TYPE 'TINYINT' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 98 more Caused by: ERROR 42X94: TYPE 'TINYINT' does not exist. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.QueryTreeNode.bindUserType(Unknown Source) at org.apache.derby.impl.sql.compile.ColumnDefinitionNode.checkUserType(Unknown Source) at org.apache.derby.impl.sql.compile.TableElementList.validate(Unknown Source) at org.apache.derby.impl.sql.compile.CreateTableNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 92 more ... Removed 28 stack frames

    JIRA | 5 years ago | Brian Preuß
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.
  2. 0

    <changeSet author="brian.preuss" id="1"> <createTable tableName="ADDRESSEES_AUD"> <column name="ID" type="BIGINT"> <constraints nullable="false"/> </column> <column name="REV" type="INT"> <constraints nullable="false"/> </column> <column name="REVTYPE" type="TINYINT"/> <column name="EMAIL" type="VARCHAR(1000)"/> <column name="NAME" type="VARCHAR(50)"/> </changeSet> liquibase.exception.MigrationFailedException: Migration failed for change set /changelog/db.changelog-0.2.xml::1::brian.preuss: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) 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.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:231) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) ... 76 more Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) 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) ... 82 more Caused by: java.sql.SQLSyntaxErrorException: TYPE 'TINYINT' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.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) ... 86 more Caused by: java.sql.SQLException: TYPE 'TINYINT' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 98 more Caused by: ERROR 42X94: TYPE 'TINYINT' does not exist. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.QueryTreeNode.bindUserType(Unknown Source) at org.apache.derby.impl.sql.compile.ColumnDefinitionNode.checkUserType(Unknown Source) at org.apache.derby.impl.sql.compile.TableElementList.validate(Unknown Source) at org.apache.derby.impl.sql.compile.CreateTableNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 92 more ... Removed 28 stack frames

    JIRA | 5 years ago | Brian Preuß
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: Error executing SQL CREATE TABLE ADDRESSEES_AUD (ID BIGINT NOT NULL, REV INT NOT NULL, REVTYPE TINYINT, EMAIL VARCHAR(1000), NAME VARCHAR(50)): TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.: Caused By: TYPE 'TINYINT' does not exist.
  3. 0

    Java and Derby - Database will not save?

    Stack Overflow | 5 years ago | user842479
    java.sql.SQLSyntaxErrorException: Schema 'USERNAME' does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I am trying to create a table using java derby EmbeddedDriver but i don't understand what these errors mean?

    Stack Overflow | 3 years ago | user3378922
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "user" at line 1, column 14.
  6. 0

    derby clob exception using an SQL select statement or suggest me another derby data type with no length setting

    Stack Overflow | 3 years ago | Damjan Dimitrioski
    java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')

  1. davidvanlaatum 4 times, last 1 week ago
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

    TYPE 'TINYINT' does not exist.

    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException()
  2. Derby
    EmbedStatement.execute
    1. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    2. org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
    3. org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    4. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    5. org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    6. org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    7. org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    8. org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    9. org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
    10. org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
    10 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
    SpringLiquibase.afterPropertiesSet
    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:105)
    5. liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1014)
    6. liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:998)
    7. liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
    8. liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
    9. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
    10. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
    11. liquibase.Liquibase.update(Liquibase.java:113)
    12. liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:231)
    12 frames
  5. Spring Beans
    AbstractAutowireCapableBeanFactory.initializeBean
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
    2 frames