Aiki Innovations Inc. Table ADministrative Tool (TAD) - Over 88 Java/J2EE Applications Featured

www.tadjava.com

Beating the Java Drum
Table ADministrative Tool (TAD)

Early 2010 $38.97 Deal!

Buy 4 Java Applications for the price of 3.
Get one FREE!
* This $12.99 savings ends March 2010.

Innovations Inc.

Working New Technologies

TAD's Home

Download / Support / Help

Deploying TAD

Deployment of Table Administrative Tool (TAD) to Apache Tomcat

Back to TAD's Support/Help page

1. Tomcat

Apache Tomcat is a servlet container and server implementing Java Servlet and JavaServer Pages technologies. Download ApacheTomcat.

2. Prerequisite for Database (ASCII and MySQL)

ASCII
	No prerequisite is required, the database is created automatically at the ..\WEB-INF\TAD\data directory.

MySQL
	MySQL uses a property file containing all MySQL database CRUD SQL operations the:
		WEB-INF\TAD\sql\sql_<table>.sql
	It contains reference to the connection file:
		<dbsqls> <configname>cardinfo</configname> <connector>mysql_connection.xml</connector> ......
	mysql_connection.xml connects to the shema tadschema with user: tad and password: tad
		<dbconnection> <connections> <connection name="tadconnect"> <url>jdbc:mysql://localhost:3306/tadschema</url> <driver>com.mysql.jdbc.Driver</driver> <username>tad</username> <password>tad</password> </connection> </connections> </dbconnection>

	Creating the MySQL tadschema:
	1. Access MySQL as root administrator
	2. Run this SQL sequence:
		create schema tadschema;
		grant all on tadschema.* to tad@'localhost' identified by 'tad';

	Once this is done, the MySQL version of TAD.war will connect and automatically create the tad schema.

3. Deploying TAD.war to Tomcat (The downloaded TAD_table_01.war is abbreviate to TAD.war in this documentation)

I have deployed TAD to Tomcat versions 4.1 to 5.5. Java WAR files provide an automatic deployment of the TAD applications to the TomCat server. The deployment process begins by placing TAD.war to the Tomcat \webapp directory.

Back to TAD's Support/Help page

4. Verifying Deployment

After that step, start the TomCat server. Tomcat's startup.bat should be executed, or however you start Tomcat.

ASCII

	A message should appear indicating where the ASCII database is been written to:
	================[ Default Database Files Directory ]========================= Data is being read and saved from: G:\apache-tomcat-5.5.12\webapps\tad\data\ =====================================================================

MySQL

	A message should appear indicating where the MySQL database is been created:
	================[ Starting TAD Application ]==================== TAD Application started on Sat Aug 01 22:00:08 EDT 2009 XMLDML files are being read from: G:\apache-tomcat-5.5.12\webapps\tad\ ================[ XMLDML File Used ]==================== G:\apache-tomcat-5.5.12\webapps\tad\WEB-INF\sql\sql_cardinfo.xml XMLDMLS-> Reading XML file: G:\apache-tomcat-5.5.12\webapps\tad\WEB-INF\sql\sql_cardinfo.xml Creating CardInfo Table: createCardInfo Successfully executed statement XMLDML: command 1 of CreateCardInfo - CREATE TABLE CardInf.....

The TAD J2EE Application is now up and running!

5. Accessing TAD from the Browser

Open the browser with a URL as such: http://localhost:8080/tad/

6. The J2EE Application

The table Administrative (TAD) Tool application should appear at this point.

7. Done

That's it, have fun using the J2EE Application: TAD - Table Administrative Tool

The Database table Administrative Tool (TAD) was created as an Educational and Demonstration to Learn and further Push Java, Struts Framework and the Display Tag Library. TAD is a an implementation of these technologies.

Back to TAD's Support/Help page

iki Innovations Inc. All rights reserved.
Java, J2EE are trademarks of Sun Micro Systems. Struts, Tiles, Apache are trademarks of Apache Software Foundation. Display Tag Library is a trademark of SourceForge.net. MySQl is trademark of MySQL AB/Oracle Corporation