Roman Rokytskyy wrote:

>>The new setup processes the data about 10-15 time quicker than the
>>previous setup but once we get to just over 9000 records in a job we
>>get a GDS Exception 335544327. invalid request handle as an
>>FBSQLException. This happens every time at just after 9000 records,
>>the application has autocommit turned off, and is commiting at every
>>4000 records.
>>
>>
>
>Can you provide a test case for this problem? It sounds quite reproducable
>one.
>
>Roman
>
>
>

I updated the jaybird driver on our server and was still getting the
same errors, and sometimes the "error reading data from the connection"
exceptions - I then did a complete review of the code (something I
probably should have done first...) and found the reason, it was a
PreparedStatement that was being executed and not being closed, I just
added one line closing it and it all works like a dream, we now can
parse 45022 elements in just under 2 minutes, compared to ~35 minutes in
the old setup.

Keep up the great work.

Regards,

Ryan Thomas
TransActive Systems

>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]