Package org.dbunit.ext.mssql

Class InsertIdentityOperation

java.lang.Object
org.dbunit.operation.DatabaseOperation
org.dbunit.operation.AbstractOperation
org.dbunit.ext.mssql.InsertIdentityOperation
public class InsertIdentityOperation extends AbstractOperation
This class disable the MS SQL Server automatic identifier generation for the execution of inserts.

If you are using the Microsoft driver (i.e. com.microsoft.jdbc.sqlserver.SQLServerDriver), you'll need to use the SelectMethod=cursor parameter in the JDBC connection string. Your databaseUrl would look something like the following:

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb;SelectMethod=cursor

Thanks to Jeremy Stein who has submitted multiple patches.

Since:
1.4 (Apr 9, 2002)
Version:
$Revision$ $Date$
Author:
Manuel Laflamme, Eric Pugh, Last changed by: $Author$

  • Field Details

    • INSERT

      public static final DatabaseOperation INSERT

    • CLEAN_INSERT

      public static final DatabaseOperation CLEAN_INSERT

    • REFRESH

      public static final DatabaseOperation REFRESH

    • IDENTITY_FILTER_EXTENDED

      public static final IColumnFilter IDENTITY_FILTER_EXTENDED
      Accepts columns that have one of the remarks
      • GENERATED BY DEFAULT AS IDENTITY
      • GENERATED ALWAYS AS IDENTITY
      set which is the SQL standard syntax to describe auto-generated key columns. Also accepts columns that have the auto-increment property set to true (note that it does not yet have the ability to check whether the column is a primary key col).
      Since:
      2.4.3

  • Constructor Details

    • InsertIdentityOperation

      public InsertIdentityOperation(DatabaseOperation operation)
      Creates a new InsertIdentityOperation object that decorates the specified operation.

  • Method Details