Oracle doesnt have DATETIME datatype

Description

17:08:41.386 [main] ERROR - liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE MYPR.S_DB_GUNCE_KLT (ID INT NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED DATETIME, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_S_DB_GUNCE_KLT PRIMARY KEY (ID)); on jdbc:oracle:thin:@localhost:1521:XEINSERT INTO MYPR.S_DB_GUNCE_KLT (ID, LOCKED) VALUES (1, 0): ORA-00902: invalid datatype
o.h.e.jdbc.spi.SqlExceptionHelper
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) ~[liquibase-core-3.0.2.jar:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) ~[liquibase-core-3.0.2.jar:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64) ~[liquibase-core-3.0.2.jar:na]
at liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogLockTable(AbstractJdbcDatabase.java:778) ~[liquibase-core-3.0.2.jar:na]
at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:604) ~[liquibase-core-3.0.2.jar:na]
at liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640) ~[liquibase-core-3.0.2.jar:na]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype

Environment

Windows 8, Oracle Java 7_u25, Oracle 11XE

Reporter

HakanC

Components

Fix versions

Affects versions

Priority

Major
Configure