|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/9/2008 9:18:50 AM
Posts: 1,
Visits: 4
|
|
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 Team
Group: Administrators
Last Login: 10/3/2008 2:42:18 AM
Posts: 2,117,
Visits: 498
|
|
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
Thanks,
Pallav Nadhani
FusionCharts Team
|
|
|
|