dev@glassfish.java.net

Re: SQLAnywherePlatform Status Update

From: Markus KARG <markus.karg_at_gmx.net>
Date: Tue, 09 Jan 2007 21:30:07 +0100

Lance J. Andersen schrieb:
> These results look pretty good overall and most of the failures
> should be able to be addressed pretty easily.
>
> Thanks for forwarding.
>
> Markus, Were your failures different?
>
> -lance
If you like to compare it, find the results of jConnect 6 on
SQLAnywhere10 (using my implementation of SQLAnywherePlatform) attached.

Have Fun
Markus
>
>
>
> Mitesh Meswani wrote:
>> FWIW, Attached are results for a run of entity-persistence-tests
>> against Sybase 15 and jconn 5.5.
>>
>> getDatabaseProductName():Adaptive Server Enterprise
>> getDatabaseProductVersion():Adaptive Server Enterprise/15.0/EBF 12783
>> GA/P/NT (IX86)/Windows 2000/ase150/2158/32-bit/OPT/Fri Aug 19
>> 18:42:50 2005
>> getDriverName():jConnect (TM) for JDBC (TM)
>> getDriverVersion():jConnect (TM) for JDBC(TM)/5.5(Build
>> 25252)/P/EBF11656/JDK12/Mon Dec 15 11:55:23 2003
>>
>> The run was done on 12/1/2006 with the code in trunk as of then
>>
>> Regards,
>> Mitesh
>>
>> Markus KARG wrote:
>>> Tom,
>>>> My concern related to checking in the current code is that there is
>>>> already a SQLAnywherePlatform. As Markus has correctly pointed
>>>> out, his design makes more sense because the current implementation
>>>> is a subclass of the SybasePlatform and that does not reflect the
>>>> reality of how SQLAnywhere is designed. For the JConnect case,
>>>> however, the fact that we are currently a subclass of
>>>> SybasePlatform likely benefits us.
>>> As I wrote before, jConnect is not able to access every SQLAnywhere
>>> database instance. The administrator must have enabled support for
>>> jConnect inside of the database instance, and (AFAIK) you must
>>> enable ASE emulation mode. After that, it is no more a "pure"
>>> SQLAnywhere database (in the sense of its vendor, iAnywhere company,
>>> a Sybase subsidiary). I understand your issues but see, what I
>>> implemented is "pure iAnywhere" (it supports everything that is in
>>> the box, but only that). If you want to provide more (that is not in
>>> the box) just of the reason that you did it before, then I do not
>>> see a big problem in telling people "hey, you're doing things that
>>> are not in the box, so YOU have to change over that the renamed, old
>>> platform). That's why I think MY platform should be called
>>> SQLAnywherePlatform (it does what is in the box), while the OLD
>>> SQLAnyWherePlatform should be renamed to "LegacySQLAnyWherePlatform"
>>> or something. Just to make clear what the truth is. For future,
>>> jConnect support should be added, but we have to carefully decide
>>> where to put it. Either in an inner class of my new platform, or in
>>> a separate platform, or (my favorite) make TopLink learn that a
>>> driver and a dbms are two different things and such can be in N:M
>>> combinations -- split up DatabasePlatform into a driver part and a
>>> dbms part.
>>>> Perhaps we could rename Markus' version of the platform to reflect
>>>> the fact that is only covers the iAnywhere software, but I am
>>>> somewhat concerned about adding extra classes if they are not
>>>> needed since if we have too many platforms, it may become difficult
>>>> for users to know what to use. Do you think it would make sense to
>>>> users that we would represent SQLAnywhere in two different platforms?
>>> Yes. Because mine is what is in the original SQLAnywhere product box
>>> and everything else is some kind of "handicrafts" made up switching
>>> around database options and installing a driver that has to be
>>> pulled manually somewhere on the Sybase web site (the holding, not
>>> the SQLAnywhere vendor actually -- if you buy SQLAnywhere today, on
>>> the box is not a Sybase Logo but an iAnywhere Logo; while on the
>>> jConnect driver there is a Sybase Logo but not an iAnywhere logo;
>>> just to make it clear once more). ;-)
>>>> As far as testing is concerned, the TopLink Essentials product has
>>>> had limited testing with Sybase. The full TopLink product,
>>>> however, uses basically the same platform code and has run through
>>>> extensive testing on SybaseASE 12.5 using the JConnect 5.5 driver.
>>> I think it is good advice to let run all the tests again with
>>> jConnect 6.0.5 since from the major version number change I could
>>> imagine that there had been numerous changes.
>>>
>>> Have Fun
>>> Markus
>> ------------------------------------------------------------------------
>>
>> Testsuite: oracle.toplink.essentials.testing.tests.FullRegressionTestSuite
>> Tests run: 548, Failures: 4, Errors: 32, Time elapsed: 145.937 sec
>>
>> Testcase: testNamedNativeQuery took 0.047 sec
>> Testcase: testPersistThenRemoveCalls took 0.281 sec
>> Testcase: testRemoveUnmanagedNewEntity took 0.109 sec
>> Testcase: testPersistOnRegisteredObject took 0.094 sec
>> Testcase: testPreUpdateEvent_UpdateAltered took 0.141 sec
>> Testcase: testPreUpdateEvent_UpdateReverted took 0.14 sec
>> Testcase: testRefreshNotManaged took 0 sec
>> Testcase: testRefreshRemoved took 0.188 sec
>> Testcase: testCacheUsage took 0.063 sec
>> Testcase: testContainsRemoved took 0.062 sec
>> Testcase: testFlushModeEmAutoQueryCommit took 0.047 sec
>> Testcase: testFlushModeEmAuto took 0.078 sec
>> Testcase: testFlushModeEmAutoQueryAuto took 0.063 sec
>> Testcase: testFlushModeEmCommitQueryCommit took 0.047 sec
>> Testcase: testFlushModeEmCommit took 0.031 sec
>> Testcase: testFlushModeEmCommitQueryAuto took 0.078 sec
>> Testcase: testFlushModeOnUpdateQuery took 0.125 sec
>> Testcase: testSetRollbackOnly took 0.141 sec
>> Testcase: testSubString took 0.093 sec
>> Testcase: testDatabaseSyncNewObject took 0 sec
>> Testcase: testTransactionRequired took 0 sec
>> Testcase: testIdentityInsideTransaction took 0.016 sec
>> Testcase: testIdentityOutsideTransaction took 0 sec
>> Testcase: testIgnoreRemovedObjectsOnDatabaseSync took 0.219 sec
>> Testcase: testREADLock took 0.109 sec
>> Testcase: testPersistRemoved took 1.953 sec
>> Testcase: testPersistManagedException took 0.032 sec
>> Testcase: testPersistManagedNoException took 0.062 sec
>> Testcase: testRemoveFlushPersistContains took 0.141 sec
>> Testcase: testRemoveFlushFind took 0.125 sec
>> Testcase: testFindWithWrongTypePk took 0 sec
>> Testcase: testFindWithNullPk took 0 sec
>> Testcase: testCheckVersionOnMerge took 0.062 sec
>> Testcase: testClear took 0.031 sec
>> Testcase: testClearWithFlush took 0.079 sec
>> Testcase: testClearInTransaction took 0.046 sec
>> Testcase: testExtendedPersistenceContext took 0.454 sec
>> Testcase: testReadTransactionIsolation_CustomUpdate took 0.156 sec
>> Testcase: testReadTransactionIsolation_CustomUpdate_Flush took 0.14 sec
>> Testcase: testReadTransactionIsolation_CustomUpdate_Refresh took 0.157 sec
>> Testcase: testReadTransactionIsolation_CustomUpdate_Refresh_Flush took 0.172 sec
>> Testcase: testReadTransactionIsolation_UpdateAll took 0.156 sec
>> Testcase: testReadTransactionIsolation_UpdateAll_Flush took 0.14 sec
>> Testcase: testReadTransactionIsolation_UpdateAll_Refresh took 0.157 sec
>> Testcase: testReadTransactionIsolation_UpdateAll_Refresh_Flush took 0.172 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate took 0.171 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Flush took 0.141 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh took 0.156 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh_Flush took 0.172 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll took 0.141 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Flush took 0.14 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh took 0.157 sec
>> Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh_Flush took 0.172 sec
>> Testcase: testFindDeleteAllPersist took 0.234 sec
>> Testcase: testWRITELock took 0.094 sec
>> Testcase: testEMFWrapValidationException took 0.25 sec
>> Testcase: testEMDefaultTxType took 0.297 sec
>> Testcase: testPersistOnNonEntity took 0 sec
>> Testcase: testClose took 0 sec
>> Testcase: testBeginTransactionClose took 0 sec
>> Testcase: testBeginTransactionCloseCommitTransaction took 0.109 sec
>> Testcase: testPersistenceProperties took 0 sec
>> Testcase: testMultipleFactories took 1.891 sec
>> Testcase: testParallelMultipleFactories took 0 sec
>> Testcase: testQueryHints took 0 sec
>> Testcase: testQueryOnClosedEM took 0 sec
>> Testcase: testNullifyAddressIn took 0.031 sec
>> Testcase: testLeftJoinOneToOneQuery took 0.015 sec
>> Testcase: testSerializedLazy took 0.172 sec
>> Testcase: testOracleSequenceDefinition took 0 sec
>> Testcase: testMergeDetachedObject took 0.078 sec
>> Testcase: testMergeRemovedObject took 0.063 sec
>> Testcase: testMergeNull took 0 sec
>> Testcase: testPersistNull took 0 sec
>> Testcase: testContainsNull took 0 sec
>> Testcase: testRemoveNull took 0 sec
>> Testcase: testCreateEntityManagerFactory took 0 sec
>> Testcase: testCreateEntityManagerFactory2 took 0.016 sec
>> Testcase: testPrimaryKeyUpdate took 0.062 sec
>> Testcase: testPrimaryKeyUpdateSameValue took 0.016 sec
>> Testcase: testPrimaryKeyUpdatePKFK took 0.062 sec
>> Testcase: testCascadeMergeDetached took 0.11 sec
>> Testcase: testCascadeMergeManaged took 0.109 sec
>> Testcase: testCascadePersistToNonEntitySubclass took 0.031 sec
>> Testcase: testInitializeFieldForPropertyAccess took 0.094 sec
>> Testcase: testSetFieldForPropertyAccess took 0.094 sec
>> Testcase: testSetFieldForPropertyAccessWithRefresh took 0.14 sec
>> Testcase: testSetFieldForPropertyAccessWithNewEM took 0.11 sec
>> Testcase: testDeleteAllPhonesWithNullOwner took 0.031 sec
>> Testcase: testDeleteAllProjectsWithNullTeamLeader took 0.141 sec
>> Testcase: testDeleteAllSmallProjectsWithNullTeamLeader took 0.093 sec
>> Testcase: testDeleteAllLargeProjectsWithNullTeamLeader took 0.125 sec
>> Testcase: testInheritanceNoDiscriminatorColumn took 0.016 sec
>> Testcase: testComplicateResultWithInheritance took 0.109 sec
>> Testcase: testRefresh took 0.125 sec
>> Testcase: testBindParameters took 0.031 sec
>> Testcase: testBindParametersWithPostitional took 0.032 sec
>> Testcase: testSimpleInheritance took 0.062 sec
>> Testcase: testPessimisticLocking took 0.031 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure.
>> Error Code: 7305
>> Call:SELECT t0.PROJ_ID, t0.PROJ_TYPE, t0.PROJ_NAME, t0.DESCRIP, t0.LEADER_ID, t0.VERSION FROM CMP3_PROJECT t0 WHERE t0.PROJ_ID = 6 FOR UPDATE
>> Query:ResultSetMappingQuery()
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure.
>> Error Code: 7305
>> Call:SELECT t0.PROJ_ID, t0.PROJ_TYPE, t0.PROJ_NAME, t0.DESCRIP, t0.LEADER_ID, t0.VERSION FROM CMP3_PROJECT t0 WHERE t0.PROJ_ID = 6 FOR UPDATE
>> Query:ResultSetMappingQuery()
>> 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.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
>> at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:252)
>> at oracle.toplink.essentials.queryframework.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:198)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.testing.tests.cmp3.advanced.SQLResultSetMappingTestSuite.testPessimisticLocking(SQLResultSetMappingTestSuite.java:229)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 35 more
>>
>> Testcase: testComplicateResults took 0 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'manager_EMP_ID'.
>> Error Code: 207
>> Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.F_NAME, t0.L_NAME, t0.VERSION, t1.SALARY, t0.START_DATE AS STARTDATE, t0.END_DATE, t0.ADDR_ID AS EMP_ADDR, t0.manager_EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t1.EMP_ID = t0.EMP_ID) AND ( t0.L_NAME = 'Smith' ))
>> Query:ResultSetMappingQuery()
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'manager_EMP_ID'.
>> Error Code: 207
>> Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.F_NAME, t0.L_NAME, t0.VERSION, t1.SALARY, t0.START_DATE AS STARTDATE, t0.END_DATE, t0.ADDR_ID AS EMP_ADDR, t0.manager_EMP_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t1.EMP_ID = t0.EMP_ID) AND ( t0.L_NAME = 'Smith' ))
>> Query:ResultSetMappingQuery()
>> 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)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:252)
>> at oracle.toplink.essentials.queryframework.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:198)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.testing.tests.cmp3.advanced.SQLResultSetMappingTestSuite.testComplicateResults(SQLResultSetMappingTestSuite.java:262)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'manager_EMP_ID'.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 34 more
>>
>> Testcase: testProjectJoinTeamMembers took 1.219 sec
>> Testcase: testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull took 1.343 sec
>> Testcase: testProjectJoinTeamMembersJoinAddress took 1.125 sec
>> Testcase: testProjectOuterJoinTeamMembersJoinAddress took 1.063 sec
>> Testcase: testProjectOuterJoinTeamMembersOuterJoinAddress took 0.984 sec
>> Testcase: testProjectJoinTeamMembersOuterJoinAddress took 1.063 sec
>> Testcase: testProblemReporterProjectJoinTeamMembersJoinAddress took 0.781 sec
>> Testcase: testEmployeeJoinProjects took 0.906 sec
>> Testcase: testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull took 0.828 sec
>> Testcase: testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName took 0.922 sec
>> Testcase: testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones took 1.828 sec
>> Testcase: testEmployeeJoinManagerAddressOuterJoinManagerAddress took 0.735 sec
>> Testcase: testTwoUnrelatedResultWithOneToManyJoins took 0.75 sec
>> Testcase: testMultipleUnrelatedResultWithOneToManyJoins took 1.187 sec
>> Testcase: testTwoUnrelatedResultWithOneToOneJoins took 1.266 sec
>> Testcase: testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem took 1.015 sec
>> Testcase: testSimpleReturnDirectToField took 0.016 sec
>> Testcase: testSimpleReturnObject took 0.031 sec
>> Testcase: testReturnObjectAndDirectToField took 0.032 sec
>> Testcase: testReturnUnrelatedObjectAndDirectToField took 0.046 sec
>> Testcase: testInheritanceMultiTableException took 0.016 sec
>> Testcase: testReturnRootObject took 0.047 sec
>> Testcase: testExtendedPersistenceContext took 0.031 sec
>> Testcase: testSimpleConstructorExpression took 0.016 sec
>> Testcase: testSimpleConstructorExpressionWithNamedQuery took 0.015 sec
>> Testcase: testMultipleTypeConstructorExpression took 0.016 sec
>> Testcase: testNonExistantConstructorConstructorExpression took 0 sec
>> Testcase: testPrimitiveConstructorExpression took 0.016 sec
>> Testcase: testConstructorEJBQLWithInheritance took 0 sec
>> Testcase: testConstructorExpressionWithOtherAttributes took 0.015 sec
>> Testcase: testCreateProjects took 0.062 sec
>> Testcase: testCreateEmployeeWithFlush took 0.047 sec
>> Testcase: testVersionUpdateWithCorrectValue took 0.031 sec
>> Testcase: testVersionUpdateWithIncorrectValue took 0.047 sec
>> Testcase: testVersionUpdateWithNullValue took 0.031 sec
>> Testcase: unknown took 0 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'ROLE'.
>> Error Code: 156
>> Call:CREATE TABLE CMP3_DEPARTMENT (NAME VARCHAR(40) NOT NULL, ROLE VARCHAR(40) NOT NULL, LOCATION VARCHAR(40) NOT NULL, PRIMARY KEY (NAME, ROLE, LOCATION))
>> Query:DataModifyQuery()
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'ROLE'.
>> Error Code: 156
>> Call:CREATE TABLE CMP3_DEPARTMENT (NAME VARCHAR(40) NOT NULL, ROLE VARCHAR(40) NOT NULL, LOCATION VARCHAR(40) NOT NULL, PRIMARY KEY (NAME, ROLE, LOCATION))
>> Query:DataModifyQuery()
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>> at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:242)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:222)
>> at oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:71)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:696)
>> at oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:90)
>> at oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:170)
>> at oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:777)
>> at oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:263)
>> at oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:215)
>> at oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:207)
>> at oracle.toplink.essentials.testing.tests.cmp3.advanced.compositepk.AdvancedCompositePKJunitTest$1.setUp(AdvancedCompositePKJunitTest.java:75)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'ROLE'.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1702)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
>> ... 29 more
>>
>> Testcase: testCreateWrapperTypes took 0.062 sec
>> Testcase: testNullifyBigDecimal took 0.016 sec
>> Testcase: testNullifyBigInteger took 0.031 sec
>> Testcase: testNullifyBoolean took 0.031 sec
>> Testcase: testNullifyByte took 0.032 sec
>> Testcase: testNullifyCharacter took 0.031 sec
>> Testcase: testNullifyShort took 0.016 sec
>> Testcase: testNullifyInteger took 0.031 sec
>> Testcase: testNullifyLong took 0.015 sec
>> Testcase: testNullifyFloat took 0.047 sec
>> Testcase: testNullifyDouble took 0.032 sec
>> Testcase: testNullifyString took 0.015 sec
>> Testcase: testCreateByteArrayType took 0.047 sec
>> Testcase: testCreatePrimitiveByteArrayType took 0.047 sec
>> Testcase: testCreateCharacterArrayType took 0.031 sec
>> Testcase: testCreateCharArrayType took 0.047 sec
>> Testcase: testCreateDateTime took 0.062 sec
>> Testcase: testNullifySqlDate took 0.016 sec
>> Testcase: testNullifyTime took 0.031 sec
>> Testcase: testNullifyTimestamp took 0.031 sec
>> Testcase: testNullifyUtilDate took 0.016 sec
>> Testcase: testNullifyCalendar took 0.031 sec
>> Testcase: testCreate took 0.078 sec
>> Testcase: testRead took 0 sec
>> Testcase: testUpdate took 0.031 sec
>> Caused an ERROR
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004.Error Code: 0
>> Call:UPDATE CMP3_IMAGE SET PICTURE = ?, SCRIPT = ? WHERE (ID = ?)
>> bind => [null, null, 1000]
>> Query:UpdateObjectQuery(oracle.toplink.essentials.testing.models.cmp3.lob.Image_at_173089d)
>> javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004.Error Code: 0
>> Call:UPDATE CMP3_IMAGE SET PICTURE = ?, SCRIPT = ? WHERE (ID = ?)
>> bind => [null, null, 1000]
>> Query:UpdateObjectQuery(oracle.toplink.essentials.testing.models.cmp3.lob.Image_at_173089d)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:109)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:45)
>> at oracle.toplink.essentials.testing.tests.cmp3.lob.LobJUnitTestCase.testUpdate(LobJUnitTestCase.java:132)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004.Error Code: 0
>> Call:UPDATE CMP3_IMAGE SET PICTURE = ?, SCRIPT = ? WHERE (ID = ?)
>> bind => [null, null, 1000]
>> Query:UpdateObjectQuery(oracle.toplink.essentials.testing.models.cmp3.lob.Image_at_173089d)
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
>> at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.updateObject(DatasourceCallQueryMechanism.java:675)
>> at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.updateObject(StatementQueryMechanism.java:437)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1166)
>> at oracle.toplink.essentials.queryframework.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:76)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:283)
>> at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:67)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:123)
>> at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:95)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:294)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:180)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:82)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:842)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:90)
>> ... 23 more
>> Caused by: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004.
>> at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:536)
>> at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:840)
>> at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3491)
>> at com.sybase.jdbc2.tds.Tds.language(Tds.java:728)
>> at com.sybase.jdbc2.jdbc.SybStatement.sendQuery(SybStatement.java:1507)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.sendQuery(SybPreparedStatement.java:1206)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1681)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
>> ... 51 more
>>
>> Testcase: testDelete took 0.031 sec
>> Testcase: testPrePersistBusOverrideAndAbstractInheritAndDefault took 0.063 sec
>> Testcase: testPostPersistBusInheritAndDefault took 0.062 sec
>> Testcase: testPostLoadBusInheritAndDefault took 0 sec
>> Testcase: testPrePersistSportsCarInheritAndExcludeDefault took 0.032 sec
>> Testcase: testPostPersistSportsCarInheritAndExcludeDefault took 0.015 sec
>> Testcase: testPrePersistSportsCarOverride took 0.032 sec
>> Testcase: test_null took 3.484 sec
>> Testcase: test_nullNonDeferred took 3.125 sec
>> Testcase: test_ownerTOP took 3.297 sec
>> Testcase: test_fuelTypePetrol took 1.844 sec
>> Testcase: test_schoolBusNullDriver took 0.406 sec
>> Testcase: test_ownerOwnsNonFueledVehicle took 2.032 sec
>> Testcase: testPersistPolymorphicRelationship took 0.047 sec
>> Testcase: testInitialize took 0.093 sec
>> Testcase: test1 took 0.078 sec
>> Testcase: testInitialize took 0.047 sec
>> Testcase: test2 took 0.047 sec
>> Testcase: testInitialize took 0.047 sec
>> Testcase: test3 took 0.078 sec
>> Testcase: testCreateBlue took 0.015 sec
>> Testcase: testReadBlue took 0 sec
>> Testcase: testPreAndPostPersistAlpine took 0.015 sec
>> Testcase: testPreAndPostPersistBeerConsumer took 0.016 sec
>> Testcase: testPostLoadOnFind took 0 sec
>> Testcase: testPostLoadOnRefresh took 0.015 sec
>> Testcase: testPreAndPostUpdate took 0.016 sec
>> Testcase: testPreAndPostRemove took 0.031 sec
>> Testcase: testCreateBeerConsumer took 0.015 sec
>> Testcase: testCreateAlpine took 0.063 sec
>> Testcase: testCreateCanadian took 0.047 sec
>> Testcase: testCreateCertifications took 0.047 sec
>> Testcase: testCreateTelephoneNumbers took 0.062 sec
>> Testcase: testReadBeerConsumer took 0.016 sec
>> Testcase: testReadAlpine took 0.015 sec
>> Testcase: testReadCanadian took 0 sec
>> Testcase: testInsertNewAlpine took 0.078 sec
>> Testcase: testInsertNewAlpineAndModifyOrderOfExistingAlpines took 0.063 sec
>> Testcase: testUpdateAlpine took 0.031 sec
>> Testcase: testUpdateAlpineThroughBeerConsumer took 0.047 sec
>> Testcase: testUpdateBeerConsumer took 0.031 sec
>> Testcase: testUpdateCanadian took 0.016 sec
>> Testcase: testUpdateCanadianThroughBeerConsumer took 0.047 sec
>> Testcase: testUpdateCertifications took 0.094 sec
>> Testcase: testUpdateTelephoneNumberThroughBeerConsumer took 0.031 sec
>> Testcase: testShuffleTelephoneNumbersOnBeerConsumers took 0.094 sec
>> Testcase: testDeleteAlpine took 0.031 sec
>> Testcase: testDeleteCanadian took 0.015 sec
>> Testcase: testDeleteBeerConsumer took 0.063 sec
>> Testcase: testgetReference took 0.703 sec
>> Testcase: testcreateNativeQuery took 0.75 sec
>> Testcase: testcreateNativeQueryWithSelectSQL took 0.828 sec
>> Testcase: testNativeNamedQuery took 0.766 sec
>> Testcase: testSetParameterUsingNull took 0.734 sec
>> Testcase: testLeftTrimWithTrimChar took 0.828 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function LTRIM invoked with wrong number or type of argument(s).
>> Error Code: 11021
>> Call:SELECT CUST_ID, CITY, CUST_VERSION, NAME FROM CMP3_CUSTOMER WHERE (LTRIM(CITY, ?) = ?)
>> bind => [M, anotick]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Customer)
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function LTRIM invoked with wrong number or type of argument(s).
>> Error Code: 11021
>> Call:SELECT CUST_ID, CITY, CUST_VERSION, NAME FROM CMP3_CUSTOMER WHERE (LTRIM(CITY, ?) = ?)
>> bind => [M, anotick]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Customer)
>> 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)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2192)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2170)
>> at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.testLeftTrimWithTrimChar(ExpressionJUnitTestSuite.java:87)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Function LTRIM invoked with wrong number or type of argument(s).
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 33 more
>>
>> Testcase: testTrimWithTrimChar took 0.797 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'FROM'.
>> Error Code: 156
>> Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (TRIM(? FROM NAME) = ?)
>> bind => [i, tem]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'FROM'.
>> Error Code: 156
>> Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (TRIM(? FROM NAME) = ?)
>> bind => [i, tem]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
>> 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)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2192)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2170)
>> at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.testTrimWithTrimChar(ExpressionJUnitTestSuite.java:142)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'FROM'.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 33 more
>>
>> Testcase: testTrimWithoutTrimChar took 0.813 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function 'TRIM' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>> Error Code: 14216
>> Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (TRIM(NAME) = ?)
>> bind => [tem]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function 'TRIM' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>> Error Code: 14216
>> Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (TRIM(NAME) = ?)
>> bind => [tem]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
>> 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)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2192)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2170)
>> at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.testTrimWithoutTrimChar(ExpressionJUnitTestSuite.java:197)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Function 'TRIM' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 33 more
>>
>> Testcase: testLocateWithSingleArgument took 0.765 sec
>> Testcase: testLocateWithDoubleArgument took 0.797 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function 'LOCATE' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>> Error Code: 14216
>> Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (LOCATE(?, NAME, ?) = ?)
>> bind => [i, 2, 5]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function 'LOCATE' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>> Error Code: 14216
>> Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (LOCATE(?, NAME, ?) = ?)
>> bind => [i, 2, 5]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
>> 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)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2192)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2170)
>> at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.testLocateWithDoubleArgument(ExpressionJUnitTestSuite.java:296)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Function 'LOCATE' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 33 more
>>
>> Testcase: testInsertVirtualAttribute took 0.063 sec
>> Testcase: testReadVirtualAttribute took 0.015 sec
>> Testcase: testUpdateVirtualAttribute took 0.032 sec
>> Testcase: testDeleteVirtualAttribute took 0.046 sec
>> Testcase: testCacheIsolation_PropertiesDefault_Config took 0.157 sec
>> Testcase: testCacheIsolation_XMLDefault_Config took 0.156 sec
>> Testcase: testPKClassTypeValidation took 0 sec
>> Testcase: testParameterNameValidation took 0 sec
>> Testcase: testParameterPositionValidation took 0 sec
>> Testcase: testParameterPositionValidation2 took 0 sec
>> Testcase: selfReferencingManyToManyTest took 1 sec
>> Caused an ERROR
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'cCustomers_CUST_ID'.
>> Error Code: 207
>> Call:INSERT INTO CMP3_CUSTOMER_CUSTOMER (cCustomers_CUST_ID, Customer_CUST_ID) VALUES (?, ?)
>> bind => [3, 5]
>> Query:DataModifyQuery()
>> javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'cCustomers_CUST_ID'.
>> Error Code: 207
>> Call:INSERT INTO CMP3_CUSTOMER_CUSTOMER (cCustomers_CUST_ID, Customer_CUST_ID) VALUES (?, ?)
>> bind => [3, 5]
>> Query:DataModifyQuery()
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:109)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:45)
>> at oracle.toplink.essentials.testing.tests.cmp3.relationships.UniAndBiDirectionalMappingTestSuite.selfReferencingManyToManyTest(UniAndBiDirectionalMappingTestSuite.java:91)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'cCustomers_CUST_ID'.
>> Error Code: 207
>> Call:INSERT INTO CMP3_CUSTOMER_CUSTOMER (cCustomers_CUST_ID, Customer_CUST_ID) VALUES (?, ?)
>> bind => [3, 5]
>> Query:DataModifyQuery()
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
>> at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:242)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:222)
>> at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.executeNoSelect(StatementQueryMechanism.java:129)
>> at oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:71)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.mappings.ManyToManyMapping.insertIntoRelationTable(ManyToManyMapping.java:737)
>> at oracle.toplink.essentials.mappings.ManyToManyMapping.performDataModificationEvent(ManyToManyMapping.java:887)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:199)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:82)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:842)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:90)
>> ... 23 more
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'cCustomers_CUST_ID'.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1702)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
>> ... 48 more
>>
>> Testcase: testSelectPhoneNumberAreaCode took 0.015 sec
>> Testcase: testSelectPhoneNumberAreaCodeWithEmployee took 0.063 sec
>> Testcase: testSelectPhoneNumberNumberWithEmployeeWithExplicitJoin took 0.078 sec
>> Testcase: testSelectPhoneNumberNumberWithEmployeeWithFirstNameFirst took 0.062 sec
>> Testcase: testSelectEmployeeWithSameParameterUsedMultipleTimes took 0.047 sec
>> Testcase: testOuterJoinOnOneToOne took 0.078 sec
>> Testcase: testOuterJoinPolymorphic took 0.047 sec
>> Testcase: testFirstResultOnNamedQuery took 0.016 sec
>> Testcase: simpleJoinFetchTest took 0.516 sec
>> Testcase: baseTestCase took 0.422 sec
>> Testcase: simpleABSTest took 0.078 sec
>> Testcase: simpleBetweenAndTest took 0.422 sec
>> Testcase: simpleBetweenTest took 0.437 sec
>> Testcase: simpleConcatTest took 0.079 sec
>> Testcase: simpleConcatTestWithParameters took 0.078 sec
>> Testcase: simpleConcatTestWithConstants1 took 0.109 sec
>> Testcase: simpleDistinctTest took 0.047 sec
>> Testcase: simpleDistinctNullTest took 0.078 sec
>> Testcase: simpleDistinctMultipleResultTest took 0.047 sec
>> Testcase: simpleDoubleOrTest took 0.171 sec
>> Testcase: simpleEqualsBracketsTest took 0.079 sec
>> Testcase: simpleEqualsTest took 0.078 sec
>> Testcase: simpleEqualsTestWithJoin took 0.125 sec
>> Testcase: simpleEqualsWithAs took 0.078 sec
>> Testcase: collectionMemberIdentifierEqualsTest took 0.078 sec
>> Testcase: abstractSchemaIdentifierEqualsTest took 0.094 sec
>> Testcase: abstractSchemaIdentifierNotEqualsTest took 0.39 sec
>> Testcase: simpleInOneDotTest took 0.094 sec
>> Testcase: simpleInTest took 0.078 sec
>> Testcase: simpleLengthTest took 0.078 sec
>> Testcase: simpleLikeTest took 0.078 sec
>> Testcase: simpleLikeTestWithParameter took 0.094 sec
>> Testcase: simpleLikeEscapeTestWithParameter took 0.047 sec
>> Testcase: simpleNotBetweenTest took 0.063 sec
>> Testcase: simpleNotEqualsVariablesInteger took 0.375 sec
>> Testcase: simpleNotInTest took 0.39 sec
>> Testcase: simpleNotLikeTest took 0.391 sec
>> Testcase: simpleOrFollowedByAndTest took 0.078 sec
>> Testcase: simpleOrFollowedByAndTestWithStaticNames took 0.125 sec
>> Testcase: simpleOrTest took 0.141 sec
>> Testcase: simpleParameterTest took 0.093 sec
>> Testcase: simpleParameterTestChangingParameters took 0.172 sec
>> Testcase: simpleReverseAbsTest took 0.094 sec
>> Testcase: simpleReverseConcatTest took 0.078 sec
>> Testcase: simpleReverseEqualsTest took 0.078 sec
>> Testcase: simpleReverseLengthTest took 0.078 sec
>> Testcase: simpleReverseParameterTest took 0.11 sec
>> Testcase: simpleReverseSqrtTest took 0.031 sec
>> Testcase: simpleReverseSubstringTest took 0.078 sec
>> Testcase: simpleSqrtTest took 0.031 sec
>> Testcase: simpleSubstringTest took 0.078 sec
>> Testcase: simpleNullTest took 0.11 sec
>> Testcase: simpleNotNullTest took 0.469 sec
>> Testcase: distinctTest took 0.109 sec
>> Testcase: conformResultsInUnitOfWorkTest took 0.109 sec
>> Testcase: simpleModTest took 0 sec
>> FAILED
>> Warning SQL/Sybase doesnot support MOD function
>> junit.framework.AssertionFailedError: Warning SQL/Sybase doesnot support MOD function
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.simpleModTest(JUnitEJBQLSimpleTestSuite.java:1457)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>>
>> Testcase: simpleIsEmptyTest took 0.032 sec
>> Testcase: simpleIsNotEmptyTest took 0.406 sec
>> Testcase: simpleApostrohpeTest took 0.015 sec
>> Testcase: simpleEscapeUnderscoreTest took 0.032 sec
>> Testcase: simpleEnumTest took 0 sec
>> Testcase: smallProjectMemberOfProjectsTest took 0.25 sec
>> Testcase: smallProjectNOTMemberOfProjectsTest took 0.328 sec
>> Testcase: selectCountOneToOneTest took 0.015 sec
>> Testcase: selectOneToOneTest took 0.016 sec
>> Testcase: selectPhonenumberDeclaredInINClauseTest took 0.219 sec
>> Testcase: selectSimpleMemberOfWithParameterTest took 0.094 sec
>> Testcase: selectSimpleNotMemberOfWithParameterTest took 0.421 sec
>> Testcase: selectSimpleBetweenWithParameterTest took 0.422 sec
>> Testcase: selectSimpleInWithParameterTest took 0.063 sec
>> Testcase: selectAverageQueryForByteColumnTest took 0.015 sec
>> Testcase: selectUsingLockModeQueryHintTest took 0.047 sec
>> Testcase: multipleExecutionOfNamedQueryTest took 0.032 sec
>> Testcase: selectNamedNativeQueryWithPositionalParameterTest took 0 sec
>> FAILED
>> findAllSQLAddressesByCity_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCity_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> junit.framework.AssertionFailedError: findAllSQLAddressesByCity_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCity_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.selectNamedNativeQueryWithPositionalParameterTest(JUnitEJBQLSimpleTestSuite.java:1961)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>>
>> Testcase: selectNativeQueryWithPositionalParameterTest took 0.015 sec
>> FAILED
>> findAllSQLAddressesByCity_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCity_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> junit.framework.AssertionFailedError: findAllSQLAddressesByCity_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCity_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'city'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=?
>> bind => [Ottawa]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark_Number:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> findAllSQLAddressesByCityAndCountry_QuestionMark:
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'country'.
>> Error Code: 207
>> Call:select * from CMP3_ADDRESS where city=? and country=?
>> bind => [Ottawa, Canada]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Address)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.selectNativeQueryWithPositionalParameterTest(JUnitEJBQLSimpleTestSuite.java:2027)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>>
>> Testcase: complexABSTest took 0.032 sec
>> Testcase: complexABSWithParameterTest took 0.047 sec
>> Testcase: compexInTest took 0.125 sec
>> Testcase: complexLengthTest took 0.078 sec
>> Testcase: complexLikeTest took 0.078 sec
>> Testcase: complexNotInTest took 0.359 sec
>> Testcase: complexNotLikeTest took 0.375 sec
>> Testcase: complexParameterTest took 0.078 sec
>> Testcase: complexReverseAbsTest took 0.11 sec
>> Testcase: complexReverseLengthTest took 0.062 sec
>> Testcase: complexReverseParameterTest took 0.078 sec
>> Testcase: complexReverseSqrtTest took 0.047 sec
>> Testcase: complexSqrtTest took 0.047 sec
>> Testcase: complexStringInTest took 0.125 sec
>> Testcase: complexStringNotInTest took 0.359 sec
>> Testcase: complexSubstringTest took 0.063 sec
>> Testcase: complexLocateTest took 0.016 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function 'LOCATE' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>> Error Code: 14216
>> Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.PAY_SCALE, t0.ROOM_NUM, t1.SALARY, t0.F_NAME, t0.STATUS, t0.L_NAME, t0.VERSION, t0.START_DATE, t0.END_DATE, t0.ADDR_ID, t0.MANAGER_EMP_ID, t0.DEPT_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE (((LOCATE(?, t0.F_NAME, ?) = ?) AND (t0.L_NAME = ?)) AND (t1.EMP_ID = t0.EMP_ID))
>> bind => [a, 4, 6, Smith]
>> Query:ReportQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Function 'LOCATE' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>> Error Code: 14216
>> Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.PAY_SCALE, t0.ROOM_NUM, t1.SALARY, t0.F_NAME, t0.STATUS, t0.L_NAME, t0.VERSION, t0.START_DATE, t0.END_DATE, t0.ADDR_ID, t0.MANAGER_EMP_ID, t0.DEPT_ID FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE (((LOCATE(?, t0.F_NAME, ?) = ?) AND (t0.L_NAME = ?)) AND (t1.EMP_ID = t0.EMP_ID))
>> bind => [a, 4, 6, Smith]
>> Query:ReportQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
>> 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)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2192)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2158)
>> at oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:774)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:346)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:471)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLComplexTestSuite.complexLocateTest(JUnitEJBQLComplexTestSuite.java:685)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Function 'LOCATE' not found. If this is a SQLJ function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 39 more
>>
>> Testcase: complexNestedOneToManyUsingInClause took 0.203 sec
>> Testcase: complexUnusedVariableTest took 0.64 sec
>> Testcase: complexJoinTest took 0.078 sec
>> Testcase: complexFetchJoinTest took 0.547 sec
>> Testcase: complexSelectRelationshipTest took 0.063 sec
>> Testcase: complexConstructorTest took 0.047 sec
>> Testcase: complexConstructorRelationshipTest took 0.047 sec
>> Testcase: complexConstructorAggregatesTest took 0.046 sec
>> Testcase: complexResultPropertiesTest took 0.063 sec
>> Testcase: complexInSubqueryTest took 0.016 sec
>> Testcase: complexExistsTest took 0.203 sec
>> Testcase: complexNotExistsTest took 0.156 sec
>> Testcase: complexMemberOfTest took 0.297 sec
>> Testcase: complexNotMemberOfTest took 0.344 sec
>> Testcase: unknown took 0 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'CHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.
>> Error Code: 257
>> Call:INSERT INTO CMP3_AAA (ID, FOO, DTYPES) VALUES (?, ?, ?)
>> bind => [3, foo, 1]
>> Query:InsertObjectQuery(oracle.toplink.essentials.testing.models.cmp3.inheritance.AAA_at_d889b5)
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'CHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.
>> Error Code: 257
>> Call:INSERT INTO CMP3_AAA (ID, FOO, DTYPES) VALUES (?, ?, ?)
>> bind => [3, foo, 1]
>> Query:InsertObjectQuery(oracle.toplink.essentials.testing.models.cmp3.inheritance.AAA_at_d889b5)
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
>> at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:331)
>> at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:176)
>> at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:190)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:457)
>> at oracle.toplink.essentials.queryframework.InsertObjectQuery.executeCommit(InsertObjectQuery.java:74)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.performUserDefinedWrite(DatabaseQueryMechanism.java:635)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.performUserDefinedInsert(DatabaseQueryMechanism.java:599)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.insertObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:495)
>> at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeCommitWithChangeSet(WriteObjectQuery.java:130)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:283)
>> at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:67)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:123)
>> at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:95)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:254)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:231)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:187)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitRootUnitOfWork(UnitOfWorkImpl.java:962)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:794)
>> at oracle.toplink.essentials.testing.models.cmp3.inheritance.InheritancePopulator.persistExample(InheritancePopulator.java:99)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLInheritanceTestSuite$1.setUp(JUnitEJBQLInheritanceTestSuite.java:157)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'CHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1702)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
>> ... 43 more
>>
>> Testcase: generalExceptionTest took 0 sec
>> Testcase: recognitionExceptionTest took 0 sec
>> Testcase: missingSelectExceptionTest took 0 sec
>> Testcase: malformedEjbqlExceptionTest1 took 0.016 sec
>> Testcase: malformedEjbqlExceptionTest2 took 0 sec
>> Testcase: malformedEjbqlExceptionTest3 took 0 sec
>> Testcase: malformedEjbqlExceptionTest4 took 0 sec
>> Testcase: malformedEjbqlExceptionTest5 took 0 sec
>> Testcase: malformedEjbqlExceptionTest6 took 0 sec
>> Testcase: malformedEjbqlExceptionTest7 took 0 sec
>> Testcase: malformedEjbqlExceptionTest8 took 0 sec
>> Testcase: noAliasWithWHEREAndParameterExceptionTest took 0 sec
>> Testcase: unknownAbstractSchemaTypeTest took 0 sec
>> Testcase: multipleDeclarationOfIdentificationVariable took 0 sec
>> Testcase: aliasResolutionException took 0 sec
>> Testcase: illegalArgumentExceptionTest took 0 sec
>> Testcase: createNamedQueryThrowsIllegalArgumentExceptionTest took 0 sec
>> Testcase: flushTxExceptionTest took 0.015 sec
>> Testcase: noResultExceptionTest took 0 sec
>> Testcase: testGetSingleResultOnUpdate took 0 sec
>> Testcase: testGetSingleResultOnDelete took 0 sec
>> Testcase: testExecuteUpdateOnSelect took 0 sec
>> Testcase: flushOptimisticLockExceptionTest took 0.547 sec
>> Testcase: commitOptimisticLockExceptionTest took 0.094 sec
>> Testcase: JTAOptimisticLockExceptionTest took 0.078 sec
>> Testcase: testParameterNameValidation took 0.016 sec
>> Testcase: testModArgumentValidation took 0 sec
>> FAILED
>> Warning SQL/Sybase doesnot support MOD function
>> junit.framework.AssertionFailedError: Warning SQL/Sybase doesnot support MOD function
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.testModArgumentValidation(JUnitEJBQLValidationTestSuite.java:682)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>>
>> Testcase: testInExpressionValidation took 0 sec
>> Testcase: testOrderableTypeInOrderByItem took 0 sec
>> Testcase: testInvalidNavigation took 0 sec
>> Testcase: testInvalidCollectionNavigation took 0 sec
>> Testcase: testUnknownAttribute took 0 sec
>> Testcase: testCommitRollbackException took 0.031 sec
>> Testcase: testParameterPositionValidation took 0 sec
>> Testcase: testParameterPositionValidation2 took 0 sec
>> Testcase: testParameterTypeValidation took 0 sec
>> Testcase: testEjbqlCaseSensitivity took 0.031 sec
>> Testcase: testEjbqlUnsupportJoinArgument took 0 sec
>> Testcase: testInvalidSetClause took 0 sec
>> Testcase: complexAVGTest took 0.015 sec
>> Testcase: complexCountDistinctWithGroupByAndHavingTest took 0.032 sec
>> Testcase: complexCountDistinctWithGroupByTest took 0.046 sec
>> Testcase: complexCountDistinctWithGroupByTest2 took 0.141 sec
>> Testcase: complexHavingWithAggregate took 0.078 sec
>> Testcase: complexCountTest took 0.016 sec
>> Testcase: complexCountWithGroupByTest took 0.047 sec
>> Testcase: complexDistinctCountTest took 0 sec
>> Testcase: complexMaxTest took 0.015 sec
>> Testcase: complexMinTest took 0.016 sec
>> Testcase: complexSumTest took 0.016 sec
>> Testcase: testSqlDate took 0 sec
>> Testcase: testSqlDateToTS took 0 sec
>> Testcase: testTime took 0.015 sec
>> Testcase: testTimeToTS took 0 sec
>> Testcase: testTimestamp took 0.016 sec
>> Testcase: testTimestampToDate took 0 sec
>> Testcase: testTimestampToTime took 0 sec
>> Testcase: testUtilDate took 0.016 sec
>> Testcase: testCalenderWithUtilDate took 0 sec
>> Testcase: testSqlDateWithCal took 0 sec
>> Testcase: testTimeWithCal took 0.015 sec
>> Testcase: testTimestampWithCal took 0 sec
>> Testcase: testUtilDateWithCal took 0.016 sec
>> Testcase: testCalendar took 0 sec
>> Testcase: testTimestampGreaterThan took 0.015 sec
>> Testcase: testTimestampLessThan took 0.016 sec
>> Testcase: testTimestampIn took 0 sec
>> Testcase: testTimestampBetween took 0 sec
>> Testcase: multipleParameterTest took 0.015 sec
>> Testcase: updateEnumParameter took 0.047 sec
>> Testcase: findAllOrders took 0 sec
>> Testcase: findEmployeesInOntario took 0.234 sec
>> Testcase: findAllProvinceWithEmployees took 0.016 sec
>> Testcase: findAllEmployeesWithPhoneNumbers took 0.344 sec
>> Testcase: findAllEmployeesWithOutPhoneNumbers took 0.031 sec
>> Testcase: findAllEmployeesWithCellPhones took 0.125 sec
>> Testcase: findOrdersWithDifferentBilledCustomer took 0.031 sec
>> Testcase: findEmployeeWithWorkPhone2258812 took 0.219 sec
>> Testcase: parameterTest took 0.125 sec
>> Testcase: getOrderLargerThan took 0.015 sec
>> Testcase: getSalesPersonForOrders took 0.016 sec
>> Testcase: getOrderForCustomer took 0.031 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'cCustomers_CUST_ID'.
>> Error Code: 207
>> Call:SELECT t1.CUST_ID, t1.CITY, t1.CUST_VERSION, t1.NAME FROM CMP3_CUSTOMER_CUSTOMER t0, CMP3_CUSTOMER t1 WHERE ((t0.Customer_CUST_ID = ?) AND (t1.CUST_ID = t0.cCustomers_CUST_ID))
>> bind => [6]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Customer)
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'cCustomers_CUST_ID'.
>> Error Code: 207
>> Call:SELECT t1.CUST_ID, t1.CITY, t1.CUST_VERSION, t1.NAME FROM CMP3_CUSTOMER_CUSTOMER t0, CMP3_CUSTOMER t1 WHERE ((t0.Customer_CUST_ID = ?) AND (t1.CUST_ID = t0.cCustomers_CUST_ID))
>> bind => [6]
>> Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Customer)
>> 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)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2192)
>> at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2170)
>> at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:86)
>> at oracle.toplink.essentials.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:76)
>> at oracle.toplink.essentials.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:90)
>> at oracle.toplink.essentials.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:160)
>> at oracle.toplink.essentials.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:232)
>> at oracle.toplink.essentials.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:90)
>> at oracle.toplink.essentials.indirection.IndirectList.buildDelegate(IndirectList.java:193)
>> at oracle.toplink.essentials.indirection.IndirectList.getDelegate(IndirectList.java:315)
>> at oracle.toplink.essentials.indirection.IndirectList.size(IndirectList.java:640)
>> at oracle.toplink.essentials.internal.queryframework.CollectionContainerPolicy.sizeFor(CollectionContainerPolicy.java:184)
>> at oracle.toplink.essentials.internal.indirection.TransparentIndirectionPolicy.getRealAttributeValueFromObject(TransparentIndirectionPolicy.java:252)
>> at oracle.toplink.essentials.mappings.ForeignReferenceMapping.getRealAttributeValueFromObject(ForeignReferenceMapping.java:366)
>> at oracle.toplink.essentials.mappings.CollectionMapping.getRealAttributeValueFromObject(CollectionMapping.java:559)
>> at oracle.toplink.essentials.mappings.CollectionMapping.getRealCollectionAttributeValueFromObject(CollectionMapping.java:574)
>> at oracle.toplink.essentials.mappings.CollectionMapping.compareObjects(CollectionMapping.java:353)
>> at oracle.toplink.essentials.internal.descriptors.ObjectBuilder.compareObjects(ObjectBuilder.java:1281)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.compareObjects(AbstractSession.java:495)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitDomainObjectComparer.compareObjects(JUnitDomainObjectComparer.java:87)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitDomainObjectComparer.compareObjects(JUnitDomainObjectComparer.java:96)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLExamplesTestSuite.getOrderForCustomer(JUnitEJBQLExamplesTestSuite.java:371)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'cCustomers_CUST_ID'.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
>> ... 55 more
>>
>> Testcase: testOuterJoin took 0.11 sec
>> Testcase: testExistsExpression took 0.078 sec
>> Testcase: testAllExpressions took 0.062 sec
>> Testcase: testCountInSubQuery took 0.016 sec
>> Testcase: testGroupByHavingExpression took 0.062 sec
>> Testcase: testGroupByHavingCount took 0.032 sec
>> Testcase: testConstructorQuery took 0 sec
>> Testcase: testSumExpression took 0.015 sec
>> Testcase: testAvgExpression took 0.016 sec
>> Testcase: testOrderByExpression took 0.094 sec
>> Testcase: testCountInSubQuery took 0.015 sec
>> Testcase: testOrderByExpressionWithSelect took 0.016 sec
>> Testcase: testDeleteExpression took 0.016 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'Customer_CUST_ID'.
>> Error Code: 207
>> Call:DELETE FROM CMP3_CUSTOMER_CUSTOMER WHERE EXISTS(SELECT CUST_ID FROM CMP3_CUSTOMER WHERE (NAME = ?) AND CUST_ID = CMP3_CUSTOMER_CUSTOMER.Customer_CUST_ID)
>> bind => [Karen McDonald]
>> Query:DeleteAllQuery()
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'Customer_CUST_ID'.
>> Error Code: 207
>> Call:DELETE FROM CMP3_CUSTOMER_CUSTOMER WHERE EXISTS(SELECT CUST_ID FROM CMP3_CUSTOMER WHERE (NAME = ?) AND CUST_ID = CMP3_CUSTOMER_CUSTOMER.Customer_CUST_ID)
>> bind => [Karen McDonald]
>> Query:DeleteAllQuery()
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
>> at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.deleteAll(DatasourceCallQueryMechanism.java:102)
>> at oracle.toplink.essentials.queryframework.DeleteAllQuery.executeDatabaseQuery(DeleteAllQuery.java:183)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.queryframework.ModifyAllQuery.executeInUnitOfWork(ModifyAllQuery.java:153)
>> at oracle.toplink.essentials.queryframework.DeleteAllQuery.executeInUnitOfWork(DeleteAllQuery.java:109)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeUpdate(EJBQueryImpl.java:371)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLExamplesTestSuite.testDeleteExpression(JUnitEJBQLExamplesTestSuite.java:705)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'Customer_CUST_ID'.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1702)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
>> ... 38 more
>>
>> Testcase: testComplexDeleteExpression took 0 sec
>> Caused an ERROR
>>
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'Customer_CUST_ID'.
>> Error Code: 207
>> Call:DELETE FROM CMP3_CUSTOMER_CUSTOMER WHERE EXISTS(SELECT t0.CUST_ID FROM CMP3_CUSTOMER t0 WHERE ((t0.NAME = ?) AND ((SELECT COUNT(*) FROM CMP3_ORDER t1 WHERE (t1.CUSTOMER_CUST_ID = t0.CUST_ID)) = ?)) AND t0.CUST_ID = CMP3_CUSTOMER_CUSTOMER.Customer_CUST_ID)
>> bind => [Karen McDonald, 0]
>> Query:DeleteAllQuery()
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'Customer_CUST_ID'.
>> Error Code: 207
>> Call:DELETE FROM CMP3_CUSTOMER_CUSTOMER WHERE EXISTS(SELECT t0.CUST_ID FROM CMP3_CUSTOMER t0 WHERE ((t0.NAME = ?) AND ((SELECT COUNT(*) FROM CMP3_ORDER t1 WHERE (t1.CUSTOMER_CUST_ID = t0.CUST_ID)) = ?)) AND t0.CUST_ID = CMP3_CUSTOMER_CUSTOMER.Customer_CUST_ID)
>> bind => [Karen McDonald, 0]
>> Query:DeleteAllQuery()
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
>> at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.deleteAll(DatasourceCallQueryMechanism.java:102)
>> at oracle.toplink.essentials.queryframework.DeleteAllQuery.executeDatabaseQuery(DeleteAllQuery.java:183)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.queryframework.ModifyAllQuery.executeInUnitOfWork(ModifyAllQuery.java:153)
>> at oracle.toplink.essentials.queryframework.DeleteAllQuery.executeInUnitOfWork(DeleteAllQuery.java:109)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeUpdate(EJBQueryImpl.java:371)
>> at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLExamplesTestSuite.testComplexDeleteExpression(JUnitEJBQLExamplesTestSuite.java:729)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'Customer_CUST_ID'.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1702)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
>> ... 38 more
>>
>> Testcase: updateAllTest took 0.062 sec
>> Testcase: namedQueryCloneTest took 0.016 sec
>> Testcase: aggregateParameterTest took 0.125 sec
>> Testcase: testEJBQLQueryString took 0.031 sec
>> Testcase: updateEmbeddedFieldTest took 0.031 sec
>> Testcase: simpleUpdate took 1.906 sec
>> Testcase: updateWithSubquery took 1.954 sec
>> Testcase: updateEmbedded took 3.406 sec
>> Testcase: updateUnqualifiedAttributeInSet took 1.781 sec
>> Testcase: updateUnqualifiedAttributeInWhere took 1.813 sec
>> Testcase: simpleDelete took 1.734 sec
>> Testcase: testCreateEmployee took 0.078 sec
>> Testcase: testReadEmployee took 0 sec
>> Testcase: testNamedNativeQueryOnAddress took 0.015 sec
>> Testcase: testNamedQueryOnEmployee took 0.016 sec
>> Testcase: testUpdateEmployee took 0.016 sec
>> Testcase: testRefreshNotManagedEmployee took 0 sec
>> Testcase: testRefreshRemovedEmployee took 0.062 sec
>> Testcase: testDeleteEmployee took 0.063 sec
>> Testcase: testCreateCustomer took 0.031 sec
>> Testcase: testCreateItem took 0.015 sec
>> Testcase: testCreateOrder took 0.032 sec
>> Testcase: testReadCustomer took 0 sec
>> Testcase: testReadItem took 0 sec
>> Testcase: testReadOrder took 0 sec
>> Testcase: testNamedQueryOnCustomer took 0 sec
>> Testcase: testNamedQueryOnItem took 0.015 sec
>> Testcase: testNamedQueryOnOrder took 0.016 sec
>> Testcase: testUpdateCustomer took 0.016 sec
>> Testcase: testUpdateItem took 0.031 sec
>> Testcase: testUpdateOrder took 0.047 sec
>> Testcase: testDeleteOrder took 0.015 sec
>> Testcase: testDeleteCustomer took 0.016 sec
>> Testcase: testDeleteItem took 0.031 sec
>> Testcase: testUnidirectionalOneToOneCreate took 0.063 sec
>> Testcase: testUnidirectionalOneToOneRead took 0 sec
>> Testcase: testUnidirectionalOneToOneDeleteNonowning took 0.047 sec
>> Testcase: testUnidirectionalOneToOneDeleteOwning took 0.015 sec
>> Testcase: testUnidirectionalOneToManyCreate took 0.063 sec
>> Testcase: testUnidirectionalOneToManyRead took 0 sec
>> Testcase: testUnidirectionalOneToManyDeleteNonowning took 0.031 sec
>> Testcase: testUnidirectionalOneToManyDeleteOwning took 0.047 sec
>> Testcase: testUnidirectionalManyToOneCreate took 0.063 sec
>> Testcase: testUnidirectionalManyToOneRead took 0 sec
>> Testcase: testUnidirectionalManyToOneDeleteNonowning took 0.015 sec
>> Testcase: testUnidirectionalManyToOneDeleteOwning took 0.063 sec
>> Testcase: testUnidirectionalManyToManyCreate took 0.047 sec
>> Testcase: testUnidirectionalManyToManyRead took 0 sec
>> Testcase: testUnidirectionalManyToManyDeleteNonowning took 0.031 sec
>> Testcase: testUnidirectionalManyToManyDeleteOwning took 0.031 sec
>> Testcase: testCreateFueledVehicle took 0.016 sec
>> Testcase: testCreateBusFueledVehicle took 0.031 sec
>> Testcase: testCreateNonFueledVehicle took 0.063 sec
>> Testcase: testReadFueledVehicle took 0 sec
>> Testcase: testReadNonFueledVehicle took 0 sec
>> Testcase: testNamedNativeQueryOnSportsCar took 0.015 sec
>> Testcase: testUpdateBusFueledVehicle took 0.016 sec
>> Testcase: testUpdateFueledVehicle took 0.031 sec
>> Testcase: testUpdateNonFueledVehicle took 0.016 sec
>> Testcase: testDeleteBusFueledVehicle took 0.031 sec
>> Testcase: testDeleteFueledVehicle took 0.047 sec
>> Testcase: testDeleteNonFueledVehicle took 0.031 sec
>> Testcase: testOneToManyRelationships took 0.016 sec
>> Testcase: testVerifyOneToManyRelationships took 0.015 sec
>> Testcase: testCreateBeerConsumer took 0.078 sec
>> Testcase: testReadBeerConsumer took 0 sec
>> Testcase: testNamedNativeQueryBeerConsumers took 0 sec
>> Testcase: testNamedNativeQueryCertifications took 0 sec
>> Testcase: testUpdateBeerConsumer took 0.032 sec
>> Testcase: testDeleteBeerConsumer took 0.062 sec
>> Testcase: testInheritanceDiscriminatorFieldValue took 0 sec
>> Testcase: testMappingsTypes took 0 sec
>> Testcase: testCreateCustomer took 0.016 sec
>> Testcase: testCreateItem took 0.047 sec
>> Testcase: testCreateOrder took 0.015 sec
>> Testcase: testReadCustomer took 0 sec
>> Testcase: testReadItem took 0 sec
>> Testcase: testReadOrder took 0 sec
>> Testcase: testNamedQueryOnCustomer took 0.016 sec
>> Testcase: testNamedQueryOnItem took 0 sec
>> Testcase: testNamedQueryOnOrder took 0 sec
>> Testcase: testUpdateCustomer took 0.016 sec
>> Testcase: testUpdateItem took 0.062 sec
>> Testcase: testUpdateOrder took 0.031 sec
>> Testcase: testDeleteOrder took 0.032 sec
>> Testcase: testDeleteCustomer took 0.015 sec
>> Testcase: testDeleteItem took 0.016 sec
>> Testcase: testCreateCustomer took 0.016 sec
>> Testcase: testCreateItem took 0.031 sec
>> Testcase: testCreateOrder took 0.015 sec
>> Testcase: testReadCustomer took 0 sec
>> Testcase: testReadItem took 0 sec
>> Testcase: testReadOrder took 0 sec
>> Testcase: testUpdateCustomer took 0.032 sec
>> Testcase: testUpdateItem took 0.047 sec
>> Testcase: testUpdateOrder took 0.031 sec
>> Testcase: testDeleteOrder took 0.031 sec
>> Testcase: testDeleteCustomer took 0.016 sec
>> Testcase: testDeleteItem took 0.031 sec
>> Testcase: testCreateEmployee took 0.078 sec
>> Caused an ERROR
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed. Use the CONVERT function to run this query.
>> Error Code: 257
>> Call:INSERT INTO CMP3_XML_MERGE_SECURITYBADGE (BADGE_ID, VERSION, BADGENUMBER) VALUES (?, ?, ?)
>> bind => [1, 1, 666]
>> Query:InsertObjectQuery(oracle.toplink.essentials.testing.models.cmp3.xml.merge.incompletemappings.owni)
>> javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed. Use the CONVERT function to run this query.
>> Error Code: 257
>> Call:INSERT INTO CMP3_XML_MERGE_SECURITYBADGE (BADGE_ID, VERSION, BADGENUMBER) VALUES (?, ?, ?)
>> bind => [1, 1, 666]
>> Query:InsertObjectQuery(oracle.toplink.essentials.testing.models.cmp3.xml.merge.incompletemappings.owni)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:109)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:45)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.incompletemappings.owning.EntityMappingsIncompleteOwningJUnitTestCase.testCreateEmployee(EntityMappingsIncompleteOwningJUnitTestCase.java:92)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed. Use the CONVERT function to run this query.
>> Error Code: 257
>> Call:INSERT INTO CMP3_XML_MERGE_SECURITYBADGE (BADGE_ID, VERSION, BADGENUMBER) VALUES (?, ?, ?)
>> bind => [1, 1, 666]
>> Query:InsertObjectQuery(oracle.toplink.essentials.testing.models.cmp3.xml.merge.incompletemappings.owni)
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
>> at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
>> at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:331)
>> at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:176)
>> at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:190)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:457)
>> at oracle.toplink.essentials.queryframework.InsertObjectQuery.executeCommit(InsertObjectQuery.java:74)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.performUserDefinedWrite(DatabaseQueryMechanism.java:635)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.performUserDefinedInsert(DatabaseQueryMechanism.java:599)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.insertObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:495)
>> at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeCommitWithChangeSet(WriteObjectQuery.java:130)
>> at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:283)
>> at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:67)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
>> at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
>> at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:123)
>> at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:95)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:254)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:231)
>> at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:187)
>> at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:82)
>> at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:842)
>> at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:90)
>> ... 27 more
>> Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed. Use the CONVERT function to run this query.
>>
>> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
>> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
>> at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
>> at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
>> at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1702)
>> at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)
>> at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:104)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
>> ... 62 more
>>
>> Testcase: testReadEmployee took 0 sec
>> Caused an ERROR
>> null
>> java.lang.NullPointerException
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.incompletemappings.owning.EntityMappingsIncompleteOwningJUnitTestCase.testReadEmployee(EntityMappingsIncompleteOwningJUnitTestCase.java:121)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>>
>> Testcase: testUpdateEmployee took 0.016 sec
>> Caused an ERROR
>> null
>> java.lang.NullPointerException
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.incompletemappings.owning.EntityMappingsIncompleteOwningJUnitTestCase.testUpdateEmployee(EntityMappingsIncompleteOwningJUnitTestCase.java:129)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>>
>> Testcase: testDeleteEmployee took 0 sec
>> Caused an ERROR
>> Object: null is not a known entity type.
>> java.lang.IllegalArgumentException: Object: null is not a known entity type.
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.remove(EntityManagerImpl.java:217)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.incompletemappings.owning.EntityMappingsIncompleteOwningJUnitTestCase.testDeleteEmployee(EntityMappingsIncompleteOwningJUnitTestCase.java:107)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>>
>> Testcase: testOneToManyRelationships took 0.171 sec
>> Caused an ERROR
>>
>> Internal Exception: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).Error Code: 0
>> Local Exception Stack:
>> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).Error Code: 0
>> at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:289)
>> at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:87)
>> at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
>> at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:218)
>> at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.connect(DatabaseAccessor.java:227)
>> at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:294)
>> at oracle.toplink.essentials.threetier.ConnectionPool.buildConnection(ConnectionPool.java:102)
>> at oracle.toplink.essentials.threetier.ConnectionPool.startUp(ConnectionPool.java:324)
>> at oracle.toplink.essentials.threetier.ServerSession.connect(ServerSession.java:448)
>> at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:558)
>> at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:185)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:193)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testOneToManyRelationships(EntityMappingsMergeInheritedJUnitTestCase.java:210)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
>> at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:549)
>> at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3629)
>> at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:510)
>> at com.sybase.jdbc2.tds.Tds.login(Tds.java:432)
>> at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:247)
>> at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:223)
>> at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:198)
>> at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:132)
>> at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
>> at java.sql.DriverManager.getConnection(DriverManager.java:525)
>> at java.sql.DriverManager.getConnection(DriverManager.java:140)
>> at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
>> ... 41 more
>>
>> Testcase: testVerifyOneToManyRelationships took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testVerifyOneToManyRelationships(EntityMappingsMergeInheritedJUnitTestCase.java:243)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testCreateBeerConsumer took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testCreateBeerConsumer(EntityMappingsMergeInheritedJUnitTestCase.java:92)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testReadBeerConsumer took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testReadBeerConsumer(EntityMappingsMergeInheritedJUnitTestCase.java:178)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testNamedNativeQueryBeerConsumers took 0.016 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testNamedNativeQueryBeerConsumers(EntityMappingsMergeInheritedJUnitTestCase.java:152)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testNamedNativeQueryCertifications took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testNamedNativeQueryCertifications(EntityMappingsMergeInheritedJUnitTestCase.java:157)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testMappedSuperclassTransientField took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testMappedSuperclassTransientField(EntityMappingsMergeInheritedJUnitTestCase.java:266)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testTransientField took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testTransientField(EntityMappingsMergeInheritedJUnitTestCase.java:273)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testUpdateBeerConsumer took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testUpdateBeerConsumer(EntityMappingsMergeInheritedJUnitTestCase.java:183)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testDeleteBeerConsumer took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testDeleteBeerConsumer(EntityMappingsMergeInheritedJUnitTestCase.java:162)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testBeerLifeCycleMethodAnnotationIgnored took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testBeerLifeCycleMethodAnnotationIgnored(EntityMappingsMergeInheritedJUnitTestCase.java:282)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testMappedSuperclassEntityListener took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase.testMappedSuperclassEntityListener(EntityMappingsMergeInheritedJUnitTestCase.java:307)
>> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 32 more
>>
>> Testcase: testMappedSuperclassEmbeddedXMLElement took 0 sec
>> Testcase: unknown took 0 sec
>> Caused an ERROR
>> An exception occurred trying clear the cache.
>> java.lang.RuntimeException: An exception occurred trying clear the cache.
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.clearCache(JUnitTestCase.java:91)
>> at oracle.toplink.essentials.testing.tests.cmp3.xml.merge.inherited.EntityMappingsMergeInheritedJUnitTestCase$1.tearDown(EntityMappingsMergeInheritedJUnitTestCase.java:86)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:20)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.getServerSession(JUnitTestCase.java:139)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.clearCache(JUnitTestCase.java:89)
>> ... 13 more
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 21 more
>>
>> Testcase: unknown took 0 sec
>> Caused an ERROR
>> Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> javax.persistence.PersistenceException: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:158)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
>> at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:107)
>> at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
>> at oracle.toplink.essentials.testing.framework.junit.JUnitTestCase.createEntityManager(JUnitTestCase.java:103)
>> at oracle.toplink.essentials.testing.tests.cmp3.ddlgeneration.DDLGenerationJUnitTestSuite$1.setUp(DDLGenerationJUnitTestSuite.java:63)
>> at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
>> at junit.extensions.TestSetup.run(TestSetup.java:23)
>> Caused by: Exception [TOPLINK-28013] (Oracle TopLink Essentials - 9.1 (Build ${build_id})): oracle.toplink.essentials.exceptions.EntityManagerSetupException
>> Exception Description: Attempted to deploy PersistenceUnit [ddlGeneration] for which predeploy method either had not called or had failed
>> at oracle.toplink.essentials.exceptions.EntityManagerSetupException.cannotDeployWithoutPredeploy(EntityManagerSetupException.java:169)
>> ... 15 more
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
>> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>>




