I have managed to create the datasource with Arquillian properties as you suggested.
Now I see hibernate creating the tables, and executing queries, but the @UsingDataSet annotation seems ignored and the database is not populated with the data from the dataset and the query returns zero entities. Here is the output http://pastebin.com/smFTJg1X On Sat, Feb 16, 2013 at 3:32 PM, Romain Manni-Bucau <[email protected]>wrote: > Resources.xml is in web-inf so shrinkwrap is fine. > > For global datasource use properties syntax in "properties" property of the > tomee container in arquillian.xml (ds = new://Resource?type=DataSource...) > Le 16 févr. 2013 15:08, "Luca Merolla" <[email protected]> a écrit : > > > Is it possible to use resources.xm like that: > > > > <?xml version="1.0" encoding="UTF-8"?> > > <resources> > > <Resource id="nuvolaDS" type="javax.sql.DataSource"> > > JdbcDriver org.h2.Driver > > JdbcUrl jdbc:h2:mem:nuvola_test;DB_CLOSE_DELAY=-1 > > UserName sa > > Password > > JtaManaged true > > </Resource> > > </resources> > > > > and then how do I configure in arquillian.xml to use this resource file? > > > > I have tried to add something like that but it doesn't work > > > > <container qualifier="tomee"> > > <configuration> > > <property name="openEjbXml">tomee-embedded/resources.xml</property> > > </configuration> > > </container> > > > > > > > > On Sat, Feb 16, 2013 at 12:09 PM, Romain Manni-Bucau > > <[email protected]>wrote: > > > > > Basically dbunit doesnt use the persistence.xml and with jta > persistence > > > unit the datasource is configure in arquillian.xml (in properties > > property) > > > or providing a tomee.xml. > > > > > > I know Jean-Louis extended dbunit to reuse the jndi datasource, maybe > he > > > could share his code > > > Le 16 févr. 2013 12:03, "Luca Merolla" <[email protected]> a > écrit > > : > > > > > > > Hi all, > > > > > > > > I'm still testing Arquillian with TomEE embedded and I would like to > > > load a > > > > dataset generated with DBUnit. > > > > > > > > I have seen some examples that are using the > > > > annotation @UsingDataSet("dataset.xml") however I don't see any > DBUnit > > > > information about the data loaded and in fact in my test cases, the > DAO > > > is > > > > returning null from the database query. > > > > > > > > Here is the project to reproduce the issue > > > > > > > > > > > > > > > > > > http://www.fileconvoy.com/dfl.php?id=gad1e779cec1eb3289992251597f1580011e18db1d > > > > > > > > I thought it was a problem of dependencies, then I have added DBUnit > in > > > > arquillian-pom.xml file but nothing changed. > > > > > > > > My application is using PostgreSQL, but for the testing I wanted to > use > > > an > > > > in-memory database like H2 or HSQL. In the persistence.xml I have > tried > > > to > > > > configure HSQL. > > > > > > > > Thanks in advance, > > > > LM > > > > > > > > > > > > > > > -- > > *Luca Merolla* > > Management, Business & Technology Consultant > > > > > > <http://maps.google.com/maps?q=&hl=en> *Mobile:* +393774569974 > > *Email:* [email protected] > > *www.linkedin.com/in/lucamerolla* > > *Website <http://www.merollaconsulting.com>* > > > > > > Merolla Consulting Limited > > > -- *Luca Merolla* Management, Business & Technology Consultant <http://maps.google.com/maps?q=&hl=en> *Mobile:* +393774569974 *Email:* [email protected] *www.linkedin.com/in/lucamerolla* *Website <http://www.merollaconsulting.com>* Merolla Consulting Limited
