[jboss-dev-forums] [Design of JBoss jBPM] - Re: [sim] problems with hibernate queries and dates

[tom.baeyens@jboss.com]

"camunda" wrote : I had some more problems today. I now think of skipping hibernate and using native queries here, because some of the stuff would really be easier and better. And I get rid of some problems I have at the moment...
  | 
  | I could provide mySQL and Oracle for the beginning, also HSQL shouldn't be hard. But f somebody needs more, he has to translate the queries himself.
  | 
  | Any thoughts?

sorry for the late reply.

up to now, we didn't use anything outside hibernate to get the best possible portability.  i didn't see a strategy here to get the same level of portability in what you want to do.

here are my first questions

do you intend to build all the queries for all the dbs ?  do you intend to maintain them ?  for different versions of the dbs ?  do you know that you can't rely on the community for that ?

that is why we accepted the downside of staying within the hibernate boundaries.  but feel free to challenge that.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4106260#4106260

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4106260