Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.x

Does hibernate require sql queries to be in specific mapping files?

Consider the following scenario:
1. An application needs to be able to be used against different databases
2. Some queries are native sql queries (for performance reasons, etc)
3. There is a mapping file for a table called 'customer'

The native sql queries being different for different databases can these be
located in a seperate mapping file or does hibernate require the queries to be in the 'customer' mapping file only?

As long as the mapping files get defined to the Configuration prior to creating your SessionFactory, they can be in a file by themselves.