Spring Tips: Multitenant JDBC

March 23, 2022

Hi, Spring fans! In this installment we look at how to use Spring’s AbstractRoutingDataSource to build multi-tenant JDBC database code.

code: https://github.com/spring-tips/multitenant-jdbc
speaker: Josh Long (@starbuxman)

</iframe</p> </div> </section> <section id="disqus_thread"></section> <script type="text/javascript"> var disqus_shortname = "spring-io"; var disqus_identifier = 4740; (function(disqus_shortname, document) { injectScript('//' + disqus_shortname + '.disqus.com/embed.js'); injectScript('//' + disqus_shortname + '.disqus.com/count.js'); function injectScript(url) { var s = document.createElement('script'); s.async = true; s.src = url; (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(s); } }(disqus_shortname, document)); </script> <noscript>Please enable JavaScript to view the <a href="http://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript> <a href="http://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a> </div></article> </div> <aside id="sidebar" class="span4 mobile-right-pane"> <div><div> <div> <div id="blog-sidebar-newsletter"> <p>Get the Spring newsletter</p> <script src="//connect.pivotal.io/js/forms2/js/forms2.min.js"></script> <form id="mktoForm_4723"></form> <script> MktoForms2.setOptions({formXDPath : "/rs/pivotal/images/marketo-xdframe-relative.html"}); MktoForms2.loadForm("//connect.pivotal.io", "625-IUJ-009", 4723, function(form){ form.onSuccess(function(values, followUpUrl) { form.getFormElem().html("<p>Thank you!</p>"); return false; }); }); </script> </div> </div> </div></div> </aside> </div> </div> </main> </div> </div> <footer> <div id='top'> <div class='container flex jc-between mx-auto'> <div id='green-circle-sm'></div>  <img id='circle-grid' src="/images/footer-circles-dc4b03d4edc1f3b7b42a45bdcce411c8.svg" alt=""> <div class='third'> <h2 class='bold h3 antialiased'>Get ahead</h2> <p>VMware offers training and certification to turbo-charge your progress.</p> <a href='/training' class='blue link-animate'>Learn more</a> </div> <div class='third'> <h2 class='bold h3 antialiased'>Get support</h2> <p>Spring Runtime offers support and binaries for OpenJDK™, Spring, and Apache Tomcat® in one simple subscription.</p> <a href='/support' class='blue link-animate'>Learn more</a> </div> <div class='third'> <h2 class='bold h3 antialiased'>Upcoming events</h2> <div class='footer-event'> <p>Check out all the upcoming events in the Spring community.</p> <a href='/events' class='blue link-animate'>View all</a> </div> </div> </div> </div> <div id='bottom'> <div id='bottom-top'> <div id='footer-over' class='mx-auto'> <div class='container flex jc-between mx-auto'> <div class='left'> <div class='flex jc-between'> <div class='footer-column'> <p><strong><a href='/why-spring'>Why Spring</a></strong></p> <ul> <li><a href='/microservices'>Microservices</a></li> <li><a href='/reactive'>Reactive</a></li> <li><a href='/event-driven'>Event Driven</a></li> <li><a href='/cloud'>Cloud</a></li> <li><a href='/web-applications'>Web Applications</a></li> <li><a href='/serverless'>Serverless</a></li> <li><a href='/batch'>Batch</a></li> </ul> </div> <div class='footer-column'> <p><strong><a href='/learn'>Learn</a></strong></p> <ul> <li><a href='/quickstart'>Quickstart</a></li> <li><a href='/guides'>Guides</a></li> <li><a href='/blog'>Blog</a></li> </ul> </div> <div class='footer-column'> <p><strong><a href='/community'>Community</a></strong></p> <ul> <li><a href='/events'>Events</a></li> <li><a href='/team'>Team</a></li> </ul> </div> <div class='footer-column'> <p><strong><a href='/projects'>Projects</a></strong></p> <p><strong><a href='/training'>Training</a></strong></p> <p><strong><a href='/support'>Support</a></strong></p> <p><strong><a href='/thank-you'>Thank You</a></strong></p> </div> </div> </div> </div> </div> </div> <div id='bottom-bottom'> <div class='flex container jc-between'> <div id="spring-links"> <img id='springlogo-foot' src="/images/spring-logo-9146a4d3298760c2e7e49595184e1975.svg" alt="Spring"> <p class='smallest antialiased'>© <script>var d = new Date(); document.write(d.getFullYear());</script> <a href='https://www.vmware.com/'>VMware</a>, Inc. or its affiliates. <a href='https://www.vmware.com/help/legal.html'>Terms of Use</a> • <a href='https://www.vmware.com/help/privacy.html' rel="noopener noreferrer">Privacy</a> • <a href='/trademarks'>Trademark Guidelines</a> <span id='thank-you-mobile'>• <a href='/thank-you'>Thank you</a></span> • <a href="https://www.vmware.com/help/privacy/california-privacy-rights.html">Your California Privacy Rights</a> • <a class="ot-sdk-show-settings">Cookie Settings</a> <span id='teconsent'></span></p> <p class='smallest antialiased'>Apache®, Apache Tomcat®, Apache Kafka®, Apache Cassandra™, and Apache Geode™ are trademarks or registered trademarks of the Apache Software Foundation in the United States and/or other countries. Java™, Java™ SE, Java™ EE, and OpenJDK™ are trademarks of Oracle and/or its affiliates. Kubernetes® is a registered trademark of the Linux Foundation in the United States and other countries. Linux® is the registered trademark of Linus Torvalds in the United States and other countries. Windows® and Microsoft® Azure are registered trademarks of Microsoft Corporation. “AWS” and “Amazon Web Services” are trademarks or registered trademarks of Amazon.com Inc. or its affiliates. All other trademarks and copyrights are property of their respective owners and are only mentioned for informative purposes. Other names may be trademarks of their respective owners.</p> </div> <div id='social-icons' class='flex jc-between'> <a href='https://www.youtube.com/user/SpringSourceDev' title="Youtube"><svg id='youtube-icon' xmlns="http://www.w3.org/2000/svg" viewBox="0 0 40 40"><circle class="cls-1" cx="20" cy="20" r="20"/><path class="cls-2" d="M30.91,14.53a2.89,2.89,0,0,0-2-2C27.12,12,20,12,20,12s-7.12,0-8.9.47a2.9,2.9,0,0,0-2,2A30.56,30.56,0,0,0,8.63,20a30.44,30.44,0,0,0,.46,5.47,2.89,2.89,0,0,0,2,2C12.9,28,20,28,20,28s7.12,0,8.9-.47a2.87,2.87,0,0,0,2-2A30.56,30.56,0,0,0,31.37,20,28.88,28.88,0,0,0,30.91,14.53ZM17.73,23.41V16.59L23.65,20Z"/></svg></a> <a href='https://github.com/spring-projects' title="Github"><svg id='github-icon' xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75.93 75.93"><path class="cls-1" d="M38,0a38,38,0,1,0,38,38A38,38,0,0,0,38,0Z"/></g><path class="cls-2" d="M38,15.59A22.95,22.95,0,0,0,30.71,60.3c1.15.21,1.57-.5,1.57-1.11s0-2,0-3.9c-6.38,1.39-7.73-3.07-7.73-3.07A6.09,6.09,0,0,0,22,48.86c-2.09-1.42.15-1.39.15-1.39a4.81,4.81,0,0,1,3.52,2.36c2,3.5,5.37,2.49,6.67,1.91a4.87,4.87,0,0,1,1.46-3.07c-5.09-.58-10.45-2.55-10.45-11.34a8.84,8.84,0,0,1,2.36-6.15,8.29,8.29,0,0,1,.23-6.07s1.92-.62,6.3,2.35a21.82,21.82,0,0,1,11.49,0c4.38-3,6.3-2.35,6.3-2.35a8.29,8.29,0,0,1,.23,6.07,8.84,8.84,0,0,1,2.36,6.15c0,8.81-5.37,10.75-10.48,11.32a5.46,5.46,0,0,1,1.56,4.25c0,3.07,0,5.54,0,6.29s.42,1.33,1.58,1.1A22.94,22.94,0,0,0,38,15.59Z"/></svg></a> <a href='https://twitter.com/springcentral' title="Twitter"><svg id='twitter-icon' xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75.93 75.93"><circle class="cls-1" cx="37.97" cy="37.97" r="37.97"/><path id="Twitter-2" data-name="Twitter" class="cls-2" d="M55.2,22.73a15.43,15.43,0,0,1-4.88,1.91,7.56,7.56,0,0,0-5.61-2.49A7.78,7.78,0,0,0,37,30a7.56,7.56,0,0,0,.2,1.79,21.63,21.63,0,0,1-15.84-8.23,8,8,0,0,0,2.37,10.52,7.66,7.66,0,0,1-3.48-1v.09A7.84,7.84,0,0,0,26.45,41a7.54,7.54,0,0,1-2,.28A7.64,7.64,0,0,1,23,41.09a7.71,7.71,0,0,0,7.18,5.47,15.21,15.21,0,0,1-9.55,3.37,15.78,15.78,0,0,1-1.83-.11,21.41,21.41,0,0,0,11.78,3.54c14.13,0,21.86-12,21.86-22.42,0-.34,0-.68,0-1a15.67,15.67,0,0,0,3.83-4.08,14.9,14.9,0,0,1-4.41,1.24A7.8,7.8,0,0,0,55.2,22.73Z"/></svg></a> </div> </div> </div> </div> </footer> <script src="/js/main-27bf4c90452b08bee4c042a3664fc48e.js"></script> </body> </html> <script defer src="https://static.cloudflareinsights.com/beacon.min.js/v652eace1692a40cfa3763df669d7439c1639079717194" integrity="sha512-Gi7xpJR8tSkrpF7aordPZQlW2DLtzUlZcumS8dMQjwDHEnw9I7ZLyiOj/6tZStRBGtGgN6ceN6cMH8z7etPGlw==" data-cf-beacon='{"rayId":"72549b0ee80a58d2","token":"bffcb8a918ae4755926f76178bfbd26b","version":"2022.6.0","si":100}' crossorigin="anonymous"></script>

Spring Blog

Spring Tips: Multitenant JDBC