• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Java Enterprise and Microsoft SQL Server.

 
Bartender
Posts: 1357
39
IBM DB2 Netbeans IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Sheriff
Posts: 22783
131
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've used MS SQL Server 2005, 2008R2 and 2012 in combination with Java both at my current job and my previous one without any problems. It mostly involves using the MS provided JDBC driver and correct connection URL. If you're using Hibernate you also need the proper dialect. We have tweaked dialects a bit but that's about it.
 
Marshal
Posts: 4501
572
VSCode Eclipse IDE TypeScript Redhat MicroProfile Quarkus Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The big downside with SQL Server is the limited platform options where it can deployed.
 
Claude Moore
Bartender
Posts: 1357
39
IBM DB2 Netbeans IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Rob, Ron,

thanks for sharing your ideas and experiences. It's good to know that someone else engaged SQL Server at database level in a Java EE project.


reply
    Bookmark Topic Watch Topic
  • New Topic