i have an application where you can create category and add products and save to Database.
i have order table and product table where you can create product (all product created goes here) and i also have link table order_product table.
now my problem is if i place a order which has for instance with 2 products i want only order and link table to be saved like,
order table ------
order_product- this is link table with order_id and product_id
wen i submit order i'll have product id's so i need to save product details like order id 1 will have product id 1,2.
thanks for the reply the problem here is wen i save order object then order,order_product,product table will be updated i already have product id so only thing i need to update is order,order_product am using hibernate and MSQL, i dont want product table to be updated