Thanks for the detailed responses. >Database vendors have specific solutions for multiple identical >databases, one for each customer.
I'm so used to using MySQL maybe its time to look at some more powerful ones for this situation :) and the great thing about ORM as was mentioned is its portability thanks for the help >> I wonder if I am over complicating this issue. Basically our application is >> a Software as a Service (SaaS) and each client that accesses it really only >> needs to connect to their own data source due to the type of data our >> application processes... and regulations in the industry say their data must >> be separated. > >I imagined that was the use-case :) > >Database vendors have specific solutions for multiple identical >databases, one for each customer. A popular one is to have separate >databases faked by a database server that uses just one database but >shows different data based on the customer (login). I believe that is >a reasonable approximation of the problem you are facing. >One of the vendor buzzwords for that is Virtual Private Database and >looking for that shows that the performance problem in having >different classes for each customer is solvable if you use Hibernate >directly: https://forum.hibernate.org/viewtopic.php?t=940748 >I am unsure if ColdFusion exposes sufficient control over the >Hibernate session to dynamically switch the datasource or login >session in CFML, but if you want to use ORM this is the direction I >would recommend exploring. > > >> So, the actual objects in the database may vary but only *very* slightly. > >If you want this to work you are probably going to have to merge those >differences into one standard schema. > >Jochem > > >-- >Jochem van Dieten >http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:347737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
