title: How to specify DataSource in JdbcTemplate?
body: <p>In my application.properties I have set:</p>
  
  <pre><code>datasource.test.driverClass=org.postgresql.Driver
  datasource.test.url=jdbc:postgresql://localhost:5433/test
  datasource.test.username=admin
  datasource.test.password=admin
  
  logging.level.com.eternity = DEBUG
  </code></pre>
  
  <p>In my controller, I am trying to execute some SQL query form a string like this:</p>
  
  <pre><code>String selectQueryPartOne = "SELECT name, ("+ StringUtils.join(sumString, " + ")+") AS 'Price' FROM house WHERE NOT (" +StringUtils.join(sumString, " IS NULL OR ")+" IS NULL);";
  JdbcTemplate statement = new JdbcTemplate();
  statement.queryForList(selectQueryPartOne);
  </code></pre>
  
  <p>Which would work fine, however, I am receiving the following error:</p>
  
  <pre><code>java.lang.IllegalArgumentException: No DataSource specified
  </code></pre>
  
  <p>I've discovered, that in my <code>statement</code> object, I need to setDataSource first. However, I have no idea where I can get this dataSource object. Could you help?</p>