?
Solved

Select components for Java web database application

Posted on 2004-03-24
3
Medium Priority
?
152 Views
Last Modified: 2013-11-24
I wish to produce a database application, written in Java, which will be used to provide use of database information to a pool of about 50 users. I want them to be able to use the application via their browser. Most users will be on an intranet but I want it to be accessible to a few outside the office via internet connection. In trying to plan this project,the more I've researched the problem, the more lost I've become between Apache- Tomcat- Java- JSP- Servlets- JNDI- JDC Connector- and my MySQL database. I know I need a more complex solution than JDO, but I'm really confused about what I need besides Apache server, Java, and the mySQL database. I know there is no single path but I'm makng little progress in choosing. If someone could outline a reasonable plan for this project, I think I could direct my own study more effectively. (I know this could have been done more simply with PHP and mySQL, but I want to use the opportunity to learn Java and OOP.)
Thanks for any help.
0
Comment
Question by:andem
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Assisted Solution

by:Tommy Braas
Tommy Braas earned 400 total points
ID: 10671921
Apache is a pure webserver. Tomcat is a webserver and a JSP/Servlet container. Apache and Tomcat can be integrated, not recommended though. JNDI is used for lookingup services, I doubt you will need it for your project, but it is worth looking into. JDBC is used for connecting to databases (e.g. mySQL).

Plan:
1. Learn J2SE
2. Learn J2EE
3. Choose JSP/Servlet container based on your needs (you might even need an EJB container)
4. Plan, analyze and design your application
5. Deploy your application internally first, then externally

Any and all URLs in a web application can be password protected (user authentication and authorization).
0
 
LVL 3

Accepted Solution

by:
eicheled earned 600 total points
ID: 10672155
If it were me :-)

I would use Tomcat (with or without Apache). If you are not serving a bunch of static content outside of your dynamically created data, there is not much gain in using both (and integrating them to work together can be a challenge).

I would use MySQL as a database (it's simple, free, and handles most things a basic end-user application might need).

I would use JSP. Tomcat and JSP go hand in hand, and JSP's are easier to write than servlets. In your JSP's you will produce the HTML that your end-users see based on the information from your DB.

To talk to the db (MySQL or whatever you choose) you will need JDBC (most DB's supply the necessary Java classes you need as a jar file) which you will need to use to allow your JSP's (which are being served by Tomcat) to talk to your db.

Just my $.02
0
 

Author Comment

by:andem
ID: 10677292
Thanks to both of you for your help.
Orangehead911, your succinct overview of the process reminds me of what a large task I've elected to take on and clearly delineates the broad path for me.
Eicheled, you have given me just what I wanted- a suggestion of specifically which of the myriad options I might use to accomplish this. I had thought that Tomcat had to be used as a part of Apache (the ignorance is deep!). I will definitely go the Tomcat route as almost all will be database driven dynamic content. I already have a MySQL database so there is no question there of what to use. I have downloaded  Connector/J from the MySQL site and plan to use JSPs based on your recommendation. Thinning out the forest so that I can actually see the trees is so helpful! I know I have a lot of work ahead but should now be able to approach it in a more efficient manner.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses
Course of the Month13 days, 4 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question