First: I don't absolutely want to start a flame, just I need your advice. At work, I'm trying to select a target DBMS server for a medium-sized
Java Enteprise project. SQL Server is among candidates, and I have to admit that's quite attractive for most of my co-workers. It provides an excellent
IDE to develop and debug stored and UDFs, it's intuitive, it's fast, and IMHO it's really reliable. In a few words: I don't think that SQLServer is not a really good product. I'm only a bit puzzled about adopting it with Java: to be honest, I think - and that's may be a prejudice - that SQL Server copes better with Microsoft related tecnlogies more than with Java; moreover, in my humble experience, I usually heard about XYZ Application Server adoption with Oracle or MySQL or Postgres as backend databases,but this may "simply" mean that such solutions are well proven to work recipies.
Honestly I never heard about SQL Server usage with Java EE, but that of course doesn't mean that the whole thing would not work.
I'd like to hear about your own opinions or direct experiences.
I hope you may help me to gather up ideas..
Thanks in advance.