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

Hibernate version:
I use the Nhibernate 1.0.3

I have a project which has been finished and use the SQL2000 as it's main database. In this project we choose "Guid" as the type of entities' Id
, such as:
<id name="id" column="assetShadowId" type="Guid" >
<generator class="guid" />
</id>.
So, in database SQL2003 the type of prime key is uniqueidentifier.
Everything is ok.
But, now, we need to move the project from the SQL2000 to Oracle.
Because Orcale10g does not support the uuid or guid.So in orcale's table the prime key is vchar2(32). However, we find that it's impossible to use
the "Guid" type anymore, for NHibernate oracle dialect can not convert guid to string.Could someone provide some advices to solve this problems? Otherwise, we have to change the generator of id.

Read this: http://hibernate.org/42.html