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
-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
>>
>>
--
Tom Ware
Principal Software Engineer
Oracle Canada Inc.
Direct: (613) 783-4598
Email: tom.ware_at_oracle.com