Hello,
I have finally got round to download this JTDS driver -
http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=25350&release_id=534076#
unzip it
and copied the jar file -
jtds-1.2.2
into a directory i created -
c:\ClassPath\JTDS\jtds-1.2.2
SETUP MY Environmental variables as-
CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.
Also added it to my Application Server\JVM seetings\path settings
under
Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2
I get the error -
Class name is wrong or classpath is not set for : net.sourceforge.jtds.jdbcx.JtdsDataSource
I hope I am on the right track. Any ideas? its my first time of using this driver.
thanks.
eve
> Date: Wed, 4 Feb 2009 15:55:58 -0500
> From: ryan_at_ijws.com
> To: users_at_glassfish.dev.java.net
> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
>
> 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
> >>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
_________________________________________________________________
View your Twitter and Flickr updates from one place – Learn more!
http://clk.atdmt.com/UKM/go/137984870/direct/01/