db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Huber (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-158) verification of changed row number fails during data import
Date Wed, 28 Feb 2007 14:30:06 GMT
verification of changed row number fails during data import

                 Key: DDLUTILS-158
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-158
             Project: DdlUtils
          Issue Type: Bug
          Components: Core (No specific database)
         Environment: Windows, SapDB
            Reporter: Stefan Huber
         Assigned To: Thomas Dudziak
            Priority: Minor

I tried to import a database dump (exported with ddlutils) back to the same database system
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.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message