CODEWITHSUNDEEP
spring-bootspring-data-jpawebsphere-libertyopen-liberty
pixel
pixel

Reputation: 10587

Springboot: Spring JPA - How to get datasource properties from server container

I use WAS Liberty Server container which provides server.xml and server.env file for configuring many things in addition to configuring DataSource properties such as url, username, password etc.

For security reasons, these properties are not known to developers for production Liberty servers. However, developers use same server.xml/server.evn files but with different DataSource properties so they can do their work.

So, I might have two server.env files like:

PRODUCTION server.env: dataSourceUrl="server-A-URL" (this URL is not known to developers)
DEVELOPMENT server.env: dataSourceUrl="server-B-URL" (this URL is known to developers)

, then the dataSourceUrl is used in server.xml files in production and development to set the url accordingly.

So, the structure of server.xml/server.env file is same for developers and production, only the DataSource url, username, password are different. This way developers can work using their own DataSource properties and once ready to deploy they app, it is handed to other team which then just changes the DataSource properties to the production values and deploys the application to production server.

With Springboot JPA, I know we can use application.properties file to set these DataSource values. But, we would like to be able to set these to the values located in server.env file. Basically to have something like this in application.properties file:

spring.datasource.url=dataSourceUrl //dataSourceUrl is set in server.env

, then be able to use this value in Java code using @Value injection like:

public class MyClass {
   @Value("${spring.datasource.url}")
   String dsUrl;
   ...
}

I have been reading about externalizing properties but I am not able to figure out how to do this

Upvotes: 0

Views: 420

Answers (1)

njr
njr

Reputation: 3484

You can use Liberty's jndiEntry elements to make configured values available in JNDI. You will need the jndi-1.0 feature, after which you can configure,

<jndiEntry jndiName="spring/datasource/url" value="${dataSourceUrl}"/>

and access it in your application as:

String dsUrl = InitialContext.doLookup("spring/datasource/url");

Or, from a web or ejb component as:

@Resource(lookup = "spring/datasource/url")
String dsUrl;

Upvotes: 1

Related Questions