{"id":24463,"date":"2021-04-10T23:10:04","date_gmt":"2021-04-11T03:10:04","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/java-spring-components-to-deal-with-database-sql-aspect-root\/"},"modified":"2022-05-10T20:12:13","modified_gmt":"2022-05-11T00:12:13","slug":"java-spring-components-to-deal-with-database-sql-aspect-root","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=24463","title":{"rendered":"Java Spring: Components to Deal with Database (SQL Aspect) #Root"},"content":{"rendered":"<p><strong>Java Spring: Components to Deal with Database (SQL Aspect)<\/strong><\/p>\n<div class=\"form-group col-sm-6\">\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> JPA: <\/label><\/strong>Java Persistence API including spring-data-jpa, spring-orm and Hibernate<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox\" data-range=\"1.3.0.M2\"><strong><label><\/label><label> JOOQ: <\/label><\/strong>Persistence support using Java Object Oriented Querying<label><\/label><label><\/label><\/div>\n<div data-range=\"1.3.0.M2\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> MyBatis: <\/label><\/strong>Persistence support using MyBatis<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> JDBC: <\/label><\/strong>JDBC databases<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> H2: <\/label><\/strong>H2 database (with embedded support)<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> HSQLDB: <\/label><\/strong>HSQLDB database (with embedded support)<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox\" data-range=\"1.2.2.RELEASE\"><strong><label><\/label><label> Apache Derby: <\/label><\/strong>Apache Derby database (with embedded support)<label><\/label><label><\/label><\/div>\n<div data-range=\"1.2.2.RELEASE\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> MySQL: <\/label><\/strong>MySQL jdbc driver<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> PostgreSQL: <\/label><\/strong>PostgreSQL jdbc driver<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox disabled has-error\" data-range=\"1.5.0.RC1\"><strong><label><\/label><label> SQL Server: <\/label><\/strong>Microsoft SQL Server jdbc driver: <label><\/label><label><\/label>requires Spring Boot &gt;=1.5.0.RC1<label><\/label><\/div>\n<div data-range=\"1.5.0.RC1\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> Flyway: <\/label><\/strong>Flyway Database Migrations library<label><\/label><label><\/label><\/div>\n<div data-range=\"\"><\/div>\n<div class=\"checkbox\" data-range=\"\"><strong><label><\/label><label> Liquibase: <\/label><\/strong>Liquibase Database Migrations library<label><\/label><label><\/label><\/div>\n<\/div>\n<p> From: http:\/\/sitestree.com\/?p=10916<br \/> Categories:Root<br \/>Tags:<br \/> Post Data:2017-07-28 23:08:44<\/p>\n<p>\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a><br \/>\n\t\tIn Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a><br \/>\n\t\t<a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a><br \/>\n\t\t8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a><br \/>\n\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\tMedium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Java Spring: Components to Deal with Database (SQL Aspect) JPA: Java Persistence API including spring-data-jpa, spring-orm and Hibernate JOOQ: Persistence support using Java Object Oriented Querying MyBatis: Persistence support using MyBatis JDBC: JDBC databases H2: H2 database (with embedded support) HSQLDB: HSQLDB database (with embedded support) Apache Derby: Apache Derby database (with embedded support) MySQL: &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=24463\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917,1956],"tags":[],"class_list":["post-24463","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","category-java-spring","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":67450,"url":"http:\/\/bangla.sitestree.com\/?p=67450","url_meta":{"origin":24463,"position":0},"title":"Hibernate: Basic Concepts #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 22, 2021","format":false,"excerpt":"Hibernate Object Relational Mapping Software ORM qualities: Pure relational, Light object mapping, Medium object mapping, Full object mapping ORM Metadata: ORM metadata provides support for mapping between classes and tables, properties and columns, associations and foreign keys, Java types and SQL types. Full Object Mapping: Supports advanced object modeling: composition,\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65920,"url":"http:\/\/bangla.sitestree.com\/?p=65920","url_meta":{"origin":24463,"position":1},"title":"What is Spring Framework? What does it mean to J2EE developers #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 17, 2021","format":false,"excerpt":"What is Spring Framework? What does it mean to J2EE developers? Spring is a light-weight framework, very often referred as an alternative\/competitor to EJB, for the development of enterprise-type applications. Spring provides many features such as declarative transaction management, access to remote logic using RMI or web services, mailing facilities\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65975,"url":"http:\/\/bangla.sitestree.com\/?p=65975","url_meta":{"origin":24463,"position":2},"title":"Introduction to Spring #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 18, 2021","format":false,"excerpt":"Open-sourced on February, 2003 Layered J2EE application framework Inversion of Control (IoC): A Data Access Object (DAO) depends on a DataSource. Allows: code to interfaces Spring has classes to support Hibernate, Struts, and other frameworks According to many Java developers [ref:internet], J2EE patterns are sometimes cumbersome. Spring uses patterns but\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78391,"url":"http:\/\/bangla.sitestree.com\/?p=78391","url_meta":{"origin":24463,"position":3},"title":"Code Refactoring in Java EE","author":"Sayed","date":"August 23, 2025","format":false,"excerpt":"From AI Tools\/OpenAI\/Internet \" Absolutely! Here\u2019s a concise, copyright-free summary of Java EE code refactoring Java EE Code Refactoring: Best Practices Refactoring in Java EE helps improve code quality, maintainability, and performance without changing functionality. Here are some key practices: 1. General Refactoring Remove duplicate code with helper methods or\u2026","rel":"","context":"In &quot;Anything JAVA&quot;","block_context":{"text":"Anything JAVA","link":"http:\/\/bangla.sitestree.com\/?cat=1975"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65971,"url":"http:\/\/bangla.sitestree.com\/?p=65971","url_meta":{"origin":24463,"position":4},"title":"Java Spring Topics: What spring framework brings to the table #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 18, 2021","format":false,"excerpt":"Java Spring TopicsKnowing the buzzwords does not make anyone a good developer. However, it helps. Being expert in a technology like Spring in one day is not possible, but initially getting familiar with all the aspects is helpful as you will know which Spring feature is required to solve the\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67448,"url":"http:\/\/bangla.sitestree.com\/?p=67448","url_meta":{"origin":24463,"position":5},"title":"Spring and iBatis: Some Notes [Will be updated later] #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 22, 2021","format":false,"excerpt":"Implementing the data access layer of a Spring application using iBATIS. Spring Framework and IBATISYou can use JDBC with Spring for sure. Spring also simplifies the use of JDBC. iBATIS can provide one more step in simplification. Using iBATIS, you can mapdata and Java objects, also make use of simplified\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/24463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=24463"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/24463\/revisions"}],"predecessor-version":[{"id":74598,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/24463\/revisions\/74598"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=24463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=24463"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=24463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}