Forms Database Creation Script

 

 

 

Quick and dirty Workstation setup

This can take hours, depending on the speed of your internet connection J


 

Technology Stack

 

What is a Web Application Environment?

 

  1. A GUI Development Environment (Java – what else?)
  2. A Web/App Server
  3. A Database Engine
  4. A Database GUI
  5. A Browser

 

…or in other words, everything you need to develop, run, test and debug a fully featured, web based application.

 

Here is my definitive How-to for setting up a Web application environment. It is a step-by-step guide to getting everything you need to start developing Web based applications. I have gone through this process many times, and always end up doing a thousands googles to get it right. So I decided to put it all down, with screen shots documenting every step.

 

I hope it works for you, as well as it has worked for me. I use it every time I setup a workstation.

 

 

MySQL:

http://dev.mysql.com/downloads/mysql/5.1.html

 

Java Sun SDK/GlassFish:

http://java.sun.com/javaee/downloads/index.jsp

 

Eclipse:

http://www.eclipse.org/downloads/

 

SQLyog:

http://www.webyog.com/en/downloads.php

 


Setup:

 

FYI: As a general rule, I download and save my installs, rather than simply selecting ‘Open’ – it makes it easier to re-install, or to quickly reference versions/sizes.

 

Also, I tend to install nothing into the default environment (c:/Program Files/…) as it makes path-ing painful. I suggest putting everything in main directory, and each product into a sub-directory.

 

 

Double click and install the Java_app_platform_sdk_5_06-windows.exe files. Follow the instructions. This install is pretty straight forward, and will not be covered here.

 

Click to view the tutorial on Installing and Setting up Eclipse

 

Click to view the tutorial on Installing and Setting up MySQL

 

Configuring Eclipse to use GlassFish

 

Click to view the Tutorial on Installing and Setting up SqlYog

 

Setting up Connection Pools

 

AsyncFW Users:

 

Click to view the Tutorial on Installing and Setting up FWAdmin

 

Click to view the AsyncFW Configuration and Properties Tutorial

 

 

 

 

Copyright 2009. All rights reserved by

S. Chappell