I am extending SimpleJdbcDaoSupport in my Dao implementation and I have a question regarding linking tables i.e ManyToMany relationships. I have three tables: product category and category_product being the linking table that just holds the ID's of category and product tables.
So to insert a new product I would have to 1. insert the product details 2 retrive the Id of the newly inserted product 3 insert category id and product id into the category_product table. Is there a simple or recomended way of achieving this, short of calling getSimpleJdbcTemplate three times, or is a stored procedure the way to go? really appreciate any response you may have.