The .jar does not come with GlassFish, you have to download it manually.
I do not recommend using Microsoft's JDBC driver. When we use it in
production to communicate with a remote SQL Server 2005 EE, at least
once per week there is a problem trying to connect to the database. The
Microsoft driver blocks the thread that is asking for a connection
indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
response error". Once this happens 5 times then the HTTP Listener for
your web application can no longer respond to web requests and it looks
like GlassFish is locked up. This happens even when you set the
loginTimeout property. We tested the latest 1.2 version of the driver.
We use the open source jTDS driver instead. It doesn't have this
problem and works well.
Ryan
Marina Vatkina wrote:
> Did you try to search Microsoft site?
>
> thanks,
> -marina
>
> Dr. Charles O. Odeyale wrote:
>> No, it is not in either location; not even on my system for that
>> matter. I have gone to Sun.com to look for it but came back empty. I
>> will continue to look to download a copy and report back. Is there
>> anything else I may need, or need to do?
>>
>> Thanks.
>>
>> ----- Original Message ----- From: <glassfish_at_javadesktop.org>
>> To: <users_at_glassfish.dev.java.net>
>> Sent: Wednesday, February 04, 2009 1:21 AM
>> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
>>
>>
>>> Is the sqljdbc.jar copied in the <install_root>/lib or
>>> <install_root>/domains/domain1/lib/ext directories? The jar should
>>> be made available to the application server in order to load the
>>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
>>> [Message sent by forum member 'sm157516' (sm157516)]
>>>
>>> http://forums.java.net/jive/thread.jspa?messageID=330006
>>>