I created CMP
EJB for order processing. OrderId is the primary key and it will automatically be increased by 1 when new order come in. How can I write object sql in ejb-jar.xml to get the maximum number of order id? Is ther any other way to increase orderid every time except use object sql? many thanks