error message from the JDBC DB2 driver

[Ronald Yeung]

I am trying to load 140,000 rows from a MS Access table to a DB2/Linux table.
My application platform is Cold Fusion MX 7 on Windows XP. The MS Access table
that I am loading has a memo field, which I am loading to a CLOB field in the
DB2 table.

The maximum field size of any given CLOB field is 49K. I can insert 200 rows
into the DB2 table, but when I try to insert the 201st row, I get the following
error message from the JDBC DB2 driver:

Error Executing Database Query.
[Macromedia][DB2 JDBC Driver]No more available statements. Please recreate
your package with a larger dynamicSections value.


Please try the following:
Enable Robust Exception Information to provide greater detail about the source
of errors. In the Administrator, click Debugging & Logging > Debugging
Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.


I don?t know where to change the dynamicSections value. Has anyone
experienced this problem, or do you have any suggestions where this can be
changed in Cold Fusion Administrator? Thanks.

[jmich]

You could try to modify your connection in the CFIDE/administrator pages
choose your database, go to the advanced settings and modify the connection
strings.
A description of the different options is available here
[url]http://media.datadirect.com/download/docs/connectsqlxml/jdbcug/jdbcdb2.htm[/url]
For example
DynamicSections OPTIONAL
Specifies the number of statements that the DB2 driver package can prepare for
a single user. The default is 100.

Hope it helps