Hi.

Is it possible to make one mapping file for multiple db types?
My problem is that i have a application that supports multiple databases
and in the mapping file i need to define the generator either native or sequence. (Oracle, MSSql) Do I need a separate mapping file for each db type or it is possible to set the generation afer loading the asseblies?
Or is there some other way?

Please help!

Thanks
Markov

Native actually means different things to different databases. For MS SQL, native is the same as identity. For Oracle, native is sequence. You may be able to make use of this fact.

To add to the previous post: when you set the generator to native with a sequence, the SQL server dialect will just ignore the sequence. This allows to have a single mapping file for multiple databases.

Thanks for the quick answer.

I have tried this:
"NHibernate.Dialect.OracleDialect"
"NHibernate.Connection.DriverConnectionProvider"
"NHibernate.Driver.OracleClientDriver"
for the ado connection with the oracle8i...
Mapping file:
<id name="AttributeId" column="ID_attribute" type="Int32" unsaved-value="0">
<generator class="native">
<param name='sequence'>SQ_attribute</param>
</generator>
</id>

after i have tried to buid the factory i got the following error:
"Dialect does not support identity key generation"

what i can do about this??

Thanks

Are you sure there isn't another class mapped somewhere with <generator class="identity">?
The mapping in your example looks perfectly fine and I use the same construct to support SQL Server (identity), MySQL (identity) and PostgreSQL (sequence).

it is really strange... i searched twice over all files in the solution and found no identity entries at all.. i'll try to delete all builded dll's and delete all registry entry and try again.

i solved the problem. (it was in the configuration instance)

thank you both for help :)

greetings
markov