RE: fcgeneral.war

Pallav — Fri, 11 Jan 2008 08:30:55 GMT

Hi,

Please use the following instructions from modified Readme.txt to use JSP blueprint:

=========================================
This demo application shows the capabilities of FusionCharts by integrating
it with JSP and MySQL/Access/SQL. The databases are contained in FusionChartsDB folder.
You'll find the Access MDB file and the SQL Database generation script.

PLEASE NOTE THAT THIS DEMO APPLICATION JUST USES A HANDFUL OF CHARTS
FROM FUSIONCHARTS SUITE FOR DEMO PURPOSE. FUSIONCHARTS OFFERS A LOT
MORE VARIETY OF CHARTS, WHICH IS PRESENT IN EVALUATION DOWNLOAD.

Troubleshooting
==================================================================
If for some reason, you do not see the charts, make sure you've
Adobe Flash Player 8 (or above) installed on your machine.

Support Information
==================================================================
Website: http://www.InfoSoftGlobal.com/FusionCharts
Email: support@infosoftglobal.com

Additional Information
==================================================================
This version works with the Access mdb database which is bundled with the web
application or with MySQL whose database-creation scripts are provided along
with the web application. We have used JSP 2.0 and j2sdk1.4.2_02 for the development
of this demo.

Prerequisites:
1. Java version - j2sdk1.4.2_02 or higher

2. Apache Tomcat version - jakarta-tomcat-5.0.28 or higher

3. MySQL 4.X or higher OR MS Access database

Installation Instructions:
1. Java version - j2sdk1.4.2_02 which can be downloaded from the following link:
http://java.sun.com/j2se/1.4.2/download.html

2. After downloading and installing java,JAVA_HOME environment variable has to be set to determine the base path of the JDK.
To set this variable on Windows do the following:
Go to MyComputer, right click to view properties -> advanced tab ->environment variables
Set a new Variable name: JAVA_HOME with Value as the installation directory. For eg:
C:\j2sdk1.4.2_02

3. Apache Tomcat version - jakarta-tomcat-5.0.28 which can be downloaded from the following link:
http://tomcat.apache.org/download-55.cgi

Click on the core zip file. Download it.Extract it to some folder.

4.After downloading and installing tomcat,CATALINA_HOME environment variable has to be set to determine the base path of the tomcat.
To set this variable on Windows do the following:
Go to MyComputer, right click to view properties -> advanced tab ->environment variables
Set a new Variable name: CATALINA_HOME with Value as the installation directory. For eg:
C:\jakarta-tomcat-5.0.25

5. Copy the code to required place. Copy the App folder present in (FusionCharts_JSP) to the webapps folder of
your tomcat and rename it as fcblueprint. We have given that name to the web application. If you are giving a different
name, then you will have to make appropriate changes in the following steps also.

6. Creation of the database required by FusionCharts:
If you are using MSAccess, then copy the FusionChartsDB.mdb present in the FusionChartsDB/MSAccess folder to some location on your hard-drive.
If you are using MySQL, then run the FusionChartsDBCreation.sql (present in the FusionChartsDB/MySQL) in your MySQL.
This creates the FusionChartsDB database on your machine.

7. In order to configure the MySQL database:
Open the file "CATALINA_HOME"/conf/server.xml
Add the following xml code just before
debug="5" reloadable="true" crossContext="true">

prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/>

auth="Container"
type="javax.sql.DataSource"/>

factory
org.apache.commons.dbcp.BasicDataSourceFactory

maxActive
100

maxIdle
30

maxWait
10000

username
fcuser

password
fcuser

driverClassName
com.mysql.jdbc.Driver

url
jdbc:mysql://localhost:3306/fusionchartsdb?autoReconnect=true

In the above xml,please change the username,password,url according to your database.Optionally, you can change the resource name,resourceparams name which are used to lookup for this database.WHatever values are given here same values should be given in the web.xml of your webapp.

8. Changes to web.xml present in "CATALINA_HOME"/webapps/fcblueprint/WEB-INF/ folder:
In order to change the database from mysql to access or vice-versa, change the following entry in web.xml.

dbName

MySQL

Database Name

Currently, you can set the param-value to MySQL or MSAccess.(case-sensitive)
In the case of Access DB, you have to set the path to the database in the following parameter in web.xml.

AccessDBPath

C:/tomcat/webapps/fcblueprint/BluePrintApp/FusionChartsDB/FusionChartsDB.mdb

Absolute path to the Access DB

In the case of MySQL DB,you have to set the Data Source Name in the following parameter in the web.xml

dataSourceName

jdbc/FusionChartsDB

DataSource Name

9.If you are using MySQL as the database, please start your MySQL instance.
10.To start the tomcat server,go to the tomcat installation directory ("CATALINA_HOME") and run startup.bat

11.Access the FusionCharts website by opening the browser window with the following address:
http://localhost:8080/fcblueprint/BluePrintApp/Default.jsp

Note: "CATALINA_HOME" refers to the installation directory of Tomcat

fcgeneral.war

anners — Tue, 08 Jan 2008 17:38:44 GMT

Hi -

In the readme.txt file for FusionCharts_Evaluation/Code/JSP it says to install the fcgeneral.war file in your Tomcat webapp dir, but I cannot find the fcgeneral.war file. Can you let me know where I can get this?

thanks.
ann

FusionCharts Forum / FusionCharts Free / FusionCharts Free and JSP / fcgeneral.war / Latest Posts

RE: fcgeneral.war

fcgeneral.war