Win a copy of Emmy in the Key of Code this week in the General Computing forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Ron McLeod
  • Carey Brown
  • Paweł Baczyński
  • Piet Souris
  • Vijitha Kumara


Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
pie sneak
Posts: 4727
Mac VI Editor Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I were approaching this problem (and not using Hibernate) I think I'd make a transactional method that makes three separate calls.
Put the moon back where you found it! We need it for tides and poetry and stuff. Like this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!