Home

Results 1 to 9 of 9

Thread: JDBC driver for Microsoft SQL Server

  1. #1
    choponis NNTP User

    JDBC driver for Microsoft SQL Server


    Been looking at the docs for the JDBC driver.

    I'm evaluating use for a MS SQL server application.

    I set up a test DB and driver connection using the Microsoft SQL 2008R2
    JDBC driver. Seemed to work fine.

    After reviewing the docs more, it seems the Microsoft 3rd party driver
    is "not recommended". Not really sure why.

    Also I don't see a real option for using MSSQL here - jTDS supports
    MSSQL, but it doesn't do views or stored procedures - which isn't
    ideal.

    Can anyone provide some insight here? Is the IDM driver 4.02 doc set
    "wrong"? Why wouldn't a MSSQL driver from Microsoft be "recommended"?
    I'm worried that if we use this Microsoft driver, NetIQ support will be
    less helpful.

    Perhaps I'm missing something?

    Thanks!


    --
    choponis
    ------------------------------------------------------------------------
    choponis's Profile: https://forums.netiq.com/member.php?userid=5896
    View this thread: https://forums.netiq.com/showthread.php?t=50077


  2. #2
    ab NNTP User

    Re: JDBC driver for Microsoft SQL Server

    Unless it states "not supported" the rest is just guidance for those who
    may desire it. If you have views, your options are limited (but still
    supported); if not, go with jTDS.

    --
    Good luck.

    If you find this post helpful and are logged into the web interface,
    show your appreciation and click on the star below...

  3. #3
    vivekbm NNTP User

    Re: JDBC driver for Microsoft SQL Server


    The main reasons were performance and stability in our evaluation ...
    Some threads on the same lines

    http://tinyurl.com/mwuyx5z
    http://tinyurl.com/lhtzno8

    "Not recommended" does not mean "Not supported" like AB mentions.


    --
    vivekbm
    ------------------------------------------------------------------------
    vivekbm's Profile: https://forums.netiq.com/member.php?userid=528
    View this thread: https://forums.netiq.com/showthread.php?t=50077


  4. #4
    Will Schneider NNTP User

    Re: JDBC driver for Microsoft SQL Server

    On 2/21/2014 5:58 AM, choponis wrote:
    > Can anyone provide some insight here? Is the IDM driver 4.02 doc set
    > "wrong"? Why wouldn't a MSSQL driver from Microsoft be "recommended"?
    > I'm worried that if we use this Microsoft driver, NetIQ support will be
    > less helpful.
    >
    > Perhaps I'm missing something?


    For anyone else reading this thread don't get scared away. There is nothing wrong with using the M$
    delivered JDBC drivers. They work just dandy and are supported.

    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Associate http://forums.netiq.com

    If you find this post helpful, please click on the star below.

  5. #5
    cpedersen is offline Micro Focus Employee - Ultra Contributor
    Join Date
    Feb 2008
    Posts
    369

    Re: JDBC driver for Microsoft SQL Server

    On 3/15/14, 1:58 AM, Will Schneider wrote:
    > On 2/21/2014 5:58 AM, choponis wrote:
    >> Can anyone provide some insight here? Is the IDM driver 4.02 doc set
    >> "wrong"? Why wouldn't a MSSQL driver from Microsoft be "recommended"?
    >> I'm worried that if we use this Microsoft driver, NetIQ support will be
    >> less helpful.
    >>
    >> Perhaps I'm missing something?

    >
    > For anyone else reading this thread don't get scared away. There is
    > nothing wrong with using the M$ delivered JDBC drivers. They work just
    > dandy and are supported.
    >


    I read somewhere that the M$ JDBC driver have some limitations which the
    jTDS does not. Do not ask me what these limitations are, as I have no idea.

    Casper

  6. #6
    Will Schneider NNTP User

    Re: JDBC driver for Microsoft SQL Server

    On 3/18/2014 7:51 AM, Casper Pedersen wrote:
    > I read somewhere that the M$ JDBC driver have some limitations which the jTDS does not. Do not ask
    > me what these limitations are, as I have no idea.


    I believe it is actually the other way around.

    The docs say that SP and views aren't supported by jTDS. I'm pretty sure that's not true but the M$
    specific driver supports all M$ features and the same is not true of jTDS.

    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Associate http://forums.netiq.com

    If you find this post helpful, please click on the star below.

  7. #7
    cpedersen is offline Micro Focus Employee - Ultra Contributor
    Join Date
    Feb 2008
    Posts
    369

    Re: JDBC driver for Microsoft SQL Server

    On 3/19/14, 1:11 AM, Will Schneider wrote:
    > On 3/18/2014 7:51 AM, Casper Pedersen wrote:
    >> I read somewhere that the M$ JDBC driver have some limitations which
    >> the jTDS does not. Do not ask
    >> me what these limitations are, as I have no idea.

    >
    > I believe it is actually the other way around.
    >
    > The docs say that SP and views aren't supported by jTDS. I'm pretty
    > sure that's not true but the M$ specific driver supports all M$ features
    > and the same is not true of jTDS.
    >


    Interesting, as I said there are some differences, and I don't know what
    they are.



  8. #8
    Will Schneider NNTP User

    Re: JDBC driver for Microsoft SQL Server

    On 3/19/2014 4:28 AM, Casper Pedersen wrote:
    > On 3/19/14, 1:11 AM, Will Schneider wrote:
    >> On 3/18/2014 7:51 AM, Casper Pedersen wrote:
    >>> I read somewhere that the M$ JDBC driver have some limitations which
    >>> the jTDS does not. Do not ask
    >>> me what these limitations are, as I have no idea.

    >>
    >> I believe it is actually the other way around.
    >>
    >> The docs say that SP and views aren't supported by jTDS. I'm pretty
    >> sure that's not true but the M$ specific driver supports all M$ features
    >> and the same is not true of jTDS.
    >>

    >
    > Interesting, as I said there are some differences, and I don't know what they are.
    >
    >


    Personally I think it shows up as not preferred because the source is closed and it's proprietary.
    Or one of the original authors maybe was frustrated by M$ at the time

    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Associate http://forums.netiq.com

    If you find this post helpful, please click on the star below.

  9. #9
    robertivey NNTP User

    Re: JDBC driver for Microsoft SQL Server


    I personally use jtds instead of the M$ implementation. I've found that
    some simple things, such as Select Max+1 in a direct query doesn't
    return correctly with the Microsoft implementation. I've run at least
    40 different drivers on JTDS without a hitch. The only place where it
    falls short is integrated AD authentication. For this I've needed the
    Microsoft implementation and a remote loader.


    --
    robertivey
    ------------------------------------------------------------------------
    robertivey's Profile: https://forums.netiq.com/member.php?userid=1091
    View this thread: https://forums.netiq.com/showthread.php?t=50077


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •