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: Mon, 13 Nov 2006 02:17:42 -0800 (PST)

Hi Kedar,

Yes, doing this procedure enables my application to work with Derby
10.2.1.6. I
would say that if JavaDB bundled with the build of GF were upgraded to the
latest
version, and tests run against it, it should prove that all works fine, so
the next
build (b26/7?) could include it.

-=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#a7314393
Sent from the java.net - glassfish users mailing list archive at Nabble.com.