I've always put JDBC driver .jar files in domains\domain1\lib\ or
domains\domain1\lib\ext\
Next create a JDBC Connection Pool and JNDI reference in GlassFish's web
admin console.
I'm not familiar with what Martin Gainty described below (JBI)
Martin Gainty wrote:
> 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. Check it out.
> <http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_032009>