We are in process to add more ORM models with other databases with the datasource="another_db" option in the models.
The problem we have seen is that when you simple do a EntityLoad of any model, lucee open N connections to the DB, with N=number of distinct datasource you have in your models.
So, if you have:
model1.cfc -> datasource1 (main datasource, without datasource option in the model)
model2.cfc -> datasource2
model3.cfc -> datasource3
model4.cfc -> datasource4
And you do:
Lucee (in my case Tomcat), always open 4 database connections and not reuse existing ones. So if you reload the page, you have 8 DB connections and so on.
We are trying to add our historical dbs (13 models) and this issue blocks us of doing it.
problem is the connections are hold in the HibernateSession, but lucee creates a new session with every request and does not release the old sessions!
@Julian (i will check, see upcoming comment in that ticket)