1 Reply Latest reply on Apr 2, 2004 12:56 PM by adrian.brock

    Automatic PrimaryKey Generation with Hypersonic DB



      I'm using CMP and I want to setup a simple customer. It has an ID, NAME , and some other String-fields. ID is the primary key and hast got Integer-format. When I am adding a client I only want to add the name and the other fieds. I want to generate an unique Integer Primary Key, which will automatically increment.
      How can I do this by using Hypersonic, i have searched for examples but I haven't found.
      Where can I find examples?
      Can I use a special table, like in WLS 6.1 (Sequence table).