Is there any way to use another sequence instead of ONLY ONE?
I have multiple tables and they all need differente sequence types, why I'm allowed only to use this? why I cant map my existing sequences????????????

The way to do things in Hibernate is to read documentation, including JavaDoc, not write silly forum posts with hundreds of question marks.

I use that but I receibe 'hibernate_sequence' does not exist, yet I've set as

Then when I changed both generator class and param name to 'products_id_seq' just to see what happens, it starts working, but when I gets deployed again, obviusly, it says class does not exist.
Am I missing something?

Sounds like some deployment problems to me.

Use this

<id
name="custId"
type="java.lang.Integer"
column="CUST_ID"
>
<generator class="sequence">
<param name="sequence">CUSTOMERS_SQ</param>
</generator>
</id>


But it's seem's to be a deployment problem so when you change an XML mapping file, try to restart your app server after deploy.

I assume that your are using Postgres. The define a row as ID with SERIAL as type the will create a sequence with "Tablename"_id_seq. That's it.

regards

Olaf