jeudi 26 mars 2015

Spring Integration - JDBC channel adaptar without query result

I have a problem when my query return null or cero result inside resultset.


I have a int-jdbc:inbound-channel-adapter with a rowMapper



<int-jdbc:inbound-channel-adapter query="SELECT * FROM ENGINE_LOGS WHERE COUNTRY_ID = 2 AND BUSINESS_ID = 100 and rownum &lt; 10"
channel="oracle.db.resultSet.engineLogs"
update=""
row-mapper="engineLogsRowMapper"
data-source="jdbcTemplate">
<!-- Cron Time -->
<int:poller fixed-rate="5" time-unit="SECONDS"></int:poller>
</int-jdbc:inbound-channel-adapter>`


When the query return null o cero (0) result, the row mapper class or the transformer (with input-channel: oracle.db.resultSet.engineLogs) never call.


I need execute an update in a auxiliary database if the query not find records in database, is it possible add a router or something to fix my problem?


Regards


Aucun commentaire:

Enregistrer un commentaire