quality@glassfish.java.net

Re: Unable to create Oracle datasource on admin gui

From: Judy Tang <Judy.J.Tang_at_Sun.COM>
Date: Thu, 29 Oct 2009 01:57:38 -0700

Hi Richard,

Thanks. Sure, just listen to Jagadish, he is good :-)

Thanks Jagadish for all the help !

Judy

Richard Kolb wrote:
> Hi Judy
>
> Jagadish seems to think this is a bug, so maybe the doc change is not
> necessary just yet.
> Will keep an eye open on this issue
>
> thanks
> Richard.
>
> 2009/10/29 Judy Tang <Judy.J.Tang_at_sun.com <mailto:Judy.J.Tang_at_sun.com>>
>
> Hi Richard,
>
> I like your suggestion. Please file a doc bug on it.
>
> Many thanks :-)
>
> Judy
>
> 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/
>>
>>
>> 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.
>>
>> regards
>> Richard
>>
>>
>>
>> 2009/10/28 Judy Tang <Judy.J.Tang_at_sun.com
>> <mailto: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> <mailto: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> <mailto: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> <mailto: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 <mailto:quality-unsubscribe_at_glassfish.dev.java.net> For additional commands, e-mail: quality-help_at_glassfish.dev.java.net <mailto:quality-help_at_glassfish.dev.java.net>
>>>>> > > >
>>>>> > >
>>>>> > >
>>>>> > >
>>>>> > >
>>>>> > > ---------------------------------------------------------------------
>>>>> > > To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net <mailto:quality-unsubscribe_at_glassfish.dev.java.net>
>>>>> > > For additional commands, e-mail:
>>>>> > > quality-help_at_glassfish.dev.java.net <mailto:quality-help_at_glassfish.dev.java.net>
>>>>> >
>>>>>
>>>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net <mailto:quality-unsubscribe_at_glassfish.dev.java.net>
>>> For additional commands, e-mail: quality-help_at_glassfish.dev.java.net <mailto:quality-help_at_glassfish.dev.java.net>
>>>
>>>
>>
>>
>