Oracleex

Adapter to Oracle. Using DBConnection and ODBC.

It connects to Ecto with OracleEcto.

Based on findmypast-oss/mssqlex

Here are a couple articles were they described the implementation:

• SQL Server in Elixir, Part 1: Connecting
• SQL Server in Elixir, Part 2: Process Management

AutoCommit (Auto_Commit) is 'on' by default in Oracle; but defaulted 'off' in code. We don't use this library with AutoCommit 'on' and as such the code around AutoCommit is not fully baked and tested.

Installation

Oracleex requires the Erlang ODBC application to be installed. This might require the installation of an additional package depending on how you have installed Erlang (e.g. on Ubuntu sudo apt-get install erlang-odbc).

Oracleex depends on Oracle's ODBC Driver. See the Dockerfile for how to install.

Testing

Tests require an instance of Oracle to be running on localhost and the appropriate environment variables to be set. See the docker-compose file for details

To start the database:

docker-compose up db

To open a shell at the app root:

docker-compose run oracleex

To run the unit tests:

mix deps.get
mix test