Package io.vertigo.basics.task.sqlserver

Class TaskEngineInsertWithGeneratedKeys

java.lang.Object

io.vertigo.datamodel.task.model.TaskEngine

io.vertigo.basics.task.AbstractTaskEngineSQL

io.vertigo.basics.task.sqlserver.TaskEngineInsertWithGeneratedKeys

public class TaskEngineInsertWithGeneratedKeys
extends AbstractTaskEngineSQL

Permet l'appel de requête insert en utilisant generatedKeys du PreparedStatement pour récupérer la valeur de la clé primaire. Une tache utilisant cet engine ne traite pas les DtList.

Author:

jmainaud, evernat

Field Summary

Fields inherited from class io.vertigo.basics.task.AbstractTaskEngineSQL

SQL_MAIN_RESOURCE_ID, SQL_ROWCOUNT

Constructor Summary

Constructors

Constructor	Description
TaskEngineInsertWithGeneratedKeys(io.vertigo.commons.script.ScriptManager scriptManager, io.vertigo.commons.transaction.VTransactionManager transactionManager, SqlManager sqlManager, SmartTypeManager smartTypeManager)	Constructor.

Method Summary

Modifier and Type	Method	Description
OptionalInt	doExecute(SqlStatement sqlStatement, SqlConnection connection)	Exécution de la requête.

Methods inherited from class io.vertigo.basics.task.AbstractTaskEngineSQL

execute, getConnectionProvider, getDataBaseManager, getModelManager, getSqlQuery, getVTransactionResourceId, preProcessQuery, setNamedParameters

Methods inherited from class io.vertigo.datamodel.task.model.TaskEngine

getContextProperties, getContextProperty, getTaskDefinition, getValue, process, setResult

Methods inherited from class java.lang.Object

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

Constructor Detail

TaskEngineInsertWithGeneratedKeys

@Inject
public TaskEngineInsertWithGeneratedKeys(io.vertigo.commons.script.ScriptManager scriptManager,
                                         io.vertigo.commons.transaction.VTransactionManager transactionManager,
                                         SqlManager sqlManager,
                                         SmartTypeManager smartTypeManager)

Constructor.

Parameters:

scriptManager - scriptManager

transactionManager - transactionManager

entityStoreManager - storeManager

sqlManager - sqlDataBaseManager

Method Detail

doExecute

public OptionalInt doExecute(SqlStatement sqlStatement,
                             SqlConnection connection)
                      throws SQLException

Exécution de la requête.

Specified by:

doExecute in class AbstractTaskEngineSQL

connection - Connexion BDD

Returns:

Nombre de lignes affectées (Insert/ Update / Delete)

Throws:

SQLException - Erreur sql