The BoxLang ORM module allows your BoxLang
application to integrate with the powerful Hibernate ORM. With Hibernate, you can interact with your database records in an object oriented fashion, using a BoxLang class to denote each record and simple getters and setters for each field value:

class entityName="Auto" persistent="true" {

	property name="id" type="string" fieldtype="id" ormtype="string";
	property name="make" type="string";
	property name="model" type="string";

    function onPreInsert(){
        log.info( "Inserting new Auto: #getMake()# #getModel()#" );
    }
}

BoxLang ORM also enables transactional persistence, where an error during a save will roll back the entire transaction to prevent leaving the database in a broken state:

transaction{
    try{
        entitySave(
            entityNew( "Purchase", {
                productID : "123-expensive-watch",
                purchaseTime : now(),
                customerID : customer.getId()
            })
        );
        var cartProducts = entityLoad( "CartProduct", customer.getID() );
        entityDelete( cartProducts );
    } catch ( any e ){
        // don't clear the user's cart if the purchase failed
        transactionRollback();
        rethrow;
    }
}

bx-orm bundles Hibernate 5.6.15.FINAL.

bx-orm is an open source BoxLang module with no license purchase necessary. If you are looking to further the development of this extension, consider sponsoring a feature or opening a support contract.

• Add Object Relational Mapping to any boxlang app with Hibernate ORM
• Use native built-in-functions (BIFs) to update and persist entities to the database (entityNew(), entitySave(), ormFlush(), etc.)
• Supports 80+ database dialects, from SQLServer2005 to MySQL8 and PostgreSQL
• Generate your mapping XML once and never again with the autoGenMap=false ORM configuration setting
• React to entity changes with pre and post event listeners such as onPreInsert(), onPreUpdate() and onPreDelete()
• Over 20 native BIFs:
  • EntityDelete()
  • EntityLoad()
  • EntityLoadByExample()
  • EntityLoadByPK()
  • EntityMerge()
  • EntityNameArray()
  • EntityNameList()
  • EntityNew()
  • EntityReload()
  • EntitySave()
  • EntityToQuery()
  • ORMClearSession()
  • ORMCloseAllSessions()
  • ORMEvictCollection()
  • ORMEvictEntity()
  • ORMEvictQueries()
  • ORMExecuteQuery()
  • ORMFlush()
  • ORMGetSession()
  • ORMGetSessionFactory()
  • ORMReload()

By launching BoxLang we are able to give back to the community, as well as offer premium support to enterprises looking for a level up in their Hibernate implementations. If you need performance optimization, session management or caching integrations, please contact us for support.

• Source Code: github.com/ortus-boxlang/bx-orm
• Support Plans: https://www.ortussolutions.com/services/support
• Bug Tracker: https://ortussolutions.atlassian.net/browse/BLMODULES