TESTROOT
FullRegressionTestSuite
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite$1
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite
testSerializedLazy(oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite)
junit.framework.AssertionFailedError: The correct exception was not thrown while traversing an uninstantiated lazy relationship on a serialized object: null
        at junit.framework.Assert.fail(Assert.java:47)
        at junit.framework.Assert.assertTrue(Assert.java:20)
        at junit.framework.Assert.assertNotNull(Assert.java:220)
        at oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testSerializedLazy(EntityManagerJUnitTestSuite.java:2292)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

oracle.toplink.essentials.testing.tests.cmp3.advanced.JoinedAttributeAdvancedJunitTest$1
oracle.toplink.essentials.testing.tests.cmp3.advanced.JoinedAttributeAdvancedJunitTest
testEmployeeJoinProjects(oracle.toplink.essentials.testing.tests.cmp3.advanced.JoinedAttributeAdvancedJunitTest)
junit.framework.AssertionFailedError: PK = 216: Employee.manager.manager.manager.manager.projects: indirection instantiated != indirection NOT instantiated; .projects: indirection instantiated != indirection NOT instantiated; PK = 220: Employee.manager.projects: indirection instantiated != indirection NOT instantiated;
        at junit.framework.Assert.fail(Assert.java:47)
        at oracle.toplink.essentials.testing.tests.cmp3.advanced.JoinedAttributeAdvancedJunitTest.testEmployeeJoinProjects(JoinedAttributeAdvancedJunitTest.java:517)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

