Hi Tom,
I'm now even more confused... the reserved word should fail every time, but
I saw it once, you saw it periodically, and Martin had it fixed by recreating
the database...
Are there any settings that affect which value is picked up for the table name?
thanks,
-marina
Tom Ware wrote:
> Hi Marina,
>
> I have tracked down the issue.
>
> There is a small fix to one XML file that was causing the reserved word
> "NUMBER" to be used in a table create. I have also filed the
> ENHANCEMENT request below:
>
> https://glassfish.dev.java.net/issues/show_bug.cgi?id=1346
>
> The fix will appear in my upcoming check-in.
>
> -Tom
>
> Tom Ware wrote:
>
>> Hi Marina,
>>
>> I just ran again and seem to be getting these errors periodically.
>> I'll take a look and see what I can find out.
>>
>> -Tom
>>
>> Tom Ware wrote:
>>
>>
>>
>>> I just ran again on an empty DB. I still get no errors. If you need
>>> some help debugging, you could turn on logging and send me the
>>> results file. (FYI: you have to bump your VM memory for all the
>>> tests to run - try ANT_OPTS=-Xmx256m)
>>>
>>> -Tom
>>>
>>> Marina Vatkina wrote:
>>>
>>>
>>>
>>>
>>>
>>>> Tom,
>>>>
>>>> The following tests failed the 1st time (may be it'll give some clue):
>>>> testPrimaryKeyUpdate
>>>> testPrimaryKeyUpdateSameValue
>>>> testPrimaryKeyUpdatePKFK
>>>> testCascadeMergeDetached
>>>> testCascadeMergeManaged
>>>> testCascadePersistToNonEntitySubclass
>>>>
>>>> thanks,
>>>> -marina
>>>>
>>>> Tom Ware wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> Marina,
>>>>>
>>>>> I am not seeing these errors.
>>>>>
>>>>> The fix was to enable DDL generation for the main persistence unit
>>>>> used by the tests. This should create the table, so I am a bit
>>>>> surprised it is breaking since DDL generation happens right at
>>>>> deploy time.
>>>>>
>>>>> -Tom
>>>>>
>>>>> Marina Vatkina wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>> Team,
>>>>>>
>>>>>> We are again at the same problem (am I the only one suffering from
>>>>>> them?):
>>>>>> a table is not created on the 1st run (subsequent run produces 0
>>>>>> errors).
>>>>>>
>>>>>> Internal Exception: java.sql.SQLException: ORA-00942: table or
>>>>>> view does not exist.
>>>>>> Error Code: 942
>>>>>> Call:UPDATE CMP3_EMPLOYEE_SEQ SET SEQ_COUNT = SEQ_COUNT + ? WHERE
>>>>>> SEQ_NAME = ?
>>>>>> bind => [50, EMPLOYEE_SEQ]
>>>>>>
>>>>>> Tom, which steps are missing for those problems? Let's put a
>>>>>> warning into the
>>>>>> readme.
>>>>>>
>>>>>> thanks,
>>>>>> -marina
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>