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
.

Relevant Pages

  • Re: MS SQL Server in Java/J2EE environment
    ... I wanted to understand pros and cons of choosing MS SQL Server in Java/ ... J2EE environment. ...
    (comp.lang.java.databases)
  • MS SQL Server in Java/J2EE environment
    ... I wanted to understand pros and cons of choosing MS SQL Server in Java/ ... J2EE environment. ...
    (comp.lang.java.databases)
  • MS SQL Server in Java/J2EE environment
    ... J2EE environment. ... Personally I know the power of .Net with MS SQL Server and I don't ... So I just wanted to understand pros and cons of J2EE + ...
    (comp.lang.java.programmer)
  • Re: Recordset.AddNew and the recordset objects data retaining
    ... I am in an environment where bulk insert isn't an option--even though the ... underlying database is SQL server, I am using a third party OLE DB provider-- ... > insert(assuming you are using SQL server) or DTS. ...
    (microsoft.public.data.ado)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.dotnet.framework.aspnet.webservices)