Skip to content

Latest commit

 

History

History
16 lines (12 loc) · 770 Bytes

ORACLE.md

File metadata and controls

16 lines (12 loc) · 770 Bytes
Raw

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 quillbuilduser/oracle-18-xe 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_)