Re: MS SQL Server in Java/J2EE environment

Sudhakar Chavali wrote:
> I wanted to understand pros and cons of choosing MS SQL Server in Java/
> J2EE environment.
> 
> Could anybody share some thoughts or web resources?

SQL Server should be just fine for Java, assuming you find a decent JDBC 
driver for it.

> 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.

OK, then don't.  Using SQL Server isn't really a "compromise", though.

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

Why is that?

> 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 Serv
> 
> So I just wanted to understand pros and cons of J2EE (Application) +
> MS SQL Server ( rdbms )

Pro: it'll work.  Cons: As with all other sophisticated RDBMSes, you might
not 
be able to take full advantage of the power of the engine using only JDBC.

-- 
Lew