An attempt was made to put a data value of type 'byte[]' into a data value of type 'BIGINT'.

• Key: JDO-106
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: Michelle Caisse
• Reporter: Michelle Caisse
• Component/s: tck2
• Fix Version/s: JDO 2 beta

Description

SQL Exception: An attempt was made to put a data value of type 'byte[]' into a data value of type 'BIGINT'.
Affected tests:
org.apache.jdo.tck.models.fieldtypes.TestArrayListCollections
org.apache.jdo.tck.models.fieldtypes.TestLinkedListCollections
org.apache.jdo.tck.models.fieldtypes.TestListCollections
org.apache.jdo.tck.models.fieldtypes.TestVectorCollections


test(org.apache.jdo.tck.models.fieldtypes.TestArrayListCollections)javax.jdo.JDODataStoreException: Cannot set Object parameter: value = org.apache.jdo.tck.pc.fieldtypes.SimpleClass@cc969a85
at org.jpox.store.rdbms.mapping.LongVarBinaryRDBMSMapping.setObject(LongVarBinaryRDBMSMapping.java:194)
at org.jpox.store.mapping.SingleFieldMapping.setObject(SingleFieldMapping.java:235)
at org.jpox.store.rdbms.scostore.AbstractCollectionStore.populateElementInStatement(AbstractCollectionStore.java:333)
at org.jpox.store.rdbms.scostore.AbstractListStore.internalAdd(AbstractListStore.java:1615)
at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:333)
at org.jpox.store.mapping.ListMapping.postUpdate(ListMapping.java:269)
at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1810)
at org.jpox.store.StoreManager.update(StoreManager.java:710)
at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4069)
at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2917)
at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:431)
at org.apache.jdo.tck.models.fieldtypes.TestArrayListCollections.runTest(TestArrayListCollections.java:105)
at org.apache.jdo.tck.models.fieldtypes.TestArrayListCollections.test(TestArrayListCollections.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197)
at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)
at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)
NestedThrowablesStackTrace:
ERROR XCL12: An attempt was made to put a data value of type 'byte[]' into a data value of type 'BIGINT'.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.types.DataType.throwLangSetMismatch(DataType.java)
at org.apache.derby.iapi.types.DataType.setValue(DataType.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setBytes(EmbedPreparedStatement.java)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setBytes(NewProxyPreparedStatement.java:599)
at org.jpox.store.rdbms.mapping.LongVarBinaryRDBMSMapping.setObject(LongVarBinaryRDBMSMapping.java:189)
at org.jpox.store.mapping.SingleFieldMapping.setObject(SingleFieldMapping.java:235)
at org.jpox.store.rdbms.scostore.AbstractCollectionStore.populateElementInStatement(AbstractCollectionStore.java:333)
at org.jpox.store.rdbms.scostore.AbstractListStore.internalAdd(AbstractListStore.java:1615)
at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:333)
at org.jpox.store.mapping.ListMapping.postUpdate(ListMapping.java:269)
at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1810)
at org.jpox.store.StoreManager.update(StoreManager.java:710)
at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4069)
at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2917)
at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:431)
at org.apache.jdo.tck.models.fieldtypes.TestArrayListCollections.runTest(TestArrayListCollections.java:105)
at org.apache.jdo.tck.models.fieldtypes.TestArrayListCollections.test(TestArrayListCollections.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197)
at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)
at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)

Comments

[Craig Russell]

This is likely to be a mapping or schema issue.

[Andy Jefferson]

Looking at TestArrayListCollections, the message is now
test(org.apache.jdo.tck.models.fieldtypes.TestArrayListCollections)javax.jdo.JDODataStoreException: Cannot set Object parameter: value = org.apache.jdo.tck.pc.fieldtypes.SimpleClass@cc969a85 for column "applicationidentity0.ARRAYLIST_OF_OBJECT0.OBJREF" : An attempt was made to put a data value of type 'byte[]' into a data value of type 'BIGINT'.

Looking at field ArrayListOfObject0, it is ArrayList<Object> with a <join>, so hence we go to the join table "ARRAYLIST_OF_OBJECT0", and have a field to contain the Object called OBJREF. Since the element is an Object, and not a PersistenceCapable it is stored as serialised (by JPOX certainly, and I can't see why we should do different - the user can specify an ArrayList of "SimpleClass" if they want to store those). Hence the conclusion is that the schema is incorrect ARRAYLIST_OF_OBJECT0.OBJREF is a BIGINT, yet should be a LONG VARCHAR FOR BIT DATA

[Michelle Caisse]

We have agreed in principle on how to map Object types. Some issues remain, but I am entering new JIRAs for them.

[Michael Bouschen]

Reopened to set the Fix Version/s field to JDO 2 beta.