Programmatically loading datasouces to the Adobe CF servers through admin API

Looking for best approach to loading datasources programmatically to the Adobe CF servers in Commandbox. I had read somewhere that the Adobe admin did not fully support J2EE cfservers. Has anyone else found a need for this or wanted that ability?

As far as I know, there’s no issue using the admin in general in a J2EE installation. The only issue I’ve run into (which I probably mentioned to you) was that you can’t use the auto-update feature in the admin of a J2EE install.

The options you have that I can think of are:

  1. Use the Admin API to create the data sources when the application starts up
  2. Set the data sources in the Application.cfc with “this.datasources”
  3. Save off the actual XML config files for the database and copy them into the correct place when the server starts. I might need to add an additional interception point to CommandBox for this. We have a “onServerStart” but not one that runs after the server has been installed but prior to actually starting it.

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

I added a new interception point to CommandBox just now that will fire after the server is installed but before the server starts. It gives you a chance to manually copy additional configuration files. We’ll have to figure out how to call it best, but I think it will be a good building block.

https://ortussolutions.atlassian.net/browse/COMMANDBOX-393

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com