Anonymous_User Absent Member.
Absent Member.
382 views

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

Labels (1)
0 Likes
8 Replies
Anonymous_User Absent Member.
Absent Member.

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...
0 Likes
Anonymous_User Absent Member.
Absent Member.

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

0 Likes
Anonymous_User Absent Member.
Absent Member.

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.
0 Likes
cpedersen Outstanding Contributor.
Outstanding Contributor.

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
0 Likes
Anonymous_User Absent Member.
Absent Member.

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.
0 Likes
cpedersen Outstanding Contributor.
Outstanding Contributor.

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.


0 Likes
Anonymous_User Absent Member.
Absent Member.

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.
0 Likes
Anonymous_User Absent Member.
Absent Member.

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.