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
>>
>>
--
Tom Ware
Principal Software Engineer
Oracle Canada Inc.
Direct: (613) 783-4598
Email: tom.ware_at_oracle.com