mercredi 18 mars 2015

Error instruction select sql Spring

i have this sqlDynamic instruction:



select code from service,service_has_rule where service.id=service_has_rule.service_id and service_has_rule.rule_id in
(3,4) ORDER BY priority DESC


if i try with this code, all work:



strLst = jdbcTemplateObject.queryForList(sqlDynamic, String.class);
return strLst;


But if i try with:



DefaultTransactionDefinition defaultTransactionDefinition = new DefaultTransactionDefinition();

TransactionStatus status = transactionManager
.getTransaction(defaultTransactionDefinition);

try {
strLst = jdbcTemplateObject.queryForList(sqlDynamic, String.class);
transactionManager.commit(status);

} catch (DataAccessException e) {
logger.info(TAG_LOG + " "
+ "Error in creating record, rolling back");
transactionManager.rollback(status);
throw e;
}
return strLst;


not work..but i'm not understad why...


Aucun commentaire:

Enregistrer un commentaire