persistence@glassfish.java.net

Re: entity-persistence test testDDLJoinTableSchema on Oracle databases

From: Tom Ware <tom.ware_at_oracle.com>
Date: Tue, 05 Jun 2007 08:59:38 -0400

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.