Hi Wonseok,
yes, "ant clean-db" does the trick! I did run the tests on a clean 10XE
database which is why I did not see the errors there.
Thanks for the info and sorry for the false alarm.
Regards Michael
> 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
> <mailto: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
>
>