Re: Dev - Derby BLOB problem

Posted by Jacopo Cappellato on
URL: http://ofbiz.116.s1.nabble.com/Dev-Derby-BLOB-problem-tp166851p166852.html

Hi Leon,

I've run the tests in the latest SVN rev with Derby and all the tests
completed without errors.

Can you reproduce it in OFBiz too?

Jacopo


Leon Torres wrote:

> 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
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev