You're looking for free systems advice? Seems like you need a consultant.
Let me see if I understand this correctly.
You have a central computer running Windows XP. I assume that this computer has two network cards, one of which is connected to an isolated LAN of up to five computers. The other is connected to the internet (or some other more public network.)
The 5 computer on the isolated LAN are pumping data into a MySQL database.
You would like to write a web application that accesses the MySQL database and provides information to people who are accessing it via the public network.
Sounds trivial to me. For the web app, pretend that the private network doesn't exist, that only the MySQL database exists. And when you run JBoss, use the -b boot option to specific the IP address for the network card that is on the public network.
GenmanI was wondering if JBoss was the direction I wanted to go in. Seeing as I am unfamilair with JBoss AS, Tomcat etc, I am not sure which one if any was the direction I should go.
I stumbled into this place via Pentaho and their application so there are numerous options and I am looking at.
PeterJ Thank you for the reply. From the sounds of your comments, JBoss is a possible direction for me but now I still need to figure out what pieces and parts will allow me to do the task at hand.
So far the Pentaho folks called me back today and helped clarify things regarding their product. I think I may need a more custom app and why I am looking here.