[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 - ODBCProblem 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. 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. | |
|