• Post Reply Bookmark Topic Watch Topic
  • New Topic

Java Enterprise and Microsoft SQL Server.  RSS feed

 
Claude Moore
Ranch Hand
Posts: 862
8
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • 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.
 
Rob Spoor
Sheriff
Posts: 20904
81
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • 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.
 
Ron McLeod
Saloon Keeper
Posts: 1432
207
Android Angular Framework Eclipse IDE Java Linux MySQL Database Redhat TypeScript
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The big downside with SQL Server is the limited platform options where it can deployed.
 
Claude Moore
Ranch Hand
Posts: 862
8
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • 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.


 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!