# Liquibase update problem

**URL:** <https://forum.liquibase.org/t/liquibase-update-problem/1574>\
**Category:** General Discussion\
**Created:** [July 26, 2011, 8:59pm UTC](https://forum.liquibase.org/t/liquibase-update-problem/1574 "2011-07-26T20:59:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [July 26, 2011, 8:59pm UTC](https://forum.liquibase.org/t/liquibase-update-problem/1574/1 "2011-07-26T20:59:00Z")

</div>

Hi.  
  
I was trying to migrate my database structure from Oracle to derby using liquibase and i am finding some problems following theese steps:  
  
1)First of all i have generated my db schema and saved to my file schema.xml.  
  
2)The i tried to save the schema to a derby db with update parameter and changing liquibase.properties file but i couldn’t due column type incompatibility (The create tables sqls have varchar2, number fields, etc… that don’t exist in derby ).   
¿Is it possible to migrate this way?   
  
3)Like i couldn’t continue i replaced&nbsp; incompatibles oracle fields in file schema.xml with derby fields.  
When I changed all the incompatible fields y relaunched the update into my derby database the process crashed again:  
  
INFO 26/07/11 15:40:liquibase: Creating database history table with name: DATABASECHANGELOG  
INFO 26/07/11 15:40:liquibase: Reading from DATABASECHANGELOG  
INFO 26/07/11 15:40:liquibase: Reading from DATABASECHANGELOG  
SEVERE 26/07/11 15:40:liquibase: Error executing SQL CREATE TABLE STATE\_CFG (field1 VARCHAR(2) NOT NULL, field2 NUMBER(1,0) NOT NULL, NAME VARCHAR(24), ABR VARCHAR(4))  
java.sql.SQLSyntaxErrorException: Syntax error: Encountered “NUMBER” at line 1, column 69.  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1014)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:998)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.Liquibase.update(Liquibase.java:113)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.integration.commandline.Main.doMigration(Main.java:684)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.integration.commandline.Main.main(Main.java:116)  
Caused by: java.sql.SQLException: Syntax error: Encountered “NUMBER” at line 1, column 69.  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 19 more  
Caused by: ERROR 42X01: Syntax error: Encountered “NUMBER” at line 1, column 69.  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 13 more  
  
  
¿Why the process is trying to insert a   
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;