It looks like this has been asked a few times before, although I'm asking again because I don't think anyone has had quite the same configuration and I can't get it to work.
I have living-e AG with Apache 2.x, PHP5 and MySQL already installed and working. I am interested in adding Netbeans IDE 6.0 RC1 (already have) to my system and I'd like to get involved writing jsp pages with struts and with access to the MySQL database that I already have, unless you would recommend something else. Netbeans comes with GlassFish but I've disabled that. I do have a fair amount of experience writing jsp pages at work and I'd like to be able to play with a similar environment at home.
Given that I have MAMP already up and running and Netbeans already up and running I need some help with the following:
1. How do I configure NetBeans so that I can use the MySQL server already running. It looks like I have partial functionality in that I can access the MySQL server from netbeans using the built in services pane and connecting as jdbc:mysql://localhost:330
6/dbname, etc. The driver / connector looks like it is built in to Netbeans:
Beans 6.0 RC1.app/Contents/Resources
I need to know how to connect to the server from a jsp page and maybe from a .java file.
I did find this reference, but I'm either missing something or the instructions are not quite complete enough for me.
I will need a little help with struts once I get going, mostly on how to know what libraries I can import and where to get them.
2. As a separate issue, I need to be educated about how the standard apache web server and a tomcat server can interoperate. I had read somewhere that you need to install the mod_jk module to your apache server installation and then configure the server so that you could fetch servlets from a tomcat server. I got the first part with the module ok. I found a reference here:
about configuring a 3.3 server. There is also current documentation here:
but I don't know how to configure this or even if I need to configure it.