dc3-driver-oracle is the Oracle database driver of the IoT DC3 platform. It connects to an Oracle database via JDBC (ojdbc11), supporting both SID and Service Name connection types. It reads point values through configured SELECT queries and writes through configured UPDATE/INSERT queries. JDBC connection handling is provided by the shared dc3-common-sql abstract base service.

Module Information

Group ID: io.github.pnoker
Artifact ID: dc3-driver-oracle
Driver Name: Oracle Driver

Driver Attributes (Device-level)

Attribute	Description
Host	Oracle host
Port	Oracle port
Username	Oracle username
Password	Oracle password
Query Timeout	SQL query timeout in seconds
Connection Type	Oracle connection type [SID, ServiceName]
SID	Oracle SID (used when Connection Type is SID)
Service Name	Oracle service name (required when Connection Type is ServiceName)

Point Attributes

Attribute	Description
Read Query	SQL SELECT query for reading point value
Write Query	SQL UPDATE/INSERT query for writing point value

Command Attributes (write)

Attribute	Description
Execute Query	SQL query to execute for command

The module application.yml is authoritative for attribute codes, types, default values, scheduling, health, and local buffering. Keep this README aligned when those user-facing settings change.

Prerequisites

A reachable Oracle database addressable by the configured host, port, credentials, and connection type (SID or Service Name).

Running Locally

1. Start Infrastructure and Center Services

make up-db
make up-dev GROUP=core

2. Build and Run

mvn -s .mvn/settings.xml -pl dc3-driver/dc3-driver-oracle -am package
java -jar dc3-driver/dc3-driver-oracle/target/dc3-driver-oracle.jar

Testing

Run the module tests from the repository root:

mvn -s .mvn/settings.xml -pl dc3-driver/dc3-driver-oracle -am test

dc3-common-driver — Driver SDK for registration, scheduling, and RabbitMQ integration
dc3-common-sql — Abstract JDBC driver service (connection pooling, read/write query execution)

README.md

DC3 Driver Oracle

Overview