Inserting a row in to a table using CMP entity bean( 2.1)

[veena sasi]

Hello,

I am using CMP entity bean using EJB 2.1. I want to insert in to customer table datas id, user_name, submit_date and requested_item. Since there is no primary key in this , i am planning to use auto generated primary key. For inserting data in to tabe where have I to write query ? I understand that( I am not sure on this) I have to use the primary key in the query. How I can do this. i started the bean code as below. COuld anybody help by telling how to specify the query and how that will be executed

  
 
// used annotation to define home, remote etc  
AutomaticKeyGeneration (cacheSize = "1",
name = "myseq",
type = AutomaticKeyGenerationType.SEQUENCE)              
 
@JndiName(local = "ejb.enquiry.ejbRefLocal",
  remote = "ejb.enquiry.ejbRef")
public abstract class DataUpdateBean extends BaseEntity {
 

        @CmpField(column = "id", primkeyField = Constants.Bool.TRUE)
@LocalMethod()
@RemoteMethod()
public abstract Integer getId ();
// abstract fields are defined here--------
 

}