Re: entity-persistence test testDDLJoinTableSchema on Oracle databases
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.
>>