dev@glassfish.java.net

Re: JavaDB no suitable driver form JSP....

From: Tom Mueller <tom.mueller_at_oracle.com>
Date: Mon, 10 Jan 2011 17:20:37 -0600

Has anyone investigated why the tests that were run to validate revision
41690 worked, but this application doesn't?

Tom

On 1/10/2011 3:38 PM, Kin-man Chung wrote:
> I agree. How do we get this on ccc committe's radar?
>
> How can this be fixed, though? Either revision 41690 needs to be
> reverted, or asadmin start-doman needs to do the copying of the jars.
> Either of these would have some performance impact, I am sure.
>
> On 01/10/11 08:32, Tom Mueller wrote:
>> Even though there is no documentation that says that it should work
>> without copying the driver, this still seems to be a regression from
>> 3.0. Shouldn't 15442 be marked as a regression, and the ccc
>> committee should decide whether it is ok to ship with this regression?
>>
>> If many developers are depending on this (non-documented) behavior,
>> this might be a support issue.
>>
>> Tom
>>
>>
>> On 1/10/2011 10:25 AM, Doug Donahue wrote:
>>> On 1/10/11 10:36 AM, Tom Mueller wrote:
>>>> Doug,
>>>> Please open an issue for this and attach the app to the issue.
>>>> Also, provide information about how the app is configured when it
>>>> is not working.
>>>>
>>>> Thanks.
>>>> Tom
>>>
>>> I am sorry I should have update this mailing. I filed a bug it has
>>> been closed. It appears that they expect this to happen. You need to
>>> copy the the jars over to the lib directory for them to be accessible.
>>>
>>> GLASSFISH-15442: No suitable driver found for
>>> jdbc:derby://localhost:1527/derbyDB;create=true
>>> https://java.net/jira/browse/GLASSFISH-15442
>>>
>>> --Doug
>>>>
>>>>
>>>> On 1/4/2011 8:26 AM, Doug Donahue wrote:
>>>>> On 1/3/11 4:25 PM, Tom Mueller wrote:
>>>>>> Is your JSP in docroot or within a web app?
>>>>>>
>>>>>> I wonder if this is related to a performance change that we made
>>>>>> that remove the derby libraries from the launcher class loader of
>>>>>> the app server, and put them only in the common class loader.
>>>>>> This was done in revision 41690 as part of fixing issue 13612.
>>>>>>
>>>>>> Tom
>>>>> Thanks for your reply Tom I did go and read the issue.
>>>>>
>>>>> The JSP pages are in the app. This could be a configuration
>>>>> issue on my end, I fully understand that if this was any other
>>>>> database that I would need to load the drivers in the lib
>>>>> directory. The only reason I did not want to just do that in this
>>>>> case is that we bundle this database with glassfish and I thought
>>>>> it should work out of the box with out having to move jarfiles around.
>>>>>
>>>>> Any thoughts?
>>>>> Doug
>>>>>>
>>>>>> On 1/3/2011 2:45 PM, Doug Donahue wrote:
>>>>>>> When using a the <sql:query> JSTL tag in a JSP page I am seeing
>>>>>>> the following failure.
>>>>>>>
>>>>>>> Could not execute the query SELECT * FROM jstl_tab1
>>>>>>> when using jdbc:derby://localhost:1527/derbyDB;create=true,org.apache.derby.jdbc.ClientDriver,cts1,cts1
>>>>>>> for the dataSource attribute! The Exception that was raised is:javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/derbyDB;create=true
>>>>>>>
>>>>>>>
>>>>>>> Now if I copy /glassfish3/javadb/lib/derbyclient.jar to
>>>>>>> /glassfish3/glassfish/lib/endorsed/ and run the webapp, the
>>>>>>> driver is found with no issues at all.
>>>>>>>
>>>>>>> Should I have to copy this jarfile into the endorsed dir?
>>>>>>>
>>>>>>> Thanks
>>>>>>> Doug
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Oracle <http://www.oracle.com>
>>>>>>> Doug Donahue| Principal Member of Technical Staff | +1.781.442.2089
>>>>>>> Oracle Java Engineering
>>>>>>> 35 Network Drive
>>>>>>> Burlington, MA 01803
>>>>>>> Douglas.Donahue_at_oracle.com
>>>>>>>
>>>>>>> Green Oracle <http://www.oracle.com/commitment> Oracle is
>>>>>>> committed to developing practices and products that help protect
>>>>>>> the environment
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>>
>>>>> Oracle <http://www.oracle.com>
>>>>> Doug Donahue| Principal Member of Technical Staff | +1.781.442.2089
>>>>> Oracle Java Engineering
>>>>> 35 Network Drive
>>>>> Burlington, MA 01803
>>>>> Douglas.Donahue_at_oracle.com
>>>>>
>>>>> Green Oracle <http://www.oracle.com/commitment> Oracle is
>>>>> committed to developing practices and products that help protect
>>>>> the environment
>>>>>
>>>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>> Oracle <http://www.oracle.com>
>>> Doug Donahue| Principal Member of Technical Staff | +1.781.442.2089
>>> Oracle Java Engineering
>>> 35 Network Drive
>>> Burlington, MA 01803
>>> Douglas.Donahue_at_oracle.com
>>>
>>> Green Oracle <http://www.oracle.com/commitment> Oracle is committed
>>> to developing practices and products that help protect the environment
>>>
>>>
>