Can anybody help me by telling my how to use an Oracle sequence with CMP. I know how to do it with BMP but I was hoping I could save myself a lot of work and use CMP.
You do it the same way. Write some code that gets the next sequence number, call that code from ejbCreate, and assign the id.