{"id":20088,"date":"2024-03-15T19:56:32","date_gmt":"2024-03-15T19:56:32","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/"},"modified":"2024-03-21T17:15:13","modified_gmt":"2024-03-21T17:15:13","slug":"how-does-spring-boot-execute-ddl-statements","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/","title":{"rendered":"How does Spring Boot execute DDL statements?"},"content":{"rendered":"<p>There are multiple ways to execute DDL statements in Spring Boot, but two common options are listed below:<\/p>\n<ol>\n<li>When using JdbcTemplate, it is a utility class provided by the Spring Framework for executing SQL statements which can carry out DDL statements. To start with, you will need to configure the database connection information in the configuration file of your Spring Boot application (application.properties or application.yml). Then, inject JdbcTemplate in your code and utilize its execute method to execute DDL statements.<\/li>\n<\/ol>\n<p>Sample code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-meta\">@Autowired<\/span>\r\n<span class=\"hljs-keyword\">private<\/span> JdbcTemplate jdbcTemplate;\r\n\r\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title function_\">executeDDL<\/span><span class=\"hljs-params\">()<\/span> {\r\n    <span class=\"hljs-type\">String<\/span> <span class=\"hljs-variable\">ddlSQL<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">\"CREATE TABLE my_table (id INT PRIMARY KEY, name VARCHAR(100))\"<\/span>;\r\n    jdbcTemplate.execute(ddlSQL);\r\n}\r\n<\/code><\/pre>\n<ol>\n<li>When using SchemaExport in Hibernate: If you are using Hibernate as your ORM framework, you can utilize the SchemaExport utility class it provides to execute DDL statements. First, you need to configure the relevant Hibernate information in your Spring Boot application&#8217;s configuration file, then obtain the SessionFactory in your code and use its createSchemaExport method to execute the DDL statements.<\/li>\n<\/ol>\n<p>Example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-meta\">@Autowired<\/span>\r\n<span class=\"hljs-keyword\">private<\/span> SessionFactory sessionFactory;\r\n\r\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title function_\">executeDDL<\/span><span class=\"hljs-params\">()<\/span> {\r\n    <span class=\"hljs-type\">SchemaExport<\/span> <span class=\"hljs-variable\">schemaExport<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title class_\">SchemaExport<\/span>(sessionFactory);\r\n    schemaExport.create(<span class=\"hljs-literal\">true<\/span>, <span class=\"hljs-literal\">true<\/span>);\r\n}\r\n<\/code><\/pre>\n<p>Both ways can execute DDL statements in Spring Boot, so you can choose the one that best fits your needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are multiple ways to execute DDL statements in Spring Boot, but two common options are listed below: When using JdbcTemplate, it is a utility class provided by the Spring Framework for executing SQL statements which can carry out DDL statements. To start with, you will need to configure the database connection information in the [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-20088","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How does Spring Boot execute DDL statements? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How does Spring Boot execute DDL statements?\" \/>\n<meta property=\"og:description\" content=\"There are multiple ways to execute DDL statements in Spring Boot, but two common options are listed below: When using JdbcTemplate, it is a utility class provided by the Spring Framework for executing SQL statements which can carry out DDL statements. To start with, you will need to configure the database connection information in the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T19:56:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T17:15:13+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Taylor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"How does Spring Boot execute DDL statements?\",\"datePublished\":\"2024-03-15T19:56:32+00:00\",\"dateModified\":\"2024-03-21T17:15:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/\"},\"wordCount\":174,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/\",\"name\":\"How does Spring Boot execute DDL statements? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T19:56:32+00:00\",\"dateModified\":\"2024-03-21T17:15:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How does Spring Boot execute DDL statements?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How does Spring Boot execute DDL statements? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/","og_locale":"en_US","og_type":"article","og_title":"How does Spring Boot execute DDL statements?","og_description":"There are multiple ways to execute DDL statements in Spring Boot, but two common options are listed below: When using JdbcTemplate, it is a utility class provided by the Spring Framework for executing SQL statements which can carry out DDL statements. To start with, you will need to configure the database connection information in the [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T19:56:32+00:00","article_modified_time":"2024-03-21T17:15:13+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"How does Spring Boot execute DDL statements?","datePublished":"2024-03-15T19:56:32+00:00","dateModified":"2024-03-21T17:15:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/"},"wordCount":174,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/","url":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/","name":"How does Spring Boot execute DDL statements? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T19:56:32+00:00","dateModified":"2024-03-21T17:15:13+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-does-spring-boot-execute-ddl-statements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How does Spring Boot execute DDL statements?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20088","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=20088"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20088\/revisions"}],"predecessor-version":[{"id":53866,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/20088\/revisions\/53866"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=20088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=20088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=20088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}