persistence@glassfish.java.net

Re: 6 failures in the unit tests?

From: Tom Ware <tom.ware_at_oracle.com>
Date: Thu, 19 Oct 2006 15:45:56 -0400

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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>
>>
>>
>>
>
>
>
>