configure the component thru the admin interface e.g.
http://localhost:4848/
library should be located in
%GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\jtds-1.2.2.jar
place jbi.xml configuration
%GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\META-INF\jbi.xml
<?xml version="1.0"?>
<!-- jbi.xml file for a sample shared library. -->
<jbi
version="1.0"
xmlns="
http://java.sun.com/xml/ns/jbi"
xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance">
<!-- identification information about this shared library-->
<shared-library>
<identification>
<name>jtds</name>
<description>blah..blah..blah..</description>
</identification>
<shared-library-class-path>
<path-element>jtds-1.2.2.jar</path-element>
</shared-library-class-path>
</shared-library>
</jbi>
HTH
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.
From: gorgeous65_at_msn.com
To: users_at_glassfish.dev.java.net
Date: Mon, 2 Mar 2009 00:30:22 +0000
Subject: RE: Vista, Jee5, sql2000 &sql2005
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
>
Beyond Hotmail — see what else you can do with Windows Live. Find out more!
_________________________________________________________________
Windows Live™: Life without walls.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_032009