I am testing the limits of QuickBooks, QODBC, & ColdFusion, so I am doing some bulk imports to see what (if anything) breaks or has poor performance.

In this particular case, I am trying to add 100000 customers to the database

<cfloop index=”i” from=”1″ to=”100000″>
<cfquery datasource=”qbs” name=”ds” >
INSERT INTO Customer ( Name)
VALUES (’#CreateUUID()#’)
</cfquery>
</cfloop>

When running the script, it blows out after inserting around 2000 records with the following error

[Macromedia][SequeLink JDBC Driver][ODBC Socket][QODBC] Error parsing complete XML return string.

If I try to run the script again, I get the error message again for the first record.

I have no know cause for the issues, but I have a quick fix. This is a ghetto hack, but It is working for me.

If you restart the windows service “ColdFusion 8 ODBC Server” everything is happy again. At least for 2000 more rows. ;)

Restarting the service obviously won’t do  in a production environment, but it will have to do for now.

This entry was posted on Thursday, July 19th, 2007 at 6:58 am and is filed under ColdFusion, QODBC, QuickBooks. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.