dev@glassfish.java.net

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

From: Tom Mueller <tom.mueller_at_oracle.com>
Date: Mon, 10 Jan 2011 09:36:42 -0600

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


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
>
>