APEX

Well an entity needs an id, there is no way around it. However you could map more than one table to one entity. ( SecondaryTable ) The name of the class suggests that there is a CBAOutlineCertified object as well. Couldn't you map this table to it? Is there a foreign key on this table?

If that can't be done, I'm afraid you'll have to forget entities and use native queries to manage operations on this table.

Btw. couldn't the cbaId be used as an Id field? The name sort of suggests that it is the id of this entity.

-Zsom-

thanks Zsom, there is no foreign key on this tale and it's just and independednt table that i need to insert data into. It's more of warehousing table. I read somewhere that i can make all the colums with @Id and that will create a uniqueness to surpass my issue of not modifying tables in the database.

Id's don't have to be generated. Just use the fields in the tables that are already primary keys.
If there are tables without primary keys (shudder), then use the unique columns in them. You can create primary key classes for those properties.
That way you stick with the more portable JPA constructs too.

Is this issue solved? I am facing the same issue. The db table doesn't have any primary / unique key. Its a log table. Each column can also have null value. How can I solve this?????

Welcome to the forum. Please don't post in threads that are long dead and don't hijack other threads. When you have a question, start your own topic. Feel free to provide a link to an old post that may be relevant to your problem.

I'm locking this thread now.