0 Replies Latest reply on Jan 21, 2004 10:57 AM by b_boyle18

    Primary key Question

    b_boyle18 Newbie

      I am setting up a CMP EJB and I'm not that sure about the primary key. In my database, I have an id which is the primary key, firstName and lastName. I have corresponding acessor methods in my EJB. When I'm adding a the firstName and lastName, if I dont specify an id in my create method arguments, will an id get automatically inserted into the database? i.e. number increments by 1 each time I add a row.

      I'm using postgresql, does this have a feature like MSaccess od oracle that will automatically increment the primary key field with every new entry?

      Hope someone can help,