DBA Tools

    After introduce of the WebChart features and the the WebChart framwork, somebody told me that they need to test WebChart, but don't know how to install it after download. After reading this article, you should know how to install it.

    First we need download and install Java SDK, it can be download at Sun JAVA page. JDK (Java Development Kit) is required, not just JRE (Java Runtime Enviroment), and the version must be 1.4 or higher. If you have Oracle 10g or above installed on you machine, you can copy the jdk directory under Oracle home, it's JDK 1.4 above. Please install it to the root directory.

c:\jdk
/jdk

    Add the follow environment variables.

JAVA_HOME=c:\jdk
JAVA_HOME=/jdk
JAVA_OPTS=-Djava.awt.headless=true

    Then download Tomcat, extract to root directory, and rename the tomcat home directory to the following name.

c:\TomcatWebChart
/TomcatWebChart

    Download WebChart and extract to following directory.

c:\TomcatWebChart\webapps
/TomcatWebChart/webapps

    Then copy the target databases' JDBC driver file to the following directory.

c:\TomcatWebChart\common\lib
/TomcatWebChart/common/lib

    Now we have complete the installation, before you start the tomcat server, you should edit the database configuration file with text editor.

c:\TomcatWebChart\webapps\webchart\WEB-INF\dbconn.cfg
/TomcatWebChart/webapps/webchart/WEB-INF/dbconn.cfg

    Here is an example of the configuration file, connect the a local Oracle database.

# WebChart Metadata Connection
ADMINDB=DEFAULT

# Database name list
DBLIST=DEFAULT

# Connection Paramters for each database name
DEFAULT.DBTYPE=oracle
DEFAULT.DBHOST=localhost:1521:db10g
DEFAULT.DBUSER=SCOTT
DEFAULT.DBPASS=TIGER
DEFAULT.MAXCONNS=8
DEFAULT.INITCONNS=2
DEFAULT.LOCALE=SIMPLIFIED_CHINESE

    Run the following command to start tomcat.

c:\TomcatWebChart\bin\startup.bat
/TomcatWebChart/bin/startup.bat

    Then open the browser, input the following URLs for demo pages.

http://localhost:8080/webchart/sample1.wcml
http://localhost:8080/webchart/sample2.wcml
http://localhost:8080/webchart/sample3.wcml

    You can try to modify the WCML files for more demos.