Hello,

I'm not sure how to solve my problem the best way:

I'm working with hibernate 3.1 alpha 1, Hibernate Annotations 3.1 , EntityManager 3.0.

I have lots of tables with lots of relations in-between.
I want to fill my tables by reading the datas out of a textfile. At the time I'm reading my datas, it is possible to identify the table, and the sort of datas that have to be stored. This all is fully dynamical.
Now begins my problem. I have my new dataset and I know the table where the datas should be inserted. Is it possible to take native sql for an insert, is it possible in any way that hibernate also updates all the relations?
Or is it better to write my datas in pojos and then save that pojo?

I hope anybody can give me an advice how to solve this problem in the best way!

Thanks,

Gaby

I use dbUnit for prepopulation of data (test or otherwise) into my databases. dbUnit can also create the XML dataset by extracting the data snapshot from the database. There are other methods aswell, insert scripts work fine - usually have less issues if you drop the constraints, do the load then re-apply constraints.