1 Reply Latest reply on Nov 25, 2015 3:28 AM by kamranahmed

ORAData during Arquillian Test execution

kamranahmed Nov 16, 2015 4:30 AM

Hi,

I am new to Arquillian, just have basic understanding on its usage.

I am stuck with one problem during test execution, i have tried a lot but could not get through.

The problem i am facing is somehow similar to Re: Arquillian Persistence questions and a possible bug in 1.0.0.Alpha5 on an Oracle database .

But unfortunately it has not been answered yet.

Let me explain the problem in details.

We have following hierarchy of archives as deployment unit.

xyz-main.ear

lib/<all third party jars>
xyz-main-lib.jar/<contains some singleton EJB timer services which executes on scheduled time>
xyz-dao-lib.jar[used by item#2]
common-lib.jar/<Few common classes to be used by other modules> [used by item#2]

Code base pom.xml hierarchy:

<project>

...

<modules>

<module>source</module>

<module>ear</module>

<module>test</module>

</modules>

...

</project>

arquillian.xml, test pom.xml fragment and dataset being used are attached.

We are using Oracle 11g as Database and Arquillian Persistence Extension for DB-Unit functionalities.

We had a requirement to persist some entities before test execution, so we decided to use arquillian-persistence-extension but stuck with 'nvarchar2' datatype.

Code fragment for Test Case:

@Deployment

public static EnterpriseArchive createDeployment() {

EnterpriseArchive mainEar= ShrinkWrap.create(ZipImporter.class, "xyz-main.ear")

.importFrom(new File(System.getenv("APP_HOME") + "/main-project/ear/target/xyz-main.ear"))

.as(EnterpriseArchive.class);

final JavaArchive integrationTestArchive = ShrinkWrap.create(JavaArchive.class, "tests.jar");

integrationTestArchive.addClasses(TestClassName.class);

integrationTestArchive.addAsManifestResource(new File(Thread.currentThread().getContextClassLoader().getResource("persistence.xml").getFile()), "resources/persistence.xml");

mainEar.addAsModule(integrationTestArchive);

return mainEar;

}

@Test

@UsingDataSet("dataset.xml")

@Transactional

@Cleanup(phase = TestExecutionPhase.BEFORE, strategy = CleanupStrategy.USED_ROWS_ONLY)

public void verifyData(){

// Verification of persisted object

}

Problem:

We have 'NVARCHAR2' for Arabic Data e.g. AR_DESC in dataset.xml .

If <property name="datatypeFactory">org.dbunit.dataset.datatype.DefaultDataTypeFactory</property> is being used in arquillian.xml and there is no column in dataset.xml of type NVARCHAR2, the record will get persisted easily with some warning as given below.

(1111, 'NVARCHAR2') not recognized and will be ignored. See FAQ for more information.

Potential problem found: The configured data type factory 'class org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems with the current database 'Oracle' (e.g. some datatypes may not be supported properly). In rare cases you might see this message because the list of supported database products is incomplete (list=[derby]). If so please request a java-class update via the forums.If you are using your own IDataTypeFactory extending DefaultDataTypeFactory, ensure that you override getValidDbProducts() to specify the supported database products.

When we update 'datatypeFactory' to org.dbunit.ext.oracle.Oracle10DataTypeFactory it starts throwing a different exception which is sort of annoying for us.

Provided that ojdbc6.jar is available in ear's lib folder as well as in jboss module.

12:12:16,607 WARN [org.jboss.modules] (pool-1-thread-1) Failed to define class org.dbunit.ext.oracle.OracleSdoGeometry in Module "deployment.arquillian-service:main" from Service Module Loader: java.lang.LinkageError: Failed to link org/dbunit/ext/oracle/OracleSdoGeometry (Module "deployment.arquillian-service:main" from Service Module Loader)

at org.jboss.modules.ModuleClassLoader.defineClass(ModuleClassLoader.java:407) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.ModuleClassLoader.loadClassLocal(ModuleClassLoader.java:254) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.ModuleClassLoader$1.loadClassLocal(ModuleClassLoader.java:73) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.Module.loadModuleClass(Module.java:518) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:182) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398) [jboss-modules.jar:1.2.0.CR1]

at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120) [jboss-modules.jar:1.2.0.CR1]

at org.dbunit.ext.oracle.OracleSdoGeometryDataType.<init>(OracleSdoGeometryDataType.java:143) [arquillian-service:]

at org.dbunit.ext.oracle.OracleDataTypeFactory.<clinit>(OracleDataTypeFactory.java:57) [arquillian-service:]

at java.lang.Class.forName0(Native Method) [rt.jar:1.7.0_45]

at java.lang.Class.forName(Class.java:190) [rt.jar:1.7.0_45]

at org.jboss.arquillian.persistence.core.configuration.ConfigurationTypeConverter.convert(ConfigurationTypeConverter.java:191) [arquillian-service:]

at org.jboss.arquillian.persistence.core.configuration.ConfigurationImporter.createConfiguration(ConfigurationImporter.java:153) [arquillian-service:]

at org.jboss.arquillian.persistence.core.configuration.ConfigurationImporter.createFrom(ConfigurationImporter.java:105) [arquillian-service:]

at org.jboss.arquillian.persistence.core.configuration.ConfigurationImporter.loadFromPropertyFile(ConfigurationImporter.java:80) [arquillian-service:]

at org.jboss.arquillian.persistence.dbunit.configuration.DBUnitConfigurationRemoteProducer.configure(DBUnitConfigurationRemoteProducer.java:43) [arquillian-service:]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_45]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_45]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_45]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_45]

at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:94) [arquillian-service:]

at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:99) [arquillian-service:]

at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:81) [arquillian-service:]

at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:145) [arquillian-service:]

at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:116) [arquillian-service:]

at org.jboss.arquillian.core.impl.EventImpl.fire(EventImpl.java:67) [arquillian-service:]

at org.jboss.arquillian.persistence.core.lifecycle.PersistenceTestTrigger.beforeClass(PersistenceTestTrigger.java:99) [arquillian-service:]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_45]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_45]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_45]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_45]

at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:94) [arquillian-service:]

at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:99) [arquillian-service:]

at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:81) [arquillian-service:]

at org.jboss.arquillian.test.impl.TestContextHandler.createClassContext(TestContextHandler.java:92) [arquillian-service:]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_45]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_45]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_45]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_45]

at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:94) [arquillian-service:]

at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:88) [arquillian-service:]

at org.jboss.arquillian.test.impl.TestContextHandler.createSuiteContext(TestContextHandler.java:73) [arquillian-service:]