File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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?
Similar Threads
number of results
method criteriaFind
problem with merging records from two tables while sorting
batch insertion into database
Removing duplicate records