users@glassfish.java.net

Re: Derby 10.2.1.6 doesn't work with GF v2 B25

From: David Harrigan <dharrigan_at_gmail.com>
Date: Fri, 10 Nov 2006 12:53:22 -0800 (PST)

Hi Kedar,

Thanks for the update. I'll certainly try that. However, if it works (and I
suspect that it will work), shouldn't the emphasis be on getting this
supported version of Derby/JavaDB into Glassfish v2 before the feature
freeze happening shortly? From my own experiments with Derby 10.1.3.1
and Derby 10.2.1.6 it appears that the upgrade is painless (provided that
the db is recreated using the new version of Derby - all existing
functionality
works as before).

I'm saying this because I'm really excited to be using Derby with Java and
to have Glassfish support the offically released version for 9.1 would be
quite simply awesome! :-)

-=david=-


Kedar Mhaswade wrote:
>
> Hello David,
>
> I am not a 100 % sure, but your guess appears right.
> The server runtime uses the javadb jars (actually it
> should only use derby.jar and its locale-specific equivalents).
> This is because runtime needs an embedded database for
> ejb-timers. (See $domain-dir/lib/databases/ejb-timer).
>
> It looks to me that the Embedded Driver that application
> server loads does not know how to load the database created
> by a higher javadb version.
>
> Even if I suggested you to "override" the javadb jars that the
> runtime uses by using classpath-prefix, the problem will remain,
> because the ejb-timer database will be created with an older
> javadb jars and if that database can not be loaded, server doesn't start.
>
> Can you try:
> - back the current javadb software up.
> - make <install-dir>/javadb point to the latest version.
> - *create a new domain*, using asadmin create-domain command, enter
> the master password as "changeit" upon prompted, call the domain say
> "new".
> - start the domain: "asadmin start-domain new"
>
> Note that the new domain creation process uses the latest javadb jars
> to create the embedded ejb-timer database.
>
> Now deploy the application that has packaged database.
> My guess is that it will work this time.
>
> Regards,
> Kedar
>
> David Harrigan wrote:
>> Hi,
>>
>> I posted this on the Forums, but no feedback, and I've logged a bug. I
>> think
>> this is quite an important issue that affects the adoption of the latest
>> stable released version of Derby with GF. It's also quite serious in the
>> fact that 10.2.1.6 is the officially supported version from Sun as well!
>> Here are the URLs (I've recently tested this with B25 and the same issue
>> applies):
>>
>> http://forums.java.net/jive/thread.jspa?threadID=19077
>> https://glassfish.dev.java.net/issues/show_bug.cgi?id=1305
>>
>> I've got a packaged database (jar) in my WEB-INF/lib dir that was created
>> from the released 10.2.1.6 version of derby. I'm trying to open up the
>> database using this supported protocol:
>>
>> jdbc:derby:classpath:searchdb.jar
>>
>> However, I'm getting an exception back:
>>
>> SQL Exception: Catalogs at version level 'null' cannot be upgraded to
>> version level '10.1'.
>>
>> Now, that's the problem, this is what I know:
>>
>> Recreating and repackaging my database as 10.1.3.1 version works fine
>> (i.e.,
>> my app boots).
>>
>> Is this because 10.1.3.1 of Derby jars (derbyclient) is in the classpath?
>> I
>> notice it's in the javadb directory.
>>
>> -=david=-
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>
>

-- 
View this message in context: http://www.nabble.com/Derby-10.2.1.6-doesn%27t-work-with-GF-v2-B25-tf2607374.html#a7285007
Sent from the java.net - glassfish users mailing list archive at Nabble.com.