Hi Wonseok,
I am also having trouble reproducing the issue you are seeing. When
you run the type tests, it is important that the JDBC driver version and
the DB version match. Is there a chance you are running with mismatched
versions?
-Tom
Michael Bouschen wrote:
> 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
>>
>>
>