Hi Erik, I'll preface my comments about ORM with two things here. First I'm not an expert on either Transfer or Hibernate. Secondly I've been developing another ORM system myself since ColdFusion 5. http://www.datafaucet.com
So you know where my biases are. ;) My gut reaction to the introduction of Hibernate when it was announced was that I didn't expect it to have a huge impact on the ColdFusion community. And now that it's here, I've read one or two things from other developers who said after looking at it, that they also haven't found it terribly compelling. Here's one that Steve Bryant wrote where he talks about some of the specific changes in thinking that need to occur when working with Hibernate in CF9. http://www.bryantwebconsulting.com/blog/index.cfm/2009/9/22/DataMgr-is-Better-than-ColdFusion-ORM One thing that spoke to me in particular was his highlight of the fact that SQL execution doesn't happen in "real time" when using Hibernate. "The SQL doesn't execute immediately in Hibernate, instead executing at the end of a Hibernate "session" which almost matches a ColdFusion request. This means you have to start thinking about Hibernate sessions." That may or may not sound like an issue for you. To me it sounded like an invitation for much more confusing problems to arise. And at the same time it didn't sound to me like it solved any specific problems. Is it a good tool? I expect so. Is it stable? I suspect so, but haven't used it. Will it be an improvement over Transfer? That's a harder question to answer. I haven't yet seen anyone post any blogs describing the CF9 Hibernate implementation solving any specific problems for them. (By this I mean problems that weren't already solved by another tool like Transfer.) I haven't seen anyone say "oh thank heaven I have Hibernate now!" That's not to say that nobody has, but I haven't seen it. So long story short, if you're interested in solving a specific problem, I would read up on Hibernate (or Reactor or DataFaucet) to see if it solves that specific problem and if so, then go ahead and try it. Otherwise my expectation is that it will be more productive for you in the long-run to stick with what you already know. :) -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

