ununpentium

removed post

I am using an evaluation copy of FusionCharts v3.2. I deployed the J2EE war in Tomcat 6.0.32. I am running JDK 1.6 and MySQL 5.1.55. I have not altered the sample files/code in anyway, other than the context file per the tutorial. I am simply running through the J2EE samples html file that demonstrates the various charts (http://50.56.71.157:6080/FusionCharts_J2EE/JSP/index.html). All of the sample charts are rendering fine. The database samples using a single dataset are also rendering fine. The problem is running the MSDBExample.jsp When I launch the page from the tutorial link (http://50.56.71.157:6080/FusionCharts_J2EE/JSP/DBExample/MSDBExample.jsp), I get the following error: "Error in loading data." Viewing the catalina.out log, when the MSDBExample.jsp file is accessed the log displays: "Could not close the statement" Being that I am new to FusionCharts, I do not know how to fix the tutorial file(s) to make this example work. I have searched the forum and have not yet found an answer. Thank you for any help.

Tomcat 6.0.32 As for JSTL, I assumed it just used the jars already present in the tutorial J2EE app's /WEB-INF/lib folder: jstl-api-1.2 jstl-imp-1.2 Thanks.

The hardcoded XML works, so it has something to do with the JSP multi-string file/bean retrieving data from the database. It seems to be isolated to the JSP tutorial. As a test, I loaded the PHP tutorial and its multi-string file reads the database just fine (at this URL): http://50.56.69.110/PHP/DBExample/MSChart.php At this point, I need to figure out the JSP multi-string problem. Our business needs to use the JSP solution. As we are a paid client, how might I move away from the forum and invoke professional tech support? Thank you.

Here it is attached. Thank you. FusionCharts_J2EE.zip

Ok, I've replaced the jars with the ones in your attached sample and I cleared the cached class and jar files. The problem still exists. Furthermore, since my last post, I have purchased a Pro/SaaS version of FusionCharts. I have also created a brand new server, new MySQL install, etc., and loaded the purchased files. I went through the Database tutorial again, and the same problem exists in the pro tutorial: that is, the database examples work, but the Multi-series db example does not - it just displays "Error in loading data". I ran debug, and the same trace appears with the same error: "WARNING: Could not find dataXML or dataURL parameter. Setting dataURL to default data file Data.xml." So, if I read this error correctly, not only is the dataURL parameter apparently missing in the MSDBExample.jsp file (or related bean), but a Data.xml file is also missing from the DBExample folder in the tutorial, which can't be defaulted to. What is the next support step? Thank you.

I followed this line of instruction when creating the databases: "Run the scripts FactoryDBCreation.sql and UTFExampleTablesCreation.sql to create the required tables and sample data." After loading both sql scripts, the following database was created: factorydb It has the following tables (and record count): Factory_Master (3) Factory_Output (60) Japanese_Factory_Master (3) I have done this step twice, and both times the same tables and rows were created. Will you please let me know if these tables are correct, or if there is something missing?

One more thing... Tomcat is displaying the following error: The requested resource (/FusionCharts_J2EE/JSP/DBExample/Data.xml) is not available. It looks like the multi-series chart is trying to look for a Data.xml file, and not use the database connection.

I deployed the new WAR you attached. I didn't touch/alter any files. Same exact problem exists.The output for debugging is also the same. The other database samples for single datasets work. For some reason, the problem resides only in the sample multi-series chart/file. Additionally, your WAR is missing the fchelperfunctions.tld file in the META-INF folder. I had to manually add it in order for some other sample charts to work. Thank you for helping me with this.

Here is the debug output: Info: Chart loaded and initialized. Initial Width: 700 Initial Height: 400 Scale Mode: noScale Debug Mode: Yes Application Message Language: EN Version: 3.2.1 Chart Type: Multi Series 2D Line Chart Chart Objects: BACKGROUND CANVAS CAPTION SUBCAPTION YAXISNAME XAXISNAME DIVLINES VDIVLINES YAXISVALUES HGRID VGRID DATALABELS DATAVALUES TRENDLINES TRENDVALUES DATAPLOT ANCHORS TOOLTIP VLINES LEGEND VLINELABELS INFO: Chart registered with external script. DOM Id of chart is FactorySum WARNING: Could not find dataXML or dataURL parameter. Setting dataURL to default data file Data.xml. dataURL provided: Data.xml dataURL invoked: Data.xml?FCTime=500 ERROR: An error occurred while loading data. Please check your dataURL, by clicking on the "dataURL invoked" link above, to see if it's returing valid XML data. Common causes for error are: No URL Encoding provided for querystrings in dataURL. If your dataURL contains querystrings as parameters, you'll need to URL Encode the same. e.g., Data.asp?id=101&subId=242 should be Data%2Easp%3Fid%3D101%26subId%3D242 Different sub-domain of chart .swf and dataURL. Both need to be same owing to sandbox security. Network error