Files
Exposed/ORACLE.md
2017-11-02 19:07:27 +03:00

760 B

Oracle Dialect

Limitations

  • Only Oracle 12 supported (limit with FETCH ... ROWS ONLY)
  • autoinc columns supported by sequences, need an argument with sequence name
  • insert with select with limit not supported (DMLTests.testInsertSelect01)

Running tests locally with Gradle

  • Set dialect in gradle.properties to 'oracle'
  • Run exposedDialectTestWithDocker gradle task

Running tests locally with Docker

  • Run SQL Server locally, e.g. with sath89/oracle-12c Docker image or use docker-compose -f docker-compose-oracle.yml up
  • Run tests with -Dexposed.test.dialects=oracle, (optionally you may need to provide -Dexposed.test.oracle.host=_YOUR_DOCKER_HOST_ -exposed.test.oracle.port=_SQLSERVER_SERVER_EXPOSED_PORT_)