quality@glassfish.java.net

Re: Unable to create Oracle datasource on admin gui

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Thu, 29 Oct 2009 14:09:27 +0530

Hi Richard,


On Thu, 2009-10-29 at 10:30 +0200, Richard Kolb wrote:
> Hi Judy and Jagadish
>
> Thanks very much for the info.
>
> Should I file a documentation request to make this clear in the
> deployment guide ?
> At the moment is says you must install JDBC drivers to lib/ext to take
> advantage of Eclipse Link(Page 125)
> This is incorrect, it needs to be in lib as well
No, as per the link I have sent, either one would suffice.
It must be in lib/ext only when some one is making use of EcliplseLink.
>
>
> From the post Jagadish sent (http://tinyurl.com/yzkfdwy):
> Drivers can be placed in domain-dir/lib and they should be placed
> there. They can be placed in domain-dir/lib/ext/ as well, but not
> recommended unless some one wants to use Oracle driver and Oracle
> specific extension in eclipselink.
>
> Maybe add :
> If the driver is only in lib/ext the admin GUI does not configure a
> JDBC resource correctly. You need to copy the driver in lib as well.
This will be a bug. We can fix it so that drivers in lib/ext will also
be detected.

Thanks,
-Jagadish
>
> regards
> Richard
>
>
>
> 2009/10/28 Judy Tang <Judy.J.Tang_at_sun.com>
> Thanks Jagadish for the detailed information. Let me forward
> your reply to Richard to quality alias.
>
> Richard has filed the following issue, could you please look
> into. Thanks !
>
> "Please place a README.TXT in lib/ext that explicitly says what should should and
> should not. This will save a lot of support calls"
>
> https://glassfish.dev.java.net/issues/show_bug.cgi?id=10628
>
>
> Thanks,
> Judy
>
>
>
> Jagadish Prasath Ramu wrote:
> > Hi Richard,
> >
> > GF_INSTALL_ROOT/domains/<domain-name>/lib or GF_INSTALL_ROOT/lib is the
> > recommended directory to provide the jdbc drivers.
> >
> > Typically, ext dirs represent the extensions directory where extensions
> > to core APIs can be placed.
> > http://java.sun.com/docs/books/tutorial/ext/basics/install.html
> >
> > You can follow the GlassFish thread about the recommended locations to
> > copy the jdbc driver.
> > http://tinyurl.com/yzkfdwy
> >
> > Copying to lib/ext directory so as to overcome eclipse link related
> > issue is a restriction
> > which is documented in the following section :
> > "Restrictions and Optimizations"
> > http://docs.sun.com/app/docs/doc/820-7695/gbxjh?a=view
> >
> > Thanks,
> > -Jagadish
> >
> >
> >
> > On Wed, 2009-10-28 at 09:19 -0700, Anissa Lam wrote:
> >
> > > There seems to be confusion on where exactly the JDBC drivers should
> > > be installed in v3. Thanks for all the great suggestion on how to
> > > make the pool creation experience better.
> > > I have contacted the doc team so they are aware of the issues.
> > > Jagadish Ramu is the owner of the JDBC resource, I am cc'ing him so
> > > he can send his comment as well.
> > >
> > > thanks
> > > Anissa.
> > >
> > > Richard Kolb wrote:
> > >
> > > > Some more work when you wake up :)
> > > > https://glassfish.dev.java.net/issues/show_bug.cgi?id=10628
> > > >
> > > > regards
> > > > Richard
> > > >
> > > >
> > > > 2009/10/28 Judy Tang <Judy.J.Tang_at_sun.com>
> > > > Good point Richard. Will let Anissa sleep now and think
> > > > about it tomorrow :-)
> > > >
> > > > Thanks !
> > > > Judy
> > > >
> > > >
> > > > Richard Kolb wrote:
> > > > > Hi Judy
> > > > >
> > > > > I think we have a more complex problem. The driver may
> > > > > need to be in lib/ext to make Oracle Toplink work.
> > > > > Personally I don't use toplink so I can't confirm this.
> > > > >
> > > > > Maybe a nice to have (and a quick one) is to add a
> > > > > README.TXT file in lib/ext and say what should and what
> > > > > should not be included there.
> > > > >
> > > > > regards
> > > > > Richard
> > > > >
> > > > >
> > > > > 2009/10/28 Judy Tang <Judy.J.Tang_at_sun.com>
> > > > > Hi Richard,
> > > > >
> > > > > Thanks for continue testing and report issues. It helps us to know where to improve.
> > > > >
> > > > > Checked with Yifeng she confirmed if put the driver in domain1/lib, it is working fine. Thanks Yifeng :-)
> > > > >
> > > > > Thanks Anissa, you are so fast, even looked into online Help and found an issue there.
> > > > >
> > > > > I have a suggestion and see if it is possible to add code to check under domain1/lib, if driver is not
> > > > > there, may be pop up an error message to suggest user to put the driver in the right place ?
> > > > >
> > > > >
> > > > > Judy
> > > > >
> > > > > Anissa Lam wrote:
> > > > > >
> > > > > > Hi Richard,
> > > > > > I have looked at this and realized what is the
> > > > > > problem.
> > > > > > The location where you install the oracle driver
> > > > > > is the issue. It should be placed under
> > > > > > glassfishv3/glassfish/domains/domain1/lib
> > > > > > (Note: NOT lib/ext).
> > > > > > Once you put it there, and restart the driver,
> > > > > > connector runtime is able to detect that and
> > > > > > console presented the correct information.
> > > > > > Attached is the list of property shown when i
> > > > > > select "javax.sql.DataSource" as the resource
> > > > > > type.
> > > > > >
> > > > > > I checked the current Online Help for creating
> > > > > > the pool, the help did mention that lib/ext
> > > > > > being an alternate location which is incorrect.
> > > > > >
> > > > > > # Make the driver accessible to the common
> > > > > > class loader.
> > > > > > 1. Copy the JAR and ZIP files of the driver
> > > > > > into the domain-dir/lib directory; or copy the
> > > > > > class files into the domain-dir/lib/ext
> > > > > > directory.
> > > > > > 2. Restart the domain.
> > > > > >
> > > > > > I will contact the doc team and ensure that this
> > > > > > will be corrected.
> > > > > > Again, thanks for drawing this to our attention
> > > > > > and takeing the time to file the bug.
> > > > > >
> > > > > > thanks
> > > > > > Anissa.
> > > > > >
> > > > > > Richard Kolb wrote:
> > > > > > > Hi Anissa
> > > > > > >
> > > > > > > No problem, just glad I saw it.
> > > > > > > Will copy the GF 2.1 setting.
> > > > > > >
> > > > > > >
> > > > > > > regards
> > > > > > > Richard
> > > > > > >
> > > > > > > 2009/10/28 Anissa Lam <Anissa.Lam_at_sun.com>
> > > > > > >
> > > > > > > Hi Richard,
> > > > > > > I will look into this. In the
> > > > > > > meantime, maybe you can work around
> > > > > > > the problem by adding rows in the
> > > > > > > Property table and fill in the
> > > > > > > Property name and value pair instead
> > > > > > > of relying GUI to provide the property
> > > > > > > list for you to fill in the value.
> > > > > > >
> > > > > > > Sorry for the inconvenience.
> > > > > > >
> > > > > > > thanks
> > > > > > > Anissa.
> > > > > > >
> > > > > > >
> > > > > > > Richard Kolb wrote:
> > > > > > > >
> > > > > > > > Can someone please confirm this
> > > > > > > > (it's a bad one) :
> > > > > > > > https://glassfish.dev.java.net/issues/show_bug.cgi?id=10626
> > > > > > > >
> > > > > > > >
> > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net For additional commands, e-mail: quality-help_at_glassfish.dev.java.net
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ---------------------------------------------------------------------
> > > > > > To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net
> > > > > > For additional commands, e-mail:
> > > > > > quality-help_at_glassfish.dev.java.net
> > > > >
> > > >
> > > >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: quality-help_at_glassfish.dev.java.net
> >
> >
>