persistence@glassfish.java.net

Re: entity-persistence test testDDLJoinTableSchema on Oracle databases

From: Markus Fuchs <Markus.Fuchs_at_Sun.COM>
Date: Wed, 06 Jun 2007 12:16:24 -0700

Thanks! I checked in.

-- markus.

Tom Ware wrote:
> Looks good.
>
> Thanks,
> Tom
>
> Markus Fuchs wrote:
>
>> 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.
>>>