Spring Boot run data.sql without running schema.sql
Im trying to run initialization script (data.sql) without running DDL (schema.sql).
Application simply can't execute DDL, because of some security guidelines, so tables have to exist beforehand and this is not part of this question.
My results:
- If both schema.sql and data.sql are present, both will execute.
- If only schema.sql is present, it will execute.
- If only data.sql is present, it won't execute.
I understand, that executing data.sql only is probably not usual, but the only workaround for me is to create schema.sql like this (MS SQL):
SELECT 'true' AS 'whatever';
so that script is not null or empty and data.sql is then executed as intended.
I am using spring boot version 1.5.16.RELEASE
application.yml:
spring:
datasource:
jndi-name: java:/datasource/mssql
initialization-mode: always
jpa:
properties.hibernate.dialect: org.hibernate.dialect.SQLServer2012Dialect
hibernate:
ddl-auto: none
Is there any better option?
database spring-boot
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
add a comment |
Im trying to run initialization script (data.sql) without running DDL (schema.sql).
Application simply can't execute DDL, because of some security guidelines, so tables have to exist beforehand and this is not part of this question.
My results:
- If both schema.sql and data.sql are present, both will execute.
- If only schema.sql is present, it will execute.
- If only data.sql is present, it won't execute.
I understand, that executing data.sql only is probably not usual, but the only workaround for me is to create schema.sql like this (MS SQL):
SELECT 'true' AS 'whatever';
so that script is not null or empty and data.sql is then executed as intended.
I am using spring boot version 1.5.16.RELEASE
application.yml:
spring:
datasource:
jndi-name: java:/datasource/mssql
initialization-mode: always
jpa:
properties.hibernate.dialect: org.hibernate.dialect.SQLServer2012Dialect
hibernate:
ddl-auto: none
Is there any better option?
database spring-boot
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
I'm using this approach for testing in combination with flyway but with Spring Boot 2. Have you spring.datasource.initialization-mode=always set?
– Simon Martinelli
Nov 23 '18 at 15:49
Yes and I've added application.yml to the question.
– Dzejwi
Nov 27 '18 at 18:24
as i said this works for me. Do you have any code that i can run?
– Simon Martinelli
Nov 27 '18 at 18:27
Unfortunately I cannot share the actual code, but i will try to make minimalistic project in my spare time to demonstrate this issue.
– Dzejwi
Nov 29 '18 at 11:00
add a comment |
Im trying to run initialization script (data.sql) without running DDL (schema.sql).
Application simply can't execute DDL, because of some security guidelines, so tables have to exist beforehand and this is not part of this question.
My results:
- If both schema.sql and data.sql are present, both will execute.
- If only schema.sql is present, it will execute.
- If only data.sql is present, it won't execute.
I understand, that executing data.sql only is probably not usual, but the only workaround for me is to create schema.sql like this (MS SQL):
SELECT 'true' AS 'whatever';
so that script is not null or empty and data.sql is then executed as intended.
I am using spring boot version 1.5.16.RELEASE
application.yml:
spring:
datasource:
jndi-name: java:/datasource/mssql
initialization-mode: always
jpa:
properties.hibernate.dialect: org.hibernate.dialect.SQLServer2012Dialect
hibernate:
ddl-auto: none
Is there any better option?
database spring-boot
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
Im trying to run initialization script (data.sql) without running DDL (schema.sql).
Application simply can't execute DDL, because of some security guidelines, so tables have to exist beforehand and this is not part of this question.
My results:
- If both schema.sql and data.sql are present, both will execute.
- If only schema.sql is present, it will execute.
- If only data.sql is present, it won't execute.
I understand, that executing data.sql only is probably not usual, but the only workaround for me is to create schema.sql like this (MS SQL):
SELECT 'true' AS 'whatever';
so that script is not null or empty and data.sql is then executed as intended.
I am using spring boot version 1.5.16.RELEASE
application.yml:
spring:
datasource:
jndi-name: java:/datasource/mssql
initialization-mode: always
jpa:
properties.hibernate.dialect: org.hibernate.dialect.SQLServer2012Dialect
hibernate:
ddl-auto: none
Is there any better option?
database spring-boot
database spring-boot
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
edited Nov 23 '18 at 15:49
Dzejwi
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
asked Nov 23 '18 at 15:46
DzejwiDzejwi
11
11
I'm using this approach for testing in combination with flyway but with Spring Boot 2. Have you spring.datasource.initialization-mode=always set?
– Simon Martinelli
Nov 23 '18 at 15:49
Yes and I've added application.yml to the question.
– Dzejwi
Nov 27 '18 at 18:24
as i said this works for me. Do you have any code that i can run?
– Simon Martinelli
Nov 27 '18 at 18:27
Unfortunately I cannot share the actual code, but i will try to make minimalistic project in my spare time to demonstrate this issue.
– Dzejwi
Nov 29 '18 at 11:00
add a comment |
I'm using this approach for testing in combination with flyway but with Spring Boot 2. Have you spring.datasource.initialization-mode=always set?
– Simon Martinelli
Nov 23 '18 at 15:49
Yes and I've added application.yml to the question.
– Dzejwi
Nov 27 '18 at 18:24
as i said this works for me. Do you have any code that i can run?
– Simon Martinelli
Nov 27 '18 at 18:27
Unfortunately I cannot share the actual code, but i will try to make minimalistic project in my spare time to demonstrate this issue.
– Dzejwi
Nov 29 '18 at 11:00
I'm using this approach for testing in combination with flyway but with Spring Boot 2. Have you spring.datasource.initialization-mode=always set?
– Simon Martinelli
Nov 23 '18 at 15:49
I'm using this approach for testing in combination with flyway but with Spring Boot 2. Have you spring.datasource.initialization-mode=always set?
– Simon Martinelli
Nov 23 '18 at 15:49
Yes and I've added application.yml to the question.
– Dzejwi
Nov 27 '18 at 18:24
Yes and I've added application.yml to the question.
– Dzejwi
Nov 27 '18 at 18:24
as i said this works for me. Do you have any code that i can run?
– Simon Martinelli
Nov 27 '18 at 18:27
as i said this works for me. Do you have any code that i can run?
– Simon Martinelli
Nov 27 '18 at 18:27
Unfortunately I cannot share the actual code, but i will try to make minimalistic project in my spare time to demonstrate this issue.
– Dzejwi
Nov 29 '18 at 11:00
Unfortunately I cannot share the actual code, but i will try to make minimalistic project in my spare time to demonstrate this issue.
– Dzejwi
Nov 29 '18 at 11:00
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53449558%2fspring-boot-run-data-sql-without-running-schema-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53449558%2fspring-boot-run-data-sql-without-running-schema-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I'm using this approach for testing in combination with flyway but with Spring Boot 2. Have you spring.datasource.initialization-mode=always set?
– Simon Martinelli
Nov 23 '18 at 15:49
Yes and I've added application.yml to the question.
– Dzejwi
Nov 27 '18 at 18:24
as i said this works for me. Do you have any code that i can run?
– Simon Martinelli
Nov 27 '18 at 18:27
Unfortunately I cannot share the actual code, but i will try to make minimalistic project in my spare time to demonstrate this issue.
– Dzejwi
Nov 29 '18 at 11:00