You are currently browsing the monthly archive for July 2010.
Recently, I had to work on Eclipse for writing Servlet and JSP programs which connects to the MySQL database. I want to configure Eclipse to use Apache Tomcat as server and connects to MySQL database using Servlet program so, I googled it to find what to do as many of them does, but I haven’t found any resource which provides straight forward guide to fulfill my requirement.
After doing some experimental things i have understood the procedure of configuring it so thought of putting a post about it. By the end of the following steps you will be able to configure your eclipse to run Servlet and JSP programs to connect to the MySQL database.
- Install MySQL Database.
- Install Apache Tomcat.
- Install Eclipse IDE for Java EE Developers.
- Check whether MySQL is properly installed and running on the system by following below steps:
- Open terminal or command prompt.
- Enter “mysql -u root -p” (Here the username is root).
- Enter the password when prompted.
- Now create a database using “CREATE DATABASE EXAMPLE”(Here EXAMPLE is the name of database).
- Select the database using “USE EXAMPLE”.
- Create the tables according the required schema.
