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: 860 $ $Date: 2008-11-02 20:43:23 +0100 (Sun, 02 Nov 2008) $

Author:

Manuel Laflamme, Eric Pugh, Last changed by: $Author: gommma $

Field Summary

Fields

Modifier and Type	Field and Description
static DatabaseOperation	CLEAN_INSERT
static DatabaseOperation	INSERT
static String	PROPERTY_IDENTITY_COLUMN_FILTER
static DatabaseOperation	REFRESH

Fields inherited from class org.dbunit.operation.DatabaseOperation

DELETE, DELETE_ALL, NONE, TRUNCATE_TABLE, UPDATE

Constructor Summary

Constructors

Constructor and Description
InsertIdentityOperation(DatabaseOperation operation) Creates a new InsertIdentityOperation object that decorates the specified operation.

Method Summary

Methods

Modifier and Type	Method and Description
void	execute(IDatabaseConnection connection, IDataSet dataSet) Executes this operation on the specified database using the specified dataset contents.

Methods inherited from class org.dbunit.operation.AbstractOperation

getQualifiedName

Methods inherited from class org.dbunit.operation.DatabaseOperation

CLOSE_CONNECTION, TRANSACTION

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

PROPERTY_IDENTITY_COLUMN_FILTER

public static final String PROPERTY_IDENTITY_COLUMN_FILTER

See Also:

Constant Field Values

INSERT

public static final DatabaseOperation INSERT

CLEAN_INSERT

public static final DatabaseOperation CLEAN_INSERT

REFRESH

public static final DatabaseOperation REFRESH

Constructor Detail

InsertIdentityOperation

public InsertIdentityOperation(DatabaseOperation operation)

Creates a new InsertIdentityOperation object that decorates the specified operation.

Method Detail

execute

public void execute(IDatabaseConnection connection,
           IDataSet dataSet)
             throws DatabaseUnitException,
                    SQLException

Description copied from class: DatabaseOperation

Executes this operation on the specified database using the specified dataset contents.

Specified by:

execute in class DatabaseOperation

Parameters:

connection - the database connection.

dataSet - the dataset to be used by this operation.

Throws:

DatabaseUnitException

SQLException