search

ppodgorsek / spring-test-dbunit

Integration between the Spring testing framework and DBUnit
Apache License 2.0
41 stars 6 forks source link

It is not possible to have multiple connections if databases use different syntax #138

Open Nidum opened 5 years ago

Nidum commented 5 years ago

On our project we have 2 databases: MySql and HBase under Apache Phoenix library. The thing is, that these two databases need to use different databaseOperationLookup classes, because MySql uses standard "Insert", while Phoenix supports "Upsert" operation only (Upsert operation inserts rows into a database table if they do not already exist, or updates them if they do.). It would be nice, if a user could configure different databaseOperationLookup classes for different db connections.

ppodgorsek commented 5 years ago

Unfortunately, I haven't seen anything related to Phoenix in DBUnit. As this project relies on what DBUnit supports, it would be necessary to first submit an issue in the DBUnit project, this support could probably be done based on logic similar to what can be found in org.dbunit.ext.mssql.InsertIdentityOperation.

Once done, I would then be able to provide support for it here too.