Knowledgebase
[QODBC-Desktop] Troubleshooting - QuickBooks Dashboards, Java, JDBC - ODBC
Posted by Jack - QODBC Support on 10 November 2016 06:38 AM

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.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).