Reverse Proxy & Apache

Hi,

I´ve got the task to create a concept and finally integrate a System of , let us say 3 Apache Frontend Servers , located in the DMZ behind the firewall. There will be also a lot of JSP stuff, so we need Mod_jk ( Jakarta Tomcat ) .

These JSP´s directly communicate with oracle. So the Apache Servers must have a direct connect to the SSDMZ where the oracle DB Server is located.

This would be a generous security lack.

Now, my question.

How do I setup a reverse proxy which handles the request of the Fronted Servers to some special Tomcat Machines in SDMZ ,
which afterwards will grab the DB ?

All should look like the following :

------------------------------- DMZ ---------------------------------

+Apache Server +Apache Server +Apache Server

------------------------------ SDMZ --------------------------------

+Application Server with TomCat ....

----------------------------- SSDMZ --------------------------------

+Oracle DB





Where do i Have to put in the reverse Proxy ?
And how do I setup such machine ?

Thanks

chronoton