Hi Tom,
There is no equivalent of "cascade constraints" on Derby. Since this
needs to be done only once, we should be able to manually delete
constraints if required :).
Thanks,
Mitesh
Michael Bouschen wrote:
> Hi Tom,
>
>> I believe there are two tables that should be dropped:
>>
>> cmp3_employee
>> cmp3_project
>>
>> The following sql statements can be run in a script on Oracle. I am
>> not sure what the equivalent Derby functionality is to "cascade
>> constraints".
>>
>> drop table cmp3_employee cascade constraints
>> drop table cmp3_project cascade constraints
>
> yes, I could successfully run the tests from entity-persistence-tests
> after dropping the two tables.
>
> Thanks!
>
> Regards Michael
>
>>
>> -Tom
>> Michael Bouschen wrote:
>>
>>> Hi,
>>>
>>> just a heads-up:
>>>
>>> Tom's changes include modifications of the persistent classes used
>>> by the tests from entity-persistence-tests, which leads to a
>>> different DB schema. He also updated the code that drops and creates
>>> the schema, but if you run this against an existing schema it does
>>> not drop all the old tables. This might lead to failures when
>>> running the tests from entity-persistence-tests (e.g. CREATE TABLE
>>> failures, etc.).
>>>
>>> Tom is working on a script dropping the old schema which you need to
>>> run once for cleanup.
>>>
>>> Regards Michael
>>>
>>>
>>>
>>>
>>>> The following updates have been checked in to GlassFish.
>>>>
>>>> Issue number: entity-peristence update
>>>> Obtained from: TopLink
>>>> Submitted by: Tom Ware
>>>> Reviewed by: TopLink Team
>>>>
>>>> - added 3 tests to
>>>> oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.java
>>>> for bug 4681769
>>>> - added test testPersistOnRegisteredObject() that was missed in
>>>> last transaction, files affected
>>>> oracle.toplink.essentials.testing.tests.cmp3.advanced.CallbackEventJUnitTestSuite
>>>>
>>>> - Annotation updates to the proposed final draft. @Inheritance -
>>>> discriminatorType() and discriminatorValue() were removed.
>>>> @DiscriminatorColumn - added discriminatorType() and also note that
>>>> the discriminator column now defaults to DTYPE instead of TYPE.
>>>> @DiscriminatorValue - new annotation to replace the
>>>> discriminatorValue() removed from @Inheritance.
>>>> - Annotation updates to the proposed final draft. Mapping
>>>> annotations cannot be applied to fields or properties that are
>>>> transient or Transient.
>>>> - EM.getFlushMode() API and Update Extended EM API to be txn agnostic.
>>>> - Fixed issue with spaces in persistence jar paths
>>>> - Annotation updates to the proposed final draft. @Entity,
>>>> @Embedded - access() removed. @EmbeddableSuperclass was renamed to
>>>> @MappedSuperclass and access() was removed.
>>>> - Changed test table names and generator names (added XML to names)
>>>> to avoid problems with annotation tests that use same/similar models.
>>>> - Couple fixes to @JoinColumn defaulting for M-M mappings.
>>>> - Annotation updates to the proposed final draft. No actual
>>>> annotation changes done, process related changes only. Namely
>>>> defaulting and valitation of PrimaryKeyJoinColumns. Annotations
>>>> that use them are @Inheritance and @SecondaryTable.
>>>> - Refactored the XML processor to accomodate the latest version of
>>>> the XML descriptor schema - most of the changes dealt with attributes
>>>> - More testing for the @JoinColumn defaulting.
>>>> - Annotation updates to the proposed final draft. No actual
>>>> annotation changes has been done this transaction only process
>>>> related changes. Namely section 2.1.8, defaulting of JoinColumns on
>>>> 1-1, M-1, 1-M and M-M (through a JoinTable). Addresses GlassFish
>>>> issue 135 and 145. Rudamentary testing down, more should be performed.
>>>> - MODIFY ALL QUERY
>>>> - Fixed Issue Tracker #161
>>>> - Updates for Issue Tracker #117 and #150
>>>>
>>
>>