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
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…
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)