OK, so here is my problem and I am looking for the best solution to fix it. I want to create a JSP driven site that can run on multiple databases. The only simularity that the databases will have is the structure, but as we all know it isn't that easy to mix the SQL statements together. I don't have the money to create an application that will change up the SQL statements and make them work for all of the databases this is implemented on, but I will be able to program the SQL to make it run correctly on each platform.
My problem is that I want to have SQL modules that can be changed based upon what DB I am using. Does anyone have any ideas on what might work and what would be the easiest way to do this.
Thanks,
Matt