SQL Server and JDBC

Question

SQL Server and JDBC

Frank Kalis

SSC Guru

Points: 111183
More actions
May 20, 2003 at 1:07 am

#80233

Does anyone out there use Java to access SQL Server?
We had a meeting with some external consultants to cut production cost. The consultants came up with the glorious idea to use Java as an enterprise platform, because it is free and blablabla.
Any thoughts on this?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

David.Poole SSC Guru Points: 76035 More actions · Answer 1

I had a huge document on performance characteristics of ORACLE, SQL Server, MySQL, DB2 and one or two others that included JDBC performance.

I thought it was on www.mysql.com but I can't find it now.

In short, it said that the JDBC driver for SQL Server was immature and prone to memory leaks. The comparison illustrated that the driver coped competitively up to a certain load and then hits a ceiling beyond which it would not go.

This was 6 months ago so things might have changed since then. It was talking about a specific JDBC SQL Server driver. There are probably ways around it, even if it means using a SYBASE driver or generic ODBC connector.

If cross platform apps are your thing then I'd have no objections to Java, but if you are going to be Windows only then unless you are already a Java shop then why bother?

LinkedIn Profile

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

quote:
If cross platform apps are your thing then I'd have no objections to Java, but if you are going to be Windows only then unless you are already a Java shop then why bother?

As an insurance company we mainly rely on mainframe stuff. This will NOT be changed. I think this will adress whether our IT infrastructure (oracle, sql server, mysql, vb, java..) should go for Microsoft (with all pros and cons) or move to something different (guest what..Linux).

For me it makes no great difference to do my stuff in asp or jsp.

But if you come across that document, can you post the link?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

We have some apps that access SQL Server using JDBC. Use 3rd party drivers, Merant I think, not the MS driver. Works ok, only supports Standard Auth (by JDBC spec).

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

srini_kris SSCommitted Points: 1738 More actions · Answer 4

We use BEA Web Logic for all our development and the JDBC driver that comes with it. Works pretty good upto 200 connections ( which is what we have rite now)

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

quote:
We use BEA Web Logic for all our development and the JDBC driver that comes with it. Works pretty good upto 200 connections ( which is what we have rite now)

Hmm,...BEA? It sounds familiar to me. I think our web guys use this. It seems the right hand doesn't know what the left hand is doing here in this company . Thanks for the tip!

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]