I am trying to create a multi-tier database system where I have an application, a JDBC driver that I write, a Oracle Driver, MySQL driver, and Oracle and MySQL databases.

I have some tables on the Oracle db and some tables on the MySQL db that are related. My issue is this: I need to write a JDBC driver (let's call it MyJDBC) that is called when I click on a button in my application. MyJDBC should then call the appropriate driver according to which table I am referencing.....

Is there anyone out there that knows how to do this?? I have it right now so that I when a button on my app is pressed it can call directly to the Oracle DB. But I need to integrate the two db's this way.

Help me please.