Spring Integration: Jdbc-inbound-adapter is it transactional when using adice-chain -


i have below configuration jdbc-inbound-adapter:

    <si-jdbc:inbound-channel-adapter id="jdbcinboundadapter"     channel="queuechannel" data-source="mydatasource"     auto-startup="true"     query="select * stage_table status='waiting'  update skip locked"     update="update stage_table set status='in_progress' id in (:id)"     max-rows-per-poll="100" row-mapper="rowmapper"     update-per-row="true">      <si:poller fixed-rate="5000">         <si:advice-chain>              <ref bean="txadvice"/>              <ref bean="inboundadapterconfiguration"/>          </si:advice-chain>     </si:poller> </si-jdbc:inbound-channel-adapter>     <tx:advice id="txadvice">         <tx:attributes>             <tx:method name="get*" read-only="false"/>             <tx:method name="*"/>         </tx:attributes>     </tx:advice>

my question both select , update statements executed in same transaction.

in spring-integration documentation not specify transaction when advice-chain used. (i using spring-integration-jdbc-2.2.0.rc2.jar) please see section 18.1.1 poller transaction support: http://docs.spring.io/spring-integration/docs/2.0.0.rc1/reference/html/transactions.html

you using old version (and release candidate @ that, not ga release. current version 3.0.2.release latest 2.2.x 2.2.6.release. please upgrade 1 of those.

http://projects.spring.io/spring-integration/

yes, it's done in same transaction.

are referring old documentation too? current documentation says

"a important feature of poller jdbc usage option wrap poll operation in transaction,..".

the transaction started, message source invoked (to results) , downstream flow occurs in transaction (unless hand off thread, in case transaction commit @ time).

in fact, update done right after select (and before message sent), commit doesn't occur until downstream flow complete.

your channel called queuechannel; if queue channel, means transaction commit message stored in queue.

if feel documentation improvements required, please open jira issue.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more