DdlUtils
  1. DdlUtils
  2. DDLUTILS-158

verification of changed row number fails during data import

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0 RC1
    • Labels:
      None
    • Environment:
      Windows, SapDB 7.4.3.27

      Description

      I tried to import a database dump (exported with ddlutils) back to the same database system (SapDB).
      In this process i got a lot of warnings like

      28.02.2007 14:07:54 org.apache.ddlutils.platform.PlatformImplBase executeBatch
      WARNUNG: Attempted to insert 2 rows into table MYTABLE but changed -4 rows

      Looking at the source code (PlatformImplBase.executeBatch) i found out that SapDB returns 'Statement.SUCCESS_NO_INFO' as result of 'statement.executeBatch'.
      Since SUCCESS_NO_INFO is defined as integer value -2 the method adds -2 for every successfull statement. So having two insert statements results in -4 which is definitely not 2 and the warning arises.

      I got the same effect with Oracle 8 so i didn't try other databases and assume that this is a general problem.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Stefan Huber
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development