Use of sequence without creating an entity

hi,
I already have created a sequence in the database.
I want to use it to fill an ID field (auto-incremented then) of a table.
I did not create an entity for that table (i have to use a specific API to insert data into that table).

How can i get that sequence in Hibernate and use it to set the value of that ID field ?
Without using an entity that maps to that table.

thanks a lot for your help.

So you are trying to get Hibernate to update an entity it doesn't know about? The only possibility then is to use a native SQL query.

If you did have a mapped object the sequence could be used by using the sequence generation strategy. Any reason you can't map this entity?

well, i guess i could map it, but then i would use the entity only to get the next value of the sequence so i can use it to insert it into the table.

We are using product that ships with some API that we are required to use to modify/create/delete objects

well, i guess i could map it, but then i would use the entity only to get the next value of the sequence so i can use it to insert it into the table.

I'm not sure I understand. If your sequence exists to provide a primary key for a specific table you would map that table to a class. Hibernate would take care of getting/setting the key based on the next value from the sequence when you persisted a new instance of that class if you used the sequence key generation strategy in your mapping.

We are using product that ships with some API that we are required to use to modify/create/delete objects

So you are not using Hibernate to do this?

1) This field is not a primary key
2) cant map the table to an entity for the reasons i mentioned before

Anyways, I wrote a basic method that takes a sequence as a parameter, and i get an EntityManager and run a native query :

Problem solved, thanks.