persistence@glassfish.java.net

Re: entity-persistence test testDDLJoinTableSchema on Oracle databases

From: Markus Fuchs <Markus.Fuchs_at_Sun.COM>
Date: Tue, 05 Jun 2007 16:49:43 -0700

Hi Tom,

I updated the test to log an extra message in case of RuntimeExceptions.
The updated test suite and sample output are attached.

Thanks,

-- markus.

Tom Ware wrote:
> Hi Markus,
>
> Is it possible to have the test output this solution when it fails?
> e.g. a message that says: "some databases require that you create a
> new user called MYSCHEMA"
>
> -Tom
>
> Markus Fuchs wrote:
>
>> Hi all,
>>
>> Issues 2821 and 3001
>>
>> https://glassfish.dev.java.net/issues/show_bug.cgi?id=2821
>> https://glassfish.dev.java.net/issues/show_bug.cgi?id=3001
>>
>> described one issue involving tables created in database schemas
>> different from the user's default schema. To ensure that this
>> situation works correctly, the test testDDLJoinTableSchema creates and
>> uses tables in a schema named "MYSCHEMA".
>>
>> Errors during the table creation phase for entity-persistence-tests
>> are silently ignored, and the test might fail because of missing
>> tables. To run this test successfully on Oracle databases, a new
>> database user "MYSCHEMA" should be created. This makes sure the tables
>> used by the test will be created and dropped successfully.
>>
>> Thanks,
>>
>> -- markus.