The issue has been tracked down. I have entered GlassFish bug 982 and
intend to include a solution to it in a check-in I am in the process of
working on.
-Tom
Tom Ware wrote:
>I'll take a look.
>
>-Tom
>
>Sanjeeb Kumar Sahoo wrote:
>
>
>
>>Ran tests with a clean workspace and got same results. So something is
>>broken...
>>
>>Thanks,
>>Sahoo
>>Sanjeeb Kumar Sahoo wrote:
>>
>>
>>
>>
>>>My entity-persistence-test and entity-persistence modules are
>>>up-to-date. I have made some changes to my local workspace, but I
>>>don't see how that can cause the following failure:
>>>
>>>Testcase: testAnyAndAll took 0.016 sec
>>> Caused an ERROR
>>>
>>>
>>>Internal Exception: org.apache.derby.client.am.SqlException: Subquery
>>>is only allowed to return a single column.Error Code: -1
>>>Call:SELECT t0.F_NAME, t0.L_NAME, t0.ID_NUMBER, t0.DTYPE, t0.CUBE_ID,
>>>t0.CUBE_CODE, t0.DEPT_NAME, t0.DEPT_ROLE, t0.DEPT_LOCATION FROM
>>>CMP3_SCIENTIST t0 WHERE EXISTS (SELECT t1.F_NAME, t1.L_NAME,
>>>t1.ID_NUMBER, t1.DTYPE, t1.CUBE_ID, t1.CUBE_CODE, t1.DEPT_NAME,
>>>t1.DEPT_ROLE, t1.DEPT_LOCATION FROM CMP3_SCIENTIST t1 WHERE
>>>(((t0.F_NAME = t1.F_NAME) AND (t0.L_NAME = t1.L_NAME)) AND
>>>(t0.ID_NUMBER = t1.ID_NUMBER)))
>>>Query:ReportQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.compositepk.Scientist)
>>>
>>> at
>>>oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
>>>
>>> at
>>>oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
>>>
>>> at
>>>oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>>>
>>> at
>>>oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
>>>
>>>
>>>Tests are run against JavaDB. Is this a known failure?
>>>
>>>Thanks,
>>>Sahoo
>>>
>>>
>>>
>>>
>
>
>