We have a large number of "applications" that will be moved from Access to Java/J2EE/MS SQL or DB2.
The plan is to create database(s) that will be modified as needed whenever new related data is found. This will produce a merged DB instead of the mess of 500+ small databases all using some form of the same data.
I want to isolate the new applications from the DB changes. I don't want to change the Application every time a major DB change happens. I think J2EE and JBoss AS will help me do this but I'm not sure this will work right. Actually, I'm not sure how to implement this at all.
Can someone give me a clue? I obviously don't have one !