Posted by
Leon Torres-2 on
URL: http://ofbiz.116.s1.nabble.com/Dev-Derby-BLOB-problem-tp166851.html
Hi folks,
I ran the updated EntityTestSuite with the BLOB tests on a fresh Sequoiaerp 0.8.3. (This involves copying the java file
and the entity*_test.xml from framework/entity and doing ant run-tests).
The Entity Engine is still crashing when trying to create/read BLOBS. The test suite's messages are:
[JUNIT] ---------------------------- FAILURES ---------------------------- [JUNIT]
[java] 67960 (main) [ JunitContainer.java:104:INFO ] --> testSetNullBlob(org.ofbiz.entity.test.EntityTestSuite):
GenericEntityException:org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity:
[GenericEntity:TestBlob][createdStamp,2006-02-10 10:00:16.54(java.sql.Timestamp)][createdTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][lastUpdatedStamp,2006-02-10
10:00:16.54(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][testBlobId,null-blob(java.lang.String)] (while inserting:
[GenericEntity:TestBlob][createdStamp,2006-02-10 10:00:16.54(java.sql.Timestamp)][createdTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][lastUpdatedStamp,2006-02-10
10:00:16.54(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][testBlobId,null-blob(java.lang.String)]
(SQL Exception while setting value on field [testBlobField] of entity TestBlob: (An attempt was made to get a data
value of type 'BLOB' from a data value of type 'BINARY'.)))
And the exception trace where the error occurs reads:
[java] ---- stack trace ---------------------------------------------------------------
[java] org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity:
[GenericEntity:TestBlob][createdStamp,2006-02-10 10:00:16.54(java.sql.Timestamp)][createdTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][lastUpdatedStamp,2006-02-10
10:00:16.54(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][testBlobId,null-blob(java.lang.String)] (while inserting:
[GenericEntity:TestBlob][createdStamp,2006-02-10 10:00:16.54(java.sql.Timestamp)][createdTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][lastUpdatedStamp,2006-02-10
10:00:16.54(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-10
10:00:16.539(java.sql.Timestamp)][testBlobId,null-blob(java.lang.String)] (SQL Exception while setting value on field
[testBlobField] of entity TestBlob: (An attempt was made to get a data value of type 'BLOB' from a data value of type
'BINARY'.)))
[java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:140)
[java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
[java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
[java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:547)
[java] org.ofbiz.entity.test.EntityTestSuite.testSetNullBlob(EntityTestSuite.java:531)
Any ideas why this might be happening?
- Leon
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev