liquibase.exception.DatabaseException

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.

  • <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
    via by Brian Preuß,
  • <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
    via by Brian Preuß,
  • Java and Derby - Database will not save?
    via Stack Overflow by user842479
    ,
  • Hi I tried to display Aquilon CT Images but without success this the stack trace: There is a message on the forum connected to this problem: http://forums.dcm4che.org/jiveforums/thread.jspa?threadID=3120 java.sql.SQLSyntaxErrorException: The number of values assigned is not the same as the number of specified or implied columns. 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 in.raster.mayam.util.database.DatabaseHandler.insertImageData(DatabaseHandler.java:989) at in.raster.mayam.util.database.DatabaseHandler.importDataToDatabase(DatabaseHandler.java:811) at in.raster.mayam.delegate.ImportDelegate.readAndImportDicomFile(ImportDelegate.java:156) at in.raster.mayam.delegate.ImportDelegate.readFileAndUpdateDB(ImportDelegate.java:184) at in.raster.mayam.delegate.ImportDelegate.run(ImportDelegate.java:94) Caused by: java.sql.SQLException: The number of values assigned is not the same as the number of specified or implied columns. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 13 more Exception in thread "AWT-EventQueue-0" java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.RangeCheck(ArrayList.java:547) at java.util.ArrayList.get(ArrayList.java:322) at in.raster.mayam.form.MainScreen.viewerButtonActionPerformed(MainScreen.java:845) at in.raster.mayam.form.MainScreen.access$800(MainScreen.java:88) at in.raster.mayam.form.MainScreen$9.actionPerformed(MainScreen.java:524) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:273) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6267) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6032) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Exception in thread "Thread-3" java.lang.NullPointerException at in.raster.mayam.delegate.ShowViewerDelegate.setSelectedImagePanel(ShowViewerDelegate.java:119) at in.raster.mayam.delegate.ShowViewerDelegate.showViewer(ShowViewerDelegate.java:102) at in.raster.mayam.delegate.ShowViewerDelegate.run(ShowViewerDelegate.java:77) Paolo
    via by Paolo Marcheschi,
  • java.sql.SQLException | ERROR 07000
    via by silverhair76,
    • 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) 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) ... 7 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) ... 12 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) ... 24 more

    Users with the same issue

    jf-ast
    1 times, last one,
    stigkj
    1 times, last one,
    andyglick
    1 times, last one,
    davidvanlaatum
    1 times, last one,
    muffinmannen
    81 times, last one,
    1 more bugmates