I look at this right away.
----- Original Message -----
From: "Michael Bouschen" <Michael.Bouschen_at_Sun.COM>
To: <persistence_at_glassfish.dev.java.net>
Cc: "Andrei Ilitchev" <andrei.ilitchev_at_oracle.com>; "Christopher Delahunt"
<christopher.delahunt_at_oracle.com>
Sent: Monday, March 12, 2007 9:14 AM
Subject: Re: 2 failures of entity-persistence-tests on Derby
> Hi,
>
> I see the same two errors when running the entity-persistent-tests on
> derby.
>
> Regards Michael
>
>> Hello, Marina
>>
>> Of course I'm running on Derby Network Server. :-)
>>
>> Yes, it's strange the same exception is being thrown as the issue 1451
>> with 1451 fix.
>> Here is the root cause exception:
>>
>> oracle.toplink.essentials.exceptions.DatabaseException
>> Internal Exception: org.apache.derby.client.am.SqlException: Syntax
>> error: Encountered "NULL" at line 1, column 111.Error Code: -1
>> Call:INSERT INTO session.TL_CMP3_EMPLOYEE (EMP_ID, VERSION, ADDR_ID,
>> ROOM_NUM) SELECT t0.EMP_ID, (t0.VERSION + 1), NULL, t1.SALARY FROM
>> CMP3_EMPLOYEE t0, CMP3_SALARY t1 WHERE ((t0.F_NAME =
>> 'testUpdateUsingTempStorage') AND (t1.EMP_ID = t0.EMP_ID))
>> Query:UpdateAllQuery()
>> 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.updateAllUsingTempTables
>> (DatasourceCallQueryMechanism.java:749)
>> at
>> oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.updateAll(DatasourceCallQueryMechanism.java:711)
>> at
>> oracle.toplink.essentials.queryframework.UpdateAllQuery.executeDatabaseQuery
>> (UpdateAllQuery.java:165)
>> 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.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:372)
>> at
>> oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.internalUpdateUsingTempStorage
>> (EntityManagerJUnitTestSuite.java:3204)
>> Caused by: org.apache.derby.client.am.SqlException: Syntax error:
>> Encountered "NULL" at line 1, column 111.
>> at org.apache.derby.client.am.Statement.completeSqlca (Unknown
>> Source)
>> at
>> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown
>> Source)
>> at
>> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown
>> Source)
>> at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate
>> (Unknown Source)
>> at
>> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown
>> Source)
>> at
>> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown
>> Source)
>> at org.apache.derby.client.am.Statement.readExecuteImmediate (Unknown
>> Source)
>> at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>> at org.apache.derby.client.am.Statement.executeUpdateX(Unknown
>> Source)
>> at org.apache.derby.client.am.Statement.executeUpdate (Unknown
>> Source)
>> at
>> oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:630)
>>
>>
>> On 3/11/07, * Marina Vatkina* <Marina.Vatkina_at_sun.com
>> <mailto:Marina.Vatkina_at_sun.com>> wrote:
>>
>> This is really strange as the issue 1451 was a fix for Derby.
>>
>> Wonseok, are you using an embedded or a server mode for Derby?
>>
>> thanks,
>> -marina
>>
>> Wonseok Kim wrote:
>> > Hi, Andrei and Chris
>> >
>> > On Derby I'm hitting 2 failures which seem to be derived from
>> recent
>> > changes.
>> >
>> > Testcase: testUpdateUsingTempStorageWithParameter took 0.15 sec
>> > FAILED
>> > Exception thrown: class
>> > oracle.toplink.essentials.exceptions.DatabaseException
>> > junit.framework.AssertionFailedError: Exception thrown: class
>> > oracle.toplink.essentials.exceptions.DatabaseException
>> > at
>> >
>>
>> oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.internalUpdateUsingTempStorage
>>
>> > (EntityManagerJUnitTestSuite.java:3213)
>> > at
>> >
>>
>> oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorageWithParameter(EntityManagerJUnitTestSuite.java
>> :3159)
>> > 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: unknown took 0 sec
>> > FAILED
>> > Warning, RAW type used for Primary keys only supported on Oracle
>> > junit.framework.AssertionFailedError: Warning, RAW type used for
>> Primary
>> > keys only supported on Oracle
>> > at
>> >
>>
>> oracle.toplink.essentials.testing.tests.cmp3.datatypes.arraypks.PrimitiveArrayPKCachingJUnitTestCase$1.setUp
>> > (PrimitiveArrayPKCachingJUnitTestCase.java:46)
>> > at junit.extensions.TestSetup$1.protect (TestSetup.java:18)
>> > at junit.extensions.TestSetup.run(TestSetup.java:23)
>> >
>> > The first test was added with the fix of issue 1451 by Andrei.
>> Is this
>> > test expected to work on Derby?
>> >
>> > The second test appears to be intended only for Oracle, but
>> which was
>> > added to FullRegressionTestSuite like below. Shouldn't this test
>> skip in
>> > case of other database?
>> >
>>
>> http://fisheye5.cenqua.com/changelog/glassfish/entity-persistence-tests?cs=MAIN:chris_delahunt:20070309151945
>> >
>> > Thanks,
>> > -Wonseok
>>
>>
>
>