Updating information

[starheartbeam]

I have a java program that has a bunch of subscribers that have id's.

I need to write a program to reconcile between the subscribers in this database and make sure they are in my billing database.

I have to be able to do it in two different ways. One I have to be able to type in a subscribers usernames and reconcile just that one. The second is to reconcile all the subscribers.

I will be tracking when these have been last recon date in my database.
So when I go to this form that I have it will list all the subscribers their ids and recon date. Then I would ether push the recon sub button for just one or recon all.

I just am at a lose for what to do.
Any ideas? Any help at all would be great!!
Thanks!

[Kuriyama]

So you have two databases and you want to get a list of all customers that are in one and not the other?

Why not just use a SQL Query for this? It would be a lot easier than writing a Java program.

[starheartbeam]

So you have two databases and you want to get a list of all customers that are in one and not the other?

Why not just use a SQL Query for this? It would be a lot easier than writing a Java program.

Its not that I want to get a list of all the customers that are in one and not the other. I want to reconcile the databases.

[Kuriyama]

Is there a certain field you are trying to reconcile?

Regardless, you can do this sort of thing with pure SQL.

[starheartbeam]

I just need to make sure that the subscribers are in billing database by eather doing it for just one subscriber or all the subscribers.
This is going to be like a little programmer that someone else is going to use.

I know i will have to use SQL in with the java. But just having trouble with how to go about doing this.

[Kuriyama]

I understand now.

Really, you have 2 options.

1.) Make a Swing app that the user will have to run on their pc.
2.) Create a small web app to handle this.

I highly recommend option 2 for a few reasons. Unless you have a good amount of Swing knowledge, making desktop java apps can be painful and take a lot of time. You also run into issues if you are trying to access internal resources, or use internal pathing. Say for instance users now want to use this tools outside the office?

I would recommend that you use a web application to handle this sort of thing if possible. If that isn't an option and you really want to make a desktop application, I would stay away from Java and try .NET.

[starheartbeam]

That is what I was thinking, making a web application.