EDIT: Ok, if someone reads this and is interested, I've been following this really useful wikibook on the topic. Is more or less what I was looking for, at least to get a good intro on what JPA is and how it works.

Well, sorry if this question is a bit broad, but I haven't been able to find any help... anywhere.

We are working in the first stages of a new CRUD application using Java and an Oracle database. I've been told to write some configuration files for the project, going from the scripts to create the database to the file that gives the title to the post. All by hand and using as a point of entry an already designed database model.

So, I've never been on a development from day one, and most of this stuff was always done by someone else. And I'm quite lost for the orm.xml file.

For what I've seen on the internet, usually this file is created automatically using some kind of eclipse plugin, but we don't even have yet the DB created, so it seems that I have to write everything manually, but I haven't found anything anywhere (besides ur old project's orm.xml files) to guide myself writing the more complex stuff (foreign keys, specifying relationships...)

I have already a model.xsd file to generate the .java classes and, well, the .sql file with the creation scripts, but the database is still nonexistant.

Any idea on where could I start?