#191 Blob datatype / Oracle

[jtx]

Hi,

dbunit : 2.5.1
Oracle JDBC driver : ojdbc5-11.2.0.1.0.jar or driver 10.2.0.4.0
jdk 5

**XML DATASET : **

<dataset>
<myexample binary_field="XXXXX">
</myexample></dataset>

XXXXX is a Base64 value.

Oracle TABLE : BINARY_FIELD is BLOB.

Error message :
java.lang.ClassCastException: [B
at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8461)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8019)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8560)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:222)
at org.dbunit.dataset.datatype.BlobDataType.setSqlValue(BlobDataType.java:72)
at org.dbunit.database.statement.SimplePreparedStatement.addValue(SimplePreparedStatement.java:73)
at org.dbunit.database.statement.AutomaticPreparedBatchStatement.addValue(AutomaticPreparedBatchStatement.java:63)
at org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:200)
at com.github.springtestdbunit.DbUnitRunner.setupOrTeardown(DbUnitRunner.java:194)
at com.github.springtestdbunit.DbUnitRunner.beforeTestMethod(DbUnitRunner.java:66)
at com.github.springtestdbunit.DbUnitTestExecutionListener.beforeTestMethod(DbUnitTestExecutionListener.java:186)
............................

Thanks,
regards

[Jeff Jensen]

Thanks for the request. Did you implement this? Do you have test cases for it?
If so, please provide a patch for inclusion in dbUnit.