OpenRules Platform

Relational Database Integration

Rule DB – SQL Outside Rules

This traditional integration pattern keeps SQL in Java application code and passes the selected data to the decision model.

Traditional integration

Keep database access in the Java caller.

A Java program can invoke a decision model while communicating with a database through JDBC.

The standard Rule DB workspace includes SqlOutsideRules. Its TestInProcessOrders program performs the same task as the introductory Rule DB example, but it does not separate record selection from business logic.

TestInProcessOrders Java program using JDBC and OpenRules
Java implementation with SQL outside rulesOpen full size ↗

Try Rule DB

Build a decision model that works directly with your data.

The free evaluation includes Rule DB and ready-to-run database examples.