Re: MS SQL Server in Java/J2EE environment



On Mar 21, 1:49 am, Sudhakar Chavali <sudhakar.koundi...@xxxxxxxxx>
wrote:
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?

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.

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.

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 )

Thanks
Sudhakar

SQL Server works fine as the backend DB for a J2EE application.
Microsoft provides a free JDBC driver for SQL Server which works fine.
The MSSQL JDBC driver is under active development and maintenance.
Without getting into a religious war (I'm an Oracle fan myself) SQL
Server itself is generally a good database.
.



Relevant Pages

  • 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)
  • 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.sqlserver.server)