# Easy Chart Functionality Implementation

**URL:** <https://forum.inductiveautomation.com/t/easy-chart-functionality-implementation/7759>\
**Category:** Ignition\
**Created:** [December 24, 2013, 1:51pm UTC](https://forum.inductiveautomation.com/t/easy-chart-functionality-implementation/7759 "2013-12-24T13:51:14Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![ashish007pict](https://avatars.discourse-cdn.com/v4/letter/a/aca169/32.png) [@ashish007pict](https://forum.inductiveautomation.com/u/ashish007pict)\
**Post date:** [January 9, 2014, 9:49am UTC](https://forum.inductiveautomation.com/t/easy-chart-functionality-implementation/7759/21 "2014-01-09T09:49:09Z")

</div>

Hello Kyle Chess

[quote]  
Also for reference, this is why we use H2 instead of SQLite.[/quote]

Are you using H2 database on linux or windows? Could you provide me download link for installer for H2 database compatible to Fedora 14 OS?

I tried inserting manually in sqlth\_drv table as mentioned by anna. But still I cant get the historical tag on Easy Chart.

Thanks,  
Ashish

---

<div class="post-metadata">

**Author:** ![ashish007pict](https://avatars.discourse-cdn.com/v4/letter/a/aca169/32.png) [@ashish007pict](https://forum.inductiveautomation.com/u/ashish007pict)\
**Post date:** [January 9, 2014, 2:25pm UTC](https://forum.inductiveautomation.com/t/easy-chart-functionality-implementation/7759/22 "2014-01-09T14:25:11Z")

</div>

Hello Anna,

I created my separate database. I have attached screenshot of the same. I can get temperature values on Normal Chart COmponent by binding chart to sql query. I can get results if I dont add any WHERE  
clause in query. whenever I add where clause I get following error.

Exception: Error running query:  
SQLQuery(query=SELECT [ID],[10]  
FROM USER\_DATA0  
WHERE [00] = ‘’ and  
[03] = ‘’ , database=IIPLDataLog)@5000ms

On: Historical Report View.Root Container.Chart.Data  
caused by GatewayException: Unable to parse message.  
caused by org.xml.sax.SAXParseException; lineNumber: 3; columnNumber: 17; An invalid XML character (Unicode: 0x0) was found in the CDATA section.

Please Help…

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [April 18, 2014, 9:49pm UTC](https://forum.inductiveautomation.com/t/easy-chart-functionality-implementation/7759/23 "2014-04-18T21:49:30Z")

</div>

I need the rest of the error text (click on the “full” link at the bottom of the error box to get it).

Any particular reason you are using all-numeric table and column names?

You are using square brackets around column names - is that how your translator is set up? (You can check that on you database driver’s translator setting page, in the “Column Quote Character” field" - from the Gateway’s “Configure” page, go to Databases / Drivers section, select “Translators” tab, click “Edit” next to your driver entry)

[Previous page](https://forum.inductiveautomation.com/t/easy-chart-functionality-implementation/7759.md?page=1)