persistence@glassfish.java.net

Re: Some tests in JUnitEJBQLDateTimeTestSuite failed on Oracle

From: Wonseok Kim <guruwons_at_gmail.com>
Date: Mon, 18 Dec 2006 20:30:22 +0900

The two tests (testDDLUniqueKeysAsJoinColumns and
testDDLSubclassEmbeddedIdPkColumnsInJoinedStrategy) fails because my last
checked-in changed table name and column type of some entities.

It will be okay if you run "ant clean-db" (clear existing tables and
constraints). Really sorry for that.
Every others maybe should clean existing tables (at least DDL_* tables) once
due to remaining constraints(otherwise recreating DDL_CKENTB table fails).

Regards,
-Wonseok

On 12/18/06, Michael Bouschen <Michael.Bouschen_at_sun.com> wrote:
>
> Hi Wonseok,
>
> I tried to reproduce the error, but the date tests succeed on my side.
>
> However, the specific version of the oracle database server and the jdbc
> driver matters! I see two ddl test errors (testDDLUniqueKeysAsJoinColumns
> and testDDLSubclassEmbeddedIdPkColumnsInJoinedStrategy) when running on an
> oracle database 9.2.0.7.0 and an oracle JDBC driver 9.0.2.0.0. A SQL
> INSERT statement on table DDL_CKENTB fails: ORA-01438: value larger than
> specified precision allows for this column.
>
> I also tried different combinations of oracle database server and jdbc
> driver, but they all succeed:
> - 9.2.0.7.0 database server with 10.2.0.1.0XE jdbc driver
> - 10XE (10.2.0.1.0) database server and 9.0.2.0.0 jdbc driver
> - 10XE (10.2.0.1.0) database server and 10.2.0.1.0XE jdbc driver
>
> In case you are interested, you find the output of the failing ddl tests
> below.
>
> Regards Michael
>