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