I have a problem.I need to make a entity bean where the db is shared i.e. db can be accessed by other systems,also some body can also run the insert script at the data base level.To avoid the duplicate key exception I have put a trigger on the database level which with the help of a sequence genrates the pk.
The problem is my ejb create runs fine,but it is not associated with EJBObject.
Another way I tried was using a cmp bean without defining the PK.but in this case i cannot define by attribute name and it gives name as 'autoid', this does not suffice the purpose
Any suggestions how to do it.Putting a trigger and sequence is not mandatory.