Alternative persistence.xml for TestNG suite

[bartmatthaei]

Hi,

I've used JBoss Tools to generate an EAR style seam project for me. Works fine, but now I want to use the test project to do some integration tests on my components.

The trick here is that the development environment uses a MySQL datasource, but I want the embedded jboss that runs my tests to use DefaultDS or some other HSQL datasource.

I am able to offer an alternative datasource in the project-ds-test.xml, but since my persistence unit has the MySQL dialect set, I get errors when it tries to generate my tables in HSQL. This is fixed if I change the dialect in the persistence unit, but I don't want to change the dialect every time I run some tests.

Is there any way to offer an alternative persistence.xml when the project is deployed with TestNG / embedded jboss?

Regards,

Bart

[amitev]

There isn't a way to provide an alternative persistence.xml but there is a way to provide an alternative DataSource which is enough in your case. Put the datasource in the classpath of your integration test project.

[bartmatthaei]

Alternative DataSource isn't enough, since the dialect also needs to change (from MySQL to HSSQL). Or can I specify this in the datasource somehow?

[kapitanpetko]

Use Maven (or Ant or whatever) filtering to change your xml/propeties files before the tests run. Something like this, where ${hibernate.dialect} changes from mysql to hsql.

 <property name="hibernate.dialect" value="${hibernate.dialect}" />

HTH