How to query a Cache database?

+1 vote
asked Nov 13, 2015 by rich-c-2789 (15,250 points)
I have a Cache database but doQuery fails with an error.

1 Answer

+2 votes

Use doSelectQuery() with Cach'e databases.

NOTE: The cach'e driver does not fully support the JDBC API.  Using doQuery fails since it calls the unsupported API statement.execute() (used by doQuery()) vs. statement.executeQuery() (used by doSelectQuery()).

This is the only significant difference.  Otherwise, setting up a Database Connection is the same as for other other JDBC connections.  You will need the JDBC driver for Cach'e.  

The following question covers the steps to create a Database Connection in QIE.  Subsitute the Cach'e driver as needed.

Does QIE support ODBC?

answered Nov 13, 2015 by rich-c-2789 (15,250 points)
commented Nov 13, 2015 by rich-c-2789 (15,250 points)
If there are any other limitations you can always work around around them using staight JDBC.  As was done in the question below until the doSelectQuery and doUpdateQuery functions were added to QIE.

If you do find an issue please let us know.