Hi, I was recently brought in to my first programming company/job. I was placed on a project that already had code written by someone who has never been a programmer and it didn't work. Rather than troubleshoot the poorly organized and written code I asked if I could rewrite the code from scratch. Here is where the issues come in, I am a relatively well versed programmer, but my expertise lies in .NET. Unfortunately for me, the client made specific strict requirement that the code be an open source platform. I have found that
JAVA will be the best platform for me, but I have little experience in it. What I need to be able to do is compare 2 tables from different databases. The first database is a list of clients and their personal information like addresses, etc. the second database should have the same information, but when the client updates information they only update it in database 2. I need a nightly reconciliation that compares all information, and updates database 1 with the new or updated information from database 2. It seems simple in my head but my head thinks in c# rather than java. The kicker is, the program has to ask the user for confirmation before it submits changes. Sorry for the long post, I just need a place to start.