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?