Oracle support

[smil2k]

Hi,

You can try oracle support using Oracle XE under this page: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

It is free of charge.

It runs in docker also, makes installation much easier: https://hub.docker.com/r/wnameless/oracle-xe-11g/

Cheers,

Tamas

[a-langer]

For example, Oracle not supported "CREATE IF NOT EXIST":

TableUtils.createTableIfNotExists(cs, Account.class);

this returns error:

ORA-00955: name is already used by an existing object

[a-langer]

Oracle does not support keyword "LIMIT". Using "limit" method:

limit(Integer maxRows)

results in an error. Instead, oracle supports ROWNUM:

select * from Accouns where ROWNUM <= 5

or FETCH

select * from Accouns FETCH NEXT 5 ROWS ONLY;

FETCH can be used in the "orderByRaw" method.

orderByRaw("ID DESC FETCH NEXT 5 ROWS ONLY")

ormlite does not take into account these differences.

[j256]

Sorry for the long delay on this. Thanks. I'll take a look.

[benoit-dubreuil]

I coded this simple backup in the meantime :

public class CustomOracleDatabaseType extends OracleDatabaseType {

    @Override
    public boolean isLimitSqlSupported() {
        return false;
    }
}