I am unable to find any documentation for using the native generator for IDs. I need to be able to switch between Oracle and Sqlite and Oracle. Oracle uses a sequence generator. The documentation says hibernate will autmatically pick whichever strategy the underlying db supports. But it looks like we at least have to pass in the seqence name for oracle . This suggests there is other configuration needed to acheive this. I tried
Code:
<generator class="native">
<param name="sequence">SEQ_NAME</param>
</generator>
it works for oracle but not for sqllite. It complains, sqllite doesnt know of any sequences ! . Any help or pointers would be much appreciated.
Thanks!