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 the moment I do a dashboard refresh, only the first portlet to fire returns the rows whereas remaining portlets either return an error or do not return any row.

Also, is there a time-out in the QuickBooks connection? What I noticed is 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 timeout, I often have QuickBooks and a QODBC connection running for days. However, browser-based and threaded interfaces will have their own timeouts. These timeouts will 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).