I am thinking about refactoring a few applications of mine to use ORM. One problem that I think I will have is that the applications talk to multiple databases (in the vast majority of cases, the application only reads data, it does not write data). It's a data integration application that ties together data from numerous databases (a mixture of SQL Server databases on at least three different servers, and a database on an IBM AS400 server via java drivers from IBM - I don't expect ORM to work with the IBM database). As I understand it (and I use that term loosely :-[ ), the ORM built in to CF9 will connect to only one database. Is this correct? If so, are there any other ORM alternatives that would support the requirement of working with multiple databases? Or for a primarily read-only application, is ORM overkill?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
