MS SQL Server in Java/J2EE environment

Thread view:

Sudhakar Chavali - 21 Mar 2008 05:49 GMT

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

Reply to this Message

Lew - 21 Mar 2008 12:20 GMT

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

Signature

Lew

Reply to this Message

David Segall - 21 Mar 2008 14:17 GMT

>> I wanted to understand pros and cons of choosing MS SQL Server in Java/
>> J2EE environment.
[quoted text clipped - 3 lines]
>SQL Server should be just fine for Java, assuming you find a decent JDBC
>driver for it.

Are you saying that Microsoft's JDBC driver
<http://msdn2.microsoft.com/en-us/data/aa937724.aspx> is not "decent"?
What are its flaws?

Reply to this Message

Lew - 22 Mar 2008 00:03 GMT

Lew wrote:

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

> Are you saying that Microsoft's JDBC driver
> <http://msdn2.microsoft.com/en-us/data/aa937724.aspx> is not "decent"?

Why would you think that?

I didn't say what I didn't say.

> What are its flaws?

I am not aware of any.

Signature

Lew

Reply to this Message

Arne Vajhøj - 22 Mar 2008 02:06 GMT

>>> I wanted to understand pros and cons of choosing MS SQL Server in Java/
>>> J2EE environment.
[quoted text clipped - 5 lines]
> <http://msdn2.microsoft.com/en-us/data/aa937724.aspx> is not "decent"?
> What are its flaws?

There are two possibilities. The MS one and the FreeTDS one.

I feel most confident with the MS one.

Arne

Reply to this Message

Rob - 27 Mar 2008 18:46 GMT

On Mar 21, 1:49 am, Sudhakar Chavali <sudhakar.koundi...@gmail.com>
wrote:

> Dear all,
>
[quoted text clipped - 22 lines]
> 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.

Reply to this Message

blueparty - 04 Apr 2008 16:36 GMT

> On Mar 21, 1:49 am, Sudhakar Chavali <sudhakar.koundi...@gmail.com>
> wrote:
[quoted text clipped - 3 lines]
> > I wanted to understand pros and cons of choosing MS SQL Server in Java/
> > J2EE environment.

I hate the fact that MSSQL still (SS-2005) does not have standard
timestamp, and one has to use
datetime and smalldatetime. There is no sequence type that can
generate ID which is unique across all tables,
and independent of INSERT command.

I hate that VIEW must be created in separate batch (batch is MSSQL and
Sybase, I think, specific).

I hate that it does not accept word COLUMN in ALTER TABLE ADD COLUMN
x.

I was not able to use SS2000 with Squirrel-SQL and Microsoft JDBC
driver, but it worked with JTDS.
I haven't tried MS driver with SS2005.

SQL server own authentication must be enabled to work with JDBC, as
opposite to "Windows authentication".
TCP connections with static port must be configured.

I hate the situation when I transfer data from another server and
connection between login name and username
gets broken (stored procedure sp_change_users_login fixes that).

Otherwise it works fine....

DG

Reply to this Message

MS SQL Server in Java/J2EE environment

Free Magazines