Oracle

Testing

To test using Oracle set the platform to oracle in src/test/resources/application-test.yaml

Refer to docs / testing if application-test.yaml doesn't exist yet.

ebean:
  test:
    platform: oracle # h2, postgres, mysql, oracle, sqlserver
    ddlMode: dropCreate # none | dropCreate | migrations
    dbName: test

The above will use the following defaults:

username:	{databaseName}
password:	test
port:	1521
url:	jdbc:oracle:thin:@localhost:{port}:XE
driver:	oracle.jdbc.driver.OracleDriver
image:	oracleinanutshell/oracle-xe-11g:{version}

Types

UUID

UUID is not a native Oracle type and can be mapped to either BINARY(16) or VARCHAR(36)..

History support

Oracle has native SQL2011 History support.