This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes MS SQL Server in Java/JEE environment Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "MS SQL Server in Java/JEE environment" Watch "MS SQL Server in Java/JEE environment" New topic
Author

MS SQL Server in Java/JEE environment

Sudhakar Chavali
Greenhorn

Joined: Mar 20, 2008
Posts: 2
Dear all,

I wanted to understand pros and cons of choosing MS SQL Server in Java/J2EE environment.

Could anybody share some thoughts or web resources?

Personally I hate using MS SQL Server for Java/J2EE based applications. But one of my clients wanted to have following environment for his production environment and he insist on using this environment for application development. So I just wanted to understand pros and cons of J2EE (Application) + MS SQL Server ( rdbms )

MS SQL Server
J2EE/Flex
Windows OS

Thanks
Sudhakar
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8935
    
    9

Originally posted by Sudhakar Chavali:

Personally I hate using MS SQL Server for Java/J2EE based applications.


Any particular reason?
Most of my database experience is with Oracle, but what I've seen of MS SQL Server I have liked. It has a nice integrated user interface. Oracle's user interface is primitive, cryptic and spread across numerous apps.
It has an auto increment type whereas Oracle insists one jump through hoops setting up a sequence and trigger.
Data Transfer Services is a lifesaver if one has numerous data sources that have to be scrubbed and imported.
If the client wants MS SQL Server, use it. One of the great things about Java's APIs is vendor-independence, being able to pick and choose the various tools for a job. Don't tick off your client just because he wanted you to use Brand X hammer rather than your preferred Brand y.


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
Roger Chung-Wee
Ranch Hand

Joined: Sep 29, 2002
Posts: 1683
Which J2EE application server are you using? Do you have reason to believe that the app server/driver/database combination will not work?


SCJP 1.4, SCWCD 1.3, SCBCD 1.3
Sudhakar Chavali
Greenhorn

Joined: Mar 20, 2008
Posts: 2
Dear All

Thank you for your responses. I have worked in both Microsoft and non MS based environments. Personally I know the power of .Net with MS SQL Server and I don't wanted to compromise on using MS SQL Server with Java/JEE environment just for some reasons that Jave/JEE environment have.

I don't hate MS or non MS products but using these products in heterogeneous environment is bit weird to me. That is the reason I started investigating the power of J2EE with MS SQL Server


Thanks
Sudhakar
[ March 20, 2008: Message edited by: Sudhakar Chavali ]
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8935
    
    9

Originally posted by Sudhakar Chavali:
I don't wanted to compromise on using MS SQL Server with Java/JEE environment just for some reasons that Jave/JEE environment have.


I think you are drawing distinctions where they don't exist. As far as Java's concerned MS SQL is just another database and it is not at all unusual to build J2EE apps on top of it.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

MSSQL is fine for Java apps. There are good, free JDBC drivers out there: jTDS and MS's 2005 version for example.

MSSQL does have draw backs - its locking implementation is poor and its security model is basic for example. But these are problems that exist wether you use Java to connect to it or .Net. J2EE doesn't make the situation any worse.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MS SQL Server in Java/JEE environment