Getting Issue when Liquibase trying to execute Oracle query

General Discussion
1

Hi Team,

Our application having following technologies,
Grails 1.3.7, Oracle XE, Database-migration-1.0 plugin and Liquibase 2.0.1.
In this application we are using Database-migration-1.0 plugin which uses Liquibase 2.0.1 library to manage DB changes.

Here DB changes are done in separate changelog files(eg., r18-base.groovy, r18-to-r19-baseline.groovy, R19-add-contractToSite.groovy) and these files are incorporated into a root file(changelog.groovy).

When we are updating the DB using grails dbm-update command, Liquibase trying to execute queries in the change log files.

There we are getting the error as,

 

2012-04-09 16:03:45,939 [main] ERROR liquibase  - Change Set r18-base.groovy::1332771601628-1::asidua (generated) failed.

Error: Error executing SQL CREATE TABLE ADMINISTRATION (ID VARCHAR2(255 BYTE) NOT NULL, VERSION NUMBER(19,0) NOT NULL, NAME VARCHAR2(255 BYTE) NOT NULL, “VALUE” VARCHAR2(255 BYTE) NOT NULL, CONSTRAINT SYS_C0090814 PRIMARY KEY (ID)):

Wrong data type: VARCHAR2 in statement [CREATE TABLE ADMINISTRATION (ID VARCHAR2]

 

liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADMINISTRATION (ID VARCHAR2(255 BYTE) NOT NULL, VERSION NUMBER(19,0) NOT NULL, NAME VARCHAR2(255 BYTE) NOT NULL, “VALUE” VARCHAR2(255 BYTE) NOT NULL, CONSTRAINT SYS_C0090814 PRIMARY KEY (ID)):

Wrong data type: VARCHAR2 in statement [CREATE TABLE ADMINISTRATION (ID VARCHAR2]

 
Could you please clarify this issue?

Regards,
Raja

2

The sql seems right for oracle off hand. Do you get a more helpful error message if you run the sql through an oracle sql tool?


<span VARCHAR2(255 BYTE) NOT NULL, CONSTRAINT SYS_C0090814 PRIMARY KEY (ID))

Nathan