How can I externalize or use schema name at runtime while using DB2 queries from property file Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!How do I create a Java string from the contents of a file?How to use Java property files?“No CurrentSessionContext configured” when application try perform a query in the databaseIs it good practice to keep SQL statements in properties file? - Java/SpringInvalid Column Name Exception in Spring-Hibernate ApplicationSpring Boot Failure due to Transaction ManagementSpringboot JdbcTemplate Autowired failedCaused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set in Spring BatchSpring Boot Oracle Rest JdbcTemplate Gradle app with in-memory H2 for unit testsHow does JPA entityManager choose Connection Pool in Spring Boot Application?
Is there a way to convert Wolfram Language expression to string?
What documents does someone with a long-term visa need to travel to another Schengen country?
Are bags of holding fireproof?
Why not use the yoke to control yaw, as well as pitch and roll?
Why aren't these two solutions equivalent? Combinatorics problem
Who's this lady in the war room?
Like totally amazing interchangeable sister outfit accessory swapping or whatever
Do chord progressions usually move by fifths?
How can I introduce the names of fantasy creatures to the reader?
Can the van der Waals coefficients be negative in the van der Waals equation for real gases?
What is the evidence that custom checks in Northern Ireland are going to result in violence?
Trying to enter the Fox's den
How to mute a string and play another at the same time
Why are two-digit numbers in Jonathan Swift's "Gulliver's Travels" (1726) written in "German style"?
Why is one lightbulb in a string illuminated?
What's the difference between using dependency injection with a container and using a service locator?
Why these surprising proportionalities of integrals involving odd zeta values?
Why does my GNOME settings mention "Moto C Plus"?
A journey... into the MIND
“Since the train was delayed for more than an hour, passengers were given a full refund.” – Why is there no article before “passengers”?
Married in secret, can marital status in passport be changed at a later date?
lm and glm function in R
Can 'non' with gerundive mean both lack of obligation and negative obligation?
How to get a single big right brace?
How can I externalize or use schema name at runtime while using DB2 queries from property file
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!How do I create a Java string from the contents of a file?How to use Java property files?“No CurrentSessionContext configured” when application try perform a query in the databaseIs it good practice to keep SQL statements in properties file? - Java/SpringInvalid Column Name Exception in Spring-Hibernate ApplicationSpring Boot Failure due to Transaction ManagementSpringboot JdbcTemplate Autowired failedCaused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set in Spring BatchSpring Boot Oracle Rest JdbcTemplate Gradle app with in-memory H2 for unit testsHow does JPA entityManager choose Connection Pool in Spring Boot Application?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have developed spring-boot microservice and for Database interaction I am using jdbcTemplate. Currently I am placing all my queries in application.properties as below:
sql.select.query=update SCHEMA.TABLE_NAME set COL_NAME='ABC' where COL2_NAME='XYZ'
and in Dao Layer, Iam using this variable for query.
@Valuesql.select.query
private query;
The above piece of code is fine and running as expected but now the requirement came up that Schema name should be segregated from query so that in future it can be changed.
java spring spring-boot properties jdbctemplate
asked Mar 22 at 13:57
MeenalMeenal
558
add a comment |
I have developed spring-boot microservice and for Database interaction I am using jdbcTemplate. Currently I am placing all my queries in application.properties as below:
sql.select.query=update SCHEMA.TABLE_NAME set COL_NAME='ABC' where COL2_NAME='XYZ'
and in Dao Layer, Iam using this variable for query.
@Valuesql.select.query
private query;
The above piece of code is fine and running as expected but now the requirement came up that Schema name should be segregated from query so that in future it can be changed.
java spring spring-boot properties jdbctemplate
asked Mar 22 at 13:57
MeenalMeenal
558
sql.select.query=update $schema.name.TABLE_NAME
– Alexander Terekhov
Mar 22 at 14:03
@AlexanderTerekhov: But in properties file, does it able to identify $schema.name. Since the query is in appl.properties
– Meenal
Mar 22 at 14:16
Yep. You can set schema.name as another property or pass it through the command line. See this: docs.spring.io/spring-boot/docs/current/reference/html/…
– Alexander Terekhov
Mar 22 at 14:18
Thnx much but I was wondering if there is any way that I can pass schema.name similarly as I pass dataSource.username and dataSource.password and it can be picked up at runtime.
– Meenal
Mar 25 at 15:55
How are you passing dataSource.username and dataSource.password?
– Alexander Terekhov
Mar 26 at 18:33
add a comment |
I have developed spring-boot microservice and for Database interaction I am using jdbcTemplate. Currently I am placing all my queries in application.properties as below:
sql.select.query=update SCHEMA.TABLE_NAME set COL_NAME='ABC' where COL2_NAME='XYZ'
and in Dao Layer, Iam using this variable for query.
@Valuesql.select.query
private query;
The above piece of code is fine and running as expected but now the requirement came up that Schema name should be segregated from query so that in future it can be changed.
java spring spring-boot properties jdbctemplate
asked Mar 22 at 13:57
MeenalMeenal
558
I have developed spring-boot microservice and for Database interaction I am using jdbcTemplate. Currently I am placing all my queries in application.properties as below:
sql.select.query=update SCHEMA.TABLE_NAME set COL_NAME='ABC' where COL2_NAME='XYZ'
and in Dao Layer, Iam using this variable for query.
@Valuesql.select.query
private query;
The above piece of code is fine and running as expected but now the requirement came up that Schema name should be segregated from query so that in future it can be changed.
java spring spring-boot properties jdbctemplate
java spring spring-boot properties jdbctemplate
asked Mar 22 at 13:57
MeenalMeenal
558
asked Mar 22 at 13:57
MeenalMeenal
558
asked Mar 22 at 13:57
MeenalMeenal
558
asked Mar 22 at 13:57
MeenalMeenal
558
asked Mar 22 at 13:57
MeenalMeenal
558
558
sql.select.query=update $schema.name.TABLE_NAME
– Alexander Terekhov
Mar 22 at 14:03
@AlexanderTerekhov: But in properties file, does it able to identify $schema.name. Since the query is in appl.properties
– Meenal
Mar 22 at 14:16
Yep. You can set schema.name as another property or pass it through the command line. See this: docs.spring.io/spring-boot/docs/current/reference/html/…
– Alexander Terekhov
Mar 22 at 14:18
Thnx much but I was wondering if there is any way that I can pass schema.name similarly as I pass dataSource.username and dataSource.password and it can be picked up at runtime.
– Meenal
Mar 25 at 15:55
How are you passing dataSource.username and dataSource.password?
– Alexander Terekhov
Mar 26 at 18:33
add a comment |
sql.select.query=update $schema.name.TABLE_NAME
– Alexander Terekhov
Mar 22 at 14:03
@AlexanderTerekhov: But in properties file, does it able to identify $schema.name. Since the query is in appl.properties
– Meenal
Mar 22 at 14:16
Yep. You can set schema.name as another property or pass it through the command line. See this: docs.spring.io/spring-boot/docs/current/reference/html/…
– Alexander Terekhov
Mar 22 at 14:18
Thnx much but I was wondering if there is any way that I can pass schema.name similarly as I pass dataSource.username and dataSource.password and it can be picked up at runtime.
– Meenal
Mar 25 at 15:55
How are you passing dataSource.username and dataSource.password?
– Alexander Terekhov
Mar 26 at 18:33
sql.select.query=update $schema.name.TABLE_NAME
– Alexander Terekhov
Mar 22 at 14:03
sql.select.query=update $schema.name.TABLE_NAME
– Alexander Terekhov
Mar 22 at 14:03
@AlexanderTerekhov: But in properties file, does it able to identify $schema.name. Since the query is in appl.properties
– Meenal
Mar 22 at 14:16
@AlexanderTerekhov: But in properties file, does it able to identify $schema.name. Since the query is in appl.properties
– Meenal
Mar 22 at 14:16
Yep. You can set schema.name as another property or pass it through the command line. See this: docs.spring.io/spring-boot/docs/current/reference/html/…
– Alexander Terekhov
Mar 22 at 14:18
Yep. You can set schema.name as another property or pass it through the command line. See this: docs.spring.io/spring-boot/docs/current/reference/html/…
– Alexander Terekhov
Mar 22 at 14:18
Thnx much but I was wondering if there is any way that I can pass schema.name similarly as I pass dataSource.username and dataSource.password and it can be picked up at runtime.
– Meenal
Mar 25 at 15:55
Thnx much but I was wondering if there is any way that I can pass schema.name similarly as I pass dataSource.username and dataSource.password and it can be picked up at runtime.
– Meenal
Mar 25 at 15:55
How are you passing dataSource.username and dataSource.password?
– Alexander Terekhov
Mar 26 at 18:33
How are you passing dataSource.username and dataSource.password?
– Alexander Terekhov
Mar 26 at 18:33
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%2f55301217%2fhow-can-i-externalize-or-use-schema-name-at-runtime-while-using-db2-queries-from%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%2f55301217%2fhow-can-i-externalize-or-use-schema-name-at-runtime-while-using-db2-queries-from%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
sql.select.query=update $schema.name.TABLE_NAME
– Alexander Terekhov
Mar 22 at 14:03
@AlexanderTerekhov: But in properties file, does it able to identify $schema.name. Since the query is in appl.properties
– Meenal
Mar 22 at 14:16
Yep. You can set schema.name as another property or pass it through the command line. See this: docs.spring.io/spring-boot/docs/current/reference/html/…
– Alexander Terekhov
Mar 22 at 14:18
Thnx much but I was wondering if there is any way that I can pass schema.name similarly as I pass dataSource.username and dataSource.password and it can be picked up at runtime.
– Meenal
Mar 25 at 15:55
How are you passing dataSource.username and dataSource.password?
– Alexander Terekhov
Mar 26 at 18:33