A fully containerized environment for integrating Oracle Autonomous Database Free 26ai
with JasperReports Server (Community Edition) — featuring AI Vector Search,
Select AI, and In-Database Machine Learning capabilities.

graph TB
    subgraph DockerNet["🐳 Docker Network — oracle-adb-network"]
        direction TB
        ODB["🗄️ Oracle ADB Free 26ai<br/>──────────────<br/>Ports: 1521 · 1522 · 8443 · 27017"]
        MDB["🗃️ MariaDB<br/>──────────────<br/>Jasper Metadata Store"]
        JS["📊 JasperReports Server CE<br/>──────────────<br/>Port: 9091 → 8080"]
    end

    User["👤 Developer / Analyst"]

    User -- "Browser :9091" --> JS
    User -- "SQL Client :1522" --> ODB
    JS -- "JDBC (ojdbc8)" --> ODB
    MDB -- "Internal Metadata" --> JS

    style DockerNet fill:#1a1a2e,stroke:#16213e,color:#e0e0e0
    style ODB fill:#F80000,stroke:#cc0000,color:#ffffff
    style JS fill:#007396,stroke:#005a75,color:#ffffff
    style MDB fill:#003545,stroke:#002030,color:#ffffff
    style User fill:#4a90d9,stroke:#2d6cb4,color:#ffffff

git clone https://github.com/eng-malek/Oracle-adb-26ai-Integration-for-Jasper-Report-Server.git
cd Oracle-adb-26ai-Integration-for-Jasper-Report-Server

cd oracle-adb
cp .env.example .env        # Edit .env to set secure passwords

Create the required Docker network and volumes:

docker network create oracle-adb-network
docker volume create oracle-adb-data
docker volume create oracle-adb-logs

Launch the database:

docker compose up -d

docker logs -f oracle-adb-26ai

Open a new terminal and run:

cd jasper-server
cp .env.example .env        # Edit .env to customize credentials
docker compose up -d

Download ojdbc8.jar from Oracle's JDBC Downloads, then copy it into the running container:

docker cp ojdbc8.jar jasperreports:/opt/bitnami/jasperreports/apache-tomcat/lib/
docker restart jasperreports

1. Log in to JasperReports → View → Repository.
2. Right-click Data Sources → Add Resource → Data Source.
3. Configure:

4. Click Test Connection → Save.

Oracle Database 26ai introduces powerful AI capabilities you can expose through JasperReports:

Store and query vector embeddings directly in Oracle for semantic search:

-- Create a table with a VECTOR column
CREATE TABLE product_embeddings (
    id        NUMBER GENERATED ALWAYS AS IDENTITY,
    name      VARCHAR2(200),
    embedding VECTOR(384, FLOAT32)
);

-- Find the 5 most similar products to a query vector
SELECT name, VECTOR_DISTANCE(embedding, :query_vector, COSINE) AS similarity
FROM   product_embeddings
ORDER BY similarity
FETCH FIRST 5 ROWS ONLY;

Use DBMS_CLOUD_AI to translate plain-English questions into SQL:

-- Ask a question in natural language
SELECT AI NARRATE 'What were the top 5 products by revenue last quarter?';

Train and score ML models inside the database, then visualize predictions in JasperReports:

-- Example: Apply an in-database classification model
SELECT PREDICTION(my_model USING *) AS predicted_class
FROM   customer_data;

• Secrets Management — All credentials are externalized via .env files excluded from Git.
• Oracle Wallet — For mTLS connections, mount your wallet directory via WALLET_HOST_PATH in oracle-adb/.env.
• Network Isolation — All services communicate over an isolated Docker bridge network (oracle-adb-network).
• Principle of Least Privilege — MariaDB is only accessible to JasperReports internally; it is not exposed on the host.

Oracle-adb-26ai-Integration-for-Jasper-Report-Server/
│
├── oracle-adb/
│   ├── docker-compose.yaml    # Oracle ADB 26ai service definition
│   ├── .env.example           # Environment variable template
│   └── README.md              # Oracle-specific setup guide
│
├── jasper-server/
│   ├── docker-compose.yaml    # JasperReports + MariaDB service definitions
│   ├── .env.example           # Environment variable template
│   └── README.md              # Jasper-specific setup & JDBC guide
│
├── image/
│   └── Screenshot_*.png       # Screenshots & visual assets
│
├── .gitignore                 # Git ignore rules (env, wallet, jars, etc.)
├── LICENSE                    # Apache License 2.0
└── README.md                  # ← You are here

docker logs oracle-adb-26ai   # Check for OOM or config errors

docker restart jasperreports

docker network inspect oracle-adb-network

Contributions, issues, and feature requests are welcome!

1. Fork the repository.
2. Create a feature branch: git checkout -b feature/amazing-feature
3. Commit your changes: git commit -m "feat: add amazing feature"
4. Push to the branch: git push origin feature/amazing-feature
5. Open a Pull Request.

This is an unofficial community project and is not affiliated with or endorsed by Oracle Corporation or Cloud Software Group (Jaspersoft). All trademarks belong to their respective owners. Standard license terms apply.

This project is licensed under the Apache License 2.0 — see the LICENSE file for details.

Maintained by
Eng. Malek Mohammed Al-edresi
Oracle APEX & Database Developer | AI & Vector Search Enthusiast

⭐ If you find this project useful, please consider giving it a star!