Post reply

SQL Server and JDBC

  • 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]

  • May 20, 2003 at 7:43 am

    #457816

    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

  • May 20, 2003 at 7:56 am

    #457822

    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]

  • May 20, 2003 at 10:01 am

    #457858

    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://qa.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • June 17, 2003 at 6:34 am

    #461710

    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)

  • June 17, 2003 at 8:36 am

    #461760

    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]

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

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