title: How to consume spring cloud config server Jdbc backend configs from Spring cloud Client server?
body: <p>I went through lots of tutorials regarding this but could not get this done.</p>
  <p>Here is my table structure for this.</p>
  <pre><code>Application Profile Label  prop_key       value
  masking     dev     latest test-property  message
  </code></pre>
  <p>I have a cloud config server which should integrate with JDBC backend. Here is my <code>application.properties</code> in config server</p>
  <pre><code>server.port=8082
  spring.application.name=masking
  management.endpoints.web.exposure.include=*
  spring.datasource.url=jdbc:postgresql://localhost:8000/finos?currentSchema=xlabs
  spring.datasource.username=mufgdev
  spring.datasource.password=XXX
  spring.profiles.active=XXX
  spring.cloud.config.server.jdbc.sql=SELECT prop_key,value from xlabs.properties where application=? and profile=? and label=?
  spring.cloud.config.server.jdbc.order=1
  </code></pre>
  <p>With this configs if I enter <code>http://localhost:8082/masking/dev/latest</code> response will show the results as I want.</p>
  <p>I want to consume properties in client side with the following configs in <code>bootstrap.properties</code></p>
  <pre><code>spring.application.name=masking
  spring.cloud.config.uri=http://localhost:8082
  spring.cloud.config.label=latest
  spring.cloud.config.profile=dev
  </code></pre>
  <p>And in my client side</p>
  <pre><code>@RestController
  @RefreshScope
  public class TestController {
  
      @Value(&quot;${test-property}&quot;)
      private String aConf;
  
      @GetMapping(&quot;/message&quot;)
      String message() {
          String name =aConf ;
          return name;
      }
  }
  </code></pre>
  <p>This gives <code>java.lang.IllegalArgumentException: Could not resolve placeholder 'test-property' in value &quot;${test-property}&quot;</code></p>
  <p>Can anyone comment on this?</p>
  <p>Thanks.</p>