File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How Multimap  Records of 1'st table to 2'nd one? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How Multimap  Records of 1 Watch "How Multimap  Records of 1 New topic

How Multimap Records of 1'st table to 2'nd one?

abraham pak

Joined: Apr 29, 2003
Posts: 1
Hi all;
I've problem in making a database and connecting it to JDBC,in a form which needs a 'random' iteration over the db's records.
Another problem I have,is a way to create a multimap,which could be useful for mapping any records of the first table to a multi-record set of another table(having order or randomly or...;like mapping all the records of first one to a group of 3 records in second table);I mean just like the ability used in collection interface(multimaps).Any recommendations in any form of stored procedures,java algorithem,sql batch ,...OR just showing me a way to handle this type of db would be grateful.
I agree. Here's the link:
subject: How Multimap Records of 1'st table to 2'nd one?
It's not a secret anymore!