oracle.toplink.essentials.testing.tests.cmp3.lob.LobJUnitTestCase$1
Lob Model
testUpdate(oracle.toplink.essentials.testing.tests.cmp3.lob.LobJUnitTestCase)
javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: JZ006: IOException: java.io.IOException: JZ0SL: Dieser SQL-Typ 2005 wird nicht unterst?tzt. wurde abgefangenError Code: 0
Call:UPDATE CMP3_IMAGE SET SCRIPT = ?, PICTURE = ? WHERE (ID = ?)
        bind => [null, null, 1000]
Query:UpdateObjectQuery(oracle.toplink.essentials.testing.models.cmp3.lob.Image_at_a32604)
        at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:106)
        at oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:45)
        at oracle.toplink.essentials.testing.tests.cmp3.lob.LobJUnitTestCase.testUpdate(LobJUnitTestCase.java:132)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: JZ006: IOException: java.io.IOException: JZ0SL: Dieser SQL-Typ 2005 wird nicht unterst?tzt. wurde abgefangenError Code: 0
Call:UPDATE CMP3_IMAGE SET SCRIPT = ?, PICTURE = ? WHERE (ID = ?)
        bind => [null, null, 1000]
Query:UpdateObjectQuery(oracle.toplink.essentials.testing.models.cmp3.lob.Image_at_a32604)
        at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:295)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:639)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:688)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:477)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(AbstractSession.java:675)
        at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:135)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.updateObject(DatasourceCallQueryMechanism.java:675)
        at oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.updateObject(StatementQueryMechanism.java:437)
        at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1166)
        at oracle.toplink.essentials.queryframework.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:76)
        at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:283)
        at oracle.toplink.essentials.queryframework.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:67)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
        at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:123)
        at oracle.toplink.essentials.queryframework.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:95)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
        at oracle.toplink.essentials.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:294)
        at oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:180)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:2638)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1030)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:357)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1112)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:82)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:842)
        at oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit(EntityTransactionImpl.java:87)
        ... 26 more
