Note: The JDBC-ODBC bridge driver was removed in Java 8, preventing ODBC drivers from being usable in newer versions of Java or other Java-based applications.

Refer: Oracle JDBC-ODBC Bridge

Troubleshooting - QuickBooks Dashboards, Java, JDBC - ODBC

Problem Description:

I am evaluating the QODBC driver for a client who wants to create a dashboard using QuickBooks data. I am trying to use the JDBC ODBC bridge.

As you see, the dashboard has multiple charts and queries with drills. I can add queries one by one, and they work fine, but when I do a dashboard refresh, only the first portlet to fire returns the rows, whereas the remaining portlets either return an error or do not return any row.

Also, is there a time-out in the QuickBooks connection? I noticed that if I let the connection remain idle, i.e., I switch to some application and return after, say, 10-15 minutes to the dashboard, and then try to refresh a query, the application crashes with Java HOTSPOT error.

Any idea how to resolve the above situation? 

Solution:

There's no actual QODBC connection time-out. I often have QuickBooks and a QODBC connection running for days. However, browser-based and threaded interfaces will have their time-outs. These time-outs require you to add QODBC disconnect and reconnect routines within your code or script. You will also need to use an STA (single-threaded-apartment) threading model, which your COM components may rely upon when returning calls.