I will remove the test again.
-Tom
Andrei Ilitchev wrote:
>It's https://glassfish.dev.java.net/issues/show_bug.cgi?id=1451
>----- Original Message -----
>From: "Michael Bouschen" <Michael.Bouschen_at_Sun.COM>
>To: <persistence_at_glassfish.dev.java.net>
>Sent: Friday, December 08, 2006 10:34 AM
>Subject: entity-persistence-test failure on derby
>
>
>
>
>>Hi,
>>
>>I experience a failure with
>>EntityManagerJUnitTestSuite.testUpdateUsingTempStorage when running the
>>entity-persistence-test on derby:
>>Testcase: testUpdateUsingTempStorage took 0,125 sec
>> FAILED
>>Exception thrown: class
>>oracle.toplink.essentials.exceptions.DatabaseException
>>junit.framework.AssertionFailedError: Exception thrown: class
>>oracle.toplink.essentials.exceptions.DatabaseException
>> at
>>oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorage(EntityManagerJUnitTestSuite.java:3187)
>> ...
>>
>>On line 3181 test method testUpdateUsingTempStorage executes a bulk update
>>query:
>> UPDATE Employee e set e.salary = e.roomNumber, e.roomNumber = e.salary,
>>e.address = null where e.firstName = '" + firstName + "'"
>>This results in a DatabaseException:
>> [junit] Internal Exception: org.apache.derby.client.am.SqlException:
>>Syntax error: Encountered "NULL" at line 1, coumn 111.Error Code: -1
>> [junit] Call:INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, VERSION,
>>ADDR_ID, ROOM_NUM) SELECT t0.EMP_ID, (t0.VERSIO + 1), NULL, t1.SALARY FROM
>>CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME =
>>'testUpdateUsingTempStorage') AND (t1.MP_ID = t0.EMP_ID))
>>
>>All the tests succeed when running on oracle. Any idea?
>>
>>Regards Michael
>>
>>
>>