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)
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.