🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Write database - Add generated primary keys

User: "miguelal"
New Altair Community Member
Updated by Jocelyn
Hi,

Since I upgraded to the latest release of RapidMiner (5.3.005) I seem to keep on getting the error below every time I try to use the option "add generated primary keys" of the Write Database operator. We are connecting to SQL Server 2008 R2, and using the JTDS driver.

Feb 13, 2013 9:20:30 PM SEVERE: Process failed: Database error occurred: A statement attempted to return a result set in executeBatch().

But as soon as we go back to the previous RapidMiner version (5.2), or I disable the "add generated primary keys" option, this problem goes away. This is the XML for the operator:

              <operator activated="true" class="write_database" compatibility="5.3.005" expanded="true" height="60" name="Write Database" width="90" x="45" y="210">
                <parameter key="connection" value="GOGLDB"/>
                <parameter key="table_name" value="BATCH"/>
                <parameter key="overwrite_mode" value="append"/>
                <parameter key="add_generated_primary_keys" value="true"/>
                <parameter key="db_key_attribute_name" value="BATCH_ID"/>
              </operator>
Has anybody come across this issue?

Thanks,
Miguel

Find more posts tagged with