Caused by: java.sql.SQLException: JZ006: IOException: java.io.IOException: JZ0SL: Dieser SQL-Typ 2005 wird nicht unterst?tzt. wurde abgefangen
        at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
        at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.language(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.sendQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.sendQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:632)
        ... 54 more

oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite
testLeftTrimWithTrimChar(oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -154: Falsche Anzahl von Parametern für Funktion 'LTRIM'Error Code: 174
Call:SELECT CUST_ID, NAME, CUST_VERSION, CITY FROM CMP3_CUSTOMER WHERE (LTRIM(CITY, ?) = ?)
        bind => [M, anotick]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Customer)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
        at oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.testLeftTrimWithTrimChar(ExpressionJUnitTestSuite.java:87)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -154: Falsche Anzahl von Parametern für Funktion 'LTRIM'
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 36 more

testTrimWithTrimChar(oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -131: Syntaxfehler bei 'FROM' in Zeile 1Error Code: 102
Call:SELECT ID, NAME, ITEM_VERSION, DESCRIPTION FROM CMP3_ITEM WHERE (TRIM(? FROM NAME) = ?)
        bind => [i, tem]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
        at oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.testTrimWithTrimChar(ExpressionJUnitTestSuite.java:142)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -131: Syntaxfehler bei 'FROM' in Zeile 1
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 36 more

oracle.toplink.essentials.testing.tests.cmp3.fieldaccess.relationships.ExpressionJUnitTestSuite
testLeftTrimWithTrimChar(oracle.toplink.essentials.testing.tests.cmp3.fieldaccess.relationships.ExpressionJUnitTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -154: Falsche Anzahl von Parametern für Funktion 'LTRIM'Error Code: 174
Call:SELECT CUST_ID, CITY, NAME, CUST_VERSION FROM CMP3_FIELDACCESS_CUSTOMER WHERE (LTRIM(CITY, ?) = ?)
        bind => [M, anotick]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.fieldaccess.relationships.Customer)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
        at oracle.toplink.essentials.testing.tests.cmp3.fieldaccess.relationships.ExpressionJUnitTestSuite.testLeftTrimWithTrimChar(ExpressionJUnitTestSuite.java:87)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -154: Falsche Anzahl von Parametern für Funktion 'LTRIM'
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 36 more

testTrimWithTrimChar(oracle.toplink.essentials.testing.tests.cmp3.fieldaccess.relationships.ExpressionJUnitTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -131: Syntaxfehler bei 'FROM' in Zeile 1Error Code: 102
Call:SELECT ID, ITEM_VERSION, NAME, DESCRIPTION FROM CMP3_FIELDACCESS_ITEM WHERE (TRIM(? FROM NAME) = ?)
        bind => [i, tem]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.fieldaccess.relationships.Item)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1815)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
        at oracle.toplink.essentials.testing.tests.cmp3.fieldaccess.relationships.ExpressionJUnitTestSuite.testTrimWithTrimChar(ExpressionJUnitTestSuite.java:142)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -131: Syntaxfehler bei 'FROM' in Zeile 1
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 36 more

oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite$1
JUnitEJBQLSimpleTestSuite
collectionMemberIdentifierEqualsTest(oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefundenError Code: 207
Call:SELECT DISTINCT t1.EMP_ID, t2.EMP_ID, t1.VERSION, t1.F_NAME, t1.STATUS, t2.SALARY, t1.ROOM_NUM, t1.PAY_SCALE, t1.L_NAME, t1.DEPT_ID, t1.ADDR_ID, t1.MANAGER_EMP_ID, t1.START_DATE, t1.END_DATE FROM CMP3_PHONENUMBER t0, CMP3_SALARY t2, CMP3_EMPLOYEE t1 WHERE ((((? = t0.OWNER_ID) AND (? = t0.TYPE)) AND (t2.EMP_ID = t1.EMP_ID)) AND (t0.OWNER_ID = t1.EMP_ID))
        bind => [337, Work]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:335)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:442)
        at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.collectionMemberIdentifierEqualsTest(JUnitEJBQLSimpleTestSuite.java:670)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefunden
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 43 more

abstractSchemaIdentifierEqualsTest(oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefundenError Code: 207
Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.VERSION, t0.F_NAME, t0.STATUS, t1.SALARY, t0.ROOM_NUM, t0.PAY_SCALE, t0.L_NAME, t0.DEPT_ID, t0.ADDR_ID, t0.MANAGER_EMP_ID, t0.START_DATE, t0.END_DATE FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((? = t0.EMP_ID) AND (t1.EMP_ID = t0.EMP_ID))
        bind => [339]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:335)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:442)
        at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.abstractSchemaIdentifierEqualsTest(JUnitEJBQLSimpleTestSuite.java:685)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefunden
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 43 more

