Hello friends,
i need java source code for cross matching two large access database records (1st file is of 20000records {28 columns and 20000 rows} and 2nd file is of 39000records {30 columns and 39000 rows}).I need to compare each n every cell of 1st file to the each n every cell of 2nd file.i have written code for this but its not working for more then 20 records only, whenever i am trying to crossmatch more then 20 records, my netbean IDE stuck nd my PC restarts. my desired output should be tht record tht has same cell.
plz help
thanks in advance.
deepak_nuniwal
-6
Newbie Poster
Recommended Answers
Jump to Postya sure
its in my office desktop.
i will bring n post here on monday.
thanks.Till Monday then
Jump to PostHow about a table join.
SELECT * FROM Database1.TableName1 INNER JOIN Database2.TableName2 ON Table1.field1 = Table2.field1;
(Double check all this syntax, its psudo codish, and im not any kind of expert in SQL or Java)
If you want to do that in java just get a Connection …
Jump to PostThe point is that you don't do something through java if it can done through sql which is faster. So try to provide a better explanation about what you are trying to do.
Jump to PostI have two database's
1st database has 21 columns and 20140 records
2nd database has 27 columns and 61603 records.
i need to compare each and every cell of 1st database to each n every cell of 2nd database and the output should be the rows where two cells are …
All 16 Replies
peace_of_mind
0
Newbie Poster
deepak_nuniwal
-6
Newbie Poster
deepak_nuniwal
-6
Newbie Poster
javaAddict
900
Nearly a Senior Poster
Team Colleague
Featured Poster
peace_of_mind
0
Newbie Poster
noodlecode
38
Newbie Poster
javaAddict
900
Nearly a Senior Poster
Team Colleague
Featured Poster
deepak_nuniwal
-6
Newbie Poster
Salem
commented:
3 weeks, and all you can do is repeat the original question - post YOUR code, not excuses.
-6
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
javaAddict
900
Nearly a Senior Poster
Team Colleague
Featured Poster
deepak_nuniwal
-6
Newbie Poster
deepak_nuniwal
-6
Newbie Poster
javaAddict
900
Nearly a Senior Poster
Team Colleague
Featured Poster
vira nital
0
Newbie Poster
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
javaAddict
900
Nearly a Senior Poster
Team Colleague
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.