jdx-orm

Like JDX_ReverseEngineeringExample but generates JSON-capable container classes extending JDX_JSONObject instead of POJOs, and produces a JSON-aware .revjdx mapping using VIRTUAL_ATTRIB. Compatible with JDX ORM, Gilhari ORM, and MCP server deployments.

Shows how JDX ORM calls stored procedures via storedProc and maps results back to Java objects or scalar values. Five stored procedures are demonstrated: returning object lists, filtered objects, a count, an update count, and a computed scalar — all declared in the .jdx mapping file. This example uses MySQL stored procedures.

Introduces JDX ORM JSON-based persistence: a JSON_Employee class extends JDX_JSONObject with only two constructors; all attribute storage uses the JSONObject API. The ORM mapping uses VIRTUAL_ATTRIB declarations. Employees can be built from put calls, a JSONObject, or a raw JSON string.

Demonstrates JDX ORM object streaming — retrieving large query results in incremental batches using QFLAG_STREAM, queryFetch, and queryClose rather than loading everything into memory at once. Must be run inside a transaction; shows both a full-table stream and a filtered, ordered stream.

Shows how JDX ORM named sequence generators SEQUENCE / JDXSeqUtil produce persistently unique, application-managed primary key values across application restarts. Uses DeptIdSequence and EmpIdSequence with configurable MAX_INCREMENT and START_WITH parameters.

Demonstrates JDX ORM reverse engineering: given a template config pointing at MySQL Sakila tables film, film_actor, film_category, the tool auto-generates Java POJO classes with getters/setters and a complete .revjdx ORM mapping file. Generated output can be compiled and used immediately with JDXDemo.

Demonstrates JDX ORM one-to-one and one-to-many object relationships — Company → Departments & ForeignLocations, Employee → Address. Shows deep/shallow CRUD, lazy fetch, named queries, directed operations, batch inserts, and implicit foreign-key management.