abstractSchemaIdentifierNotEqualsTest(oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefundenError Code: 207
Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.VERSION, t0.F_NAME, t0.STATUS, t1.SALARY, t0.ROOM_NUM, t0.PAY_SCALE, t0.L_NAME, t0.DEPT_ID, t0.ADDR_ID, t0.MANAGER_EMP_ID, t0.START_DATE, t0.END_DATE FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE (NOT ((? = t0.EMP_ID)) AND (t1.EMP_ID = t0.EMP_ID))
        bind => [339]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:335)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:442)
        at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.abstractSchemaIdentifierNotEqualsTest(JUnitEJBQLSimpleTestSuite.java:704)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefunden
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 43 more

simpleReverseAbsTest(oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefundenError Code: 207
Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.VERSION, t0.F_NAME, t0.STATUS, t1.SALARY, t0.ROOM_NUM, t0.PAY_SCALE, t0.L_NAME, t0.DEPT_ID, t0.ADDR_ID, t0.MANAGER_EMP_ID, t0.START_DATE, t0.END_DATE FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((? = ABS(t1.SALARY)) AND (t1.EMP_ID = t0.EMP_ID))
        bind => [500000]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:335)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:442)
        at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.simpleReverseAbsTest(JUnitEJBQLSimpleTestSuite.java:1111)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefunden
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 43 more

