Hi -

I am trying to develop a Java(1.5) application hosted on a Tomcat5.5 server that allows users to insert invoices to quickbooks using qodbc read/write edition.

I have my setup with Quickbooks 2007 Professional on the same machine as tomcat and qodbc, and a remote connector setup which is needed by the jdbc/odbc bridge.

The connector is setup to accept connections without asking for a password.

I have been running accross many problems with the jdbc/odbc connection crashing intermittantly.

All works fine inserting invoices and then the qodbc connection crashes.

The error I get alot is as follows:

"Error getting QODBC Connection([QODBC] Installation incomplete on required module XERCES-COM.DLL)"

I have read the posts on this site describing this error and reinstalling qodbc, or using the latest Java / Tomcat and I have done these.

I have also installed on 2 machines - with the same results.

Finally I have setup the code to run as a Java CLI program and i get the same result of the connection crashing.(Though the error is slightly different - also pointing at Xerces-com.dll)

Has anyone any suggestions or have you found a solution to this problem?

Here are some questions:

- Will upgrading to the web server edition fix this problem?  If so I can do this as needed.
- Is there some other way of fixing this problem so that i can run Tomcat using odbc to call the qodbc connection without failing?
- Has either the read/write version or the web server version been tested using Java, and/or Tomcat?
- Any other ideas?

Thanks in advance.

Unfortunately this problem only occurs with Apache Tomcat and not Internet Information Server (IIS), our suggestions are:

• As far as Web Servers and Apache using QODBC and QuickBooks, the consensus is that anything beyond two days is asking for trouble and we recommend rebooting or stopping Apache.exe and restarting it daily.
• Try keeping the connection open and run serveral queires within the connection instead of opening and closing the connection for each query.
• Try to reduce the number of queries being sent at the one time to prevent XERCES-COM.DLL from being overrun. Some developers have found that when they serialized requests (only one query at a time) they have increased stability.
• Examine if the problem presents itself when using certain SQL syntax. Some typing problems have been found in certain columns on some of the tables.