simpleReverseEqualsTest(oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefundenError Code: 207
Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.VERSION, t0.F_NAME, t0.STATUS, t1.SALARY, t0.ROOM_NUM, t0.PAY_SCALE, t0.L_NAME, t0.DEPT_ID, t0.ADDR_ID, t0.MANAGER_EMP_ID, t0.START_DATE, t0.END_DATE FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((? = t0.F_NAME) AND (t1.EMP_ID = t0.EMP_ID))
        bind => [Fred]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:335)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:442)
        at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.simpleReverseEqualsTest(JUnitEJBQLSimpleTestSuite.java:1153)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefunden
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
        at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
        ... 43 more

simpleReverseLengthTest(oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build local)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere-Fehler -143: Spalte '_at_p0' nicht gefundenError Code: 207
Call:SELECT t0.EMP_ID, t1.EMP_ID, t0.VERSION, t0.F_NAME, t0.STATUS, t1.SALARY, t0.ROOM_NUM, t0.PAY_SCALE, t0.L_NAME, t0.DEPT_ID, t0.ADDR_ID, t0.MANAGER_EMP_ID, t0.START_DATE, t0.END_DATE FROM CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((? = LENGTH(t0.F_NAME)) AND (t1.EMP_ID = t0.EMP_ID))
        bind => [4]
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.Employee)
        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)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
        at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2207)
        at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2185)
        at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
        at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
        at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
        at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
        at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:335)
        at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:442)
        at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.simpleReverseLengthTest(JUnitEJBQLSimpleTestSuite.java:1169)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at junit.framework.TestCase.runTest(TestCase.java