Spring Boot Application not reading application.properties file when using Maven test

Question

UPDATE:

I realized a couple of things now. My application.properties file is being loaded properly because I verified via the /env path (thanks Dave) that my DB properties are being loaded. The problem appears to be that when I run it using the Spring Boot maven plug-in, it fails to initialize my dataSource.

mvn spring-boot:run

This then causes my application to blow-up with errors because other beans can't get initialized. The odd thing is it runs fine from Eclipse.

I have a class called DataService that extends JdbcTemplate. In my DataService constructor, I inject the DataSource.

@Component
public class DataService extends JdbcTemplate  {

  @Autowired
  public DataService(DataSource dataSource){
    super(dataSource);
  }
    ...more custom methods
}

I use this DataService class in other beans to perform DB operations. My DataSource is defined in my application.properties file

spring.datasource.url: jdbc:h2:tcp://localhost/~/testdb2
spring.datasource.driverClassName: org.h2.Driver

This is my Application.java class

@Configuration
@ComponentScan
@EnableAutoConfiguration
@EnableWebMvcSecurity
@EnableAsync
@EnableScheduling
public class Application {

    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}

I first realized this when I was attempting to run jUnit tests from Maven using

mavent test

I thought it just had to do with how it was executing the jUnit test cases however it is also occurring when I simply try to run the application using maven.

My JUnit4 test class is defined as follows:

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes={Application.class})
@WebAppConfiguration
public class QuestionRepositoryIntegrationTests {
    ...methods
}

I used the example from the Spring Boot how-to docs (https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html)

When I run this JUnit class from Eclipse, it works just fine. When it executes from maven, it starts to act up as I described above.

What's the symptom of it not working exactly? How many application.properties do you have on the classpath (maybe it's reading another one)? Also, I assume you would have set spring.datasource.hibernate.ddl-auto=none (otherwise using tcp for an H" database could lead to grief)? — Dave Syer
– Dave Syer, Commented Feb 27, 2014 at 22:05
@DaveSyer I'm not using hibernate. I realize my class name is misleading (Not using the Spring JPA repo classes). I'm using JdbcTemplate. I only have one application.properties file in my src/main/resources path. When my test cases run in eclipse, it reads the .properties file successfully and I can query my "questions" table. However, when Maven runs my test case, it says it can't find the "questions" table and I assume that's because it's not reading my datasource properties and it is defaulting to automatically creating an embedded DB since I have the H2 jar in my path. — John F.
– John F., Commented Feb 28, 2014 at 12:03
Can you try a snapshot? There was a bug with application.properties resolution that we fixed since RC3 (it doesn't seem relevant, but it might be). Otherwise, if you can share your complete project (or a simple project with the same problem) and a nice README to tell me how to create the database, I can take a look. — Dave Syer
– Dave Syer, Commented Feb 28, 2014 at 13:06
I would stick with the defaults unless you need something that the default DataSource can't do (it works for me in production). So we still need to try and understand why it wasn't working for you. The banner has nothing to do with properties files. The best thing you can do might be to add the actuator as a dependency (if you haven't already) and look at the /env endpoint (where you will see all the environment properties and their sources). — Dave Syer
– Dave Syer, Commented Feb 28, 2014 at 16:05
Just to confirm your application.properties are in the correct location ? src/main/resources and src/test/resources ?? — Tiarê Balbi
– Tiarê Balbi, Commented Oct 9, 2014 at 19:34

peterh · Accepted Answer · 2017-10-10 15:54:49Z

7

Try to define the <resources> tag in the build section in your pom, setting path for resource directory where is application.properties:

<build>
        <resources>
            <resource>
                <directory>resources</directory>
                <targetPath>${project.build.outputDirectory}</targetPath>
                <includes>
                    <include>application.properties</include>
                </includes>
            </resource>
        </resources>
</build>

edited Oct 10, 2017 at 15:54

peterh

1

answered Jun 2, 2015 at 11:42

Antonino Barila

1631 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Alex Beardsley Over a year ago

Yup, this worked for me. I have no idea why it was not picking them up automatically.

mobileDev Over a year ago

changed <directory>resources</directory> to <directory>src/main/resources</directory>

donny Over a year ago

It didn't work on my project :') would you like to checkout it out github.com/black-lotus/study-spring-netty @AlexBeardsley

KiriSakow · Accepted Answer · 2022-09-04 03:57:54Z

5

You can configure your main datasource as the following, I'm using mysql here. But you can use your own datasource. you can configure the following in your application.properties inside src/main/resources

spring.datasource.url = jdbc:mysql://localhost:3306/dsm
spring.datasource.username = root
spring.datasource.password = admin123
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1

spring.jpa.show-sql = true
spring.jpa.hibernate.ddl-auto = update
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

To run test inside your application you can either use the same datasource or create application-test.properties inside src/test/resources and it's possible to configure test data source over there.

edited Sep 4, 2022 at 3:57

KiriSakow

1,3031 gold badge17 silver badges27 bronze badges

answered Oct 27, 2015 at 9:58

nijogeorgep

76212 silver badges20 bronze badges

1 Comment

alextsil Over a year ago

If you name the file "application.properties" and put it in src/test/resources it will be automatically picked up by spring

Levent Divilioglu · Accepted Answer · 2019-04-15 11:35:27Z

2

Just add the following statement;

@TestPropertySource("classpath:application.properties")

To your test class. I am assuming you have your application.properties file under src/test/resources

Here is my working example;

@RunWith(SpringJUnit4ClassRunner.class)
@TestPropertySource("classpath:application.properties")
public class TestTwitterFeedRoute extends CamelTestSupport {
//...
}

answered Apr 15, 2019 at 11:35

Levent Divilioglu

11.7k5 gold badges61 silver badges111 bronze badges

Comments

luboskrnac · Accepted Answer · 2016-01-08 16:11:01Z

1

This works for me:

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = TestApplication.class, 
    initializers = ConfigFileApplicationContextInitializer.class)
public class SomeTestClass {
    ...
}

answered Jan 8, 2016 at 16:11

luboskrnac

24.7k10 gold badges86 silver badges93 bronze badges

1 Comment

Sasha Bond Over a year ago

due to updates @SpringApplicationConfiguration... should be replaced by : @SpringBootTest(classes = {TestApplication.class, ConfigFileApplicationContextInitializer.class})

obesechicken13 · Accepted Answer · 2015-11-02 16:39:39Z

0

Make sure your @ConfigurationProperties annotation is set to the same prefix as whatever you're using in your configuration file (application.config)

answered Nov 2, 2015 at 16:39

obesechicken13

8331 gold badge13 silver badges24 bronze badges

Comments

Vishnu Dahatonde · Accepted Answer · 2019-07-10 03:31:20Z

0

If you're using eclipse, its always a good idea to check the projects build resources. (Rclick project->properties->build path) I was not getting my application.properties file picked up and turned out I simply missed adding it to build resources.

answered Jul 10, 2019 at 3:31

Vishnu Dahatonde

1893 silver badges13 bronze badges

Comments

Navaneet Badami · Accepted Answer · 2020-06-09 04:43:46Z

0

I'm trying to load all properties files form outside jar, below entry in pom works perfect, you can also exclude or include files depends upon requirements.

  <build>
        <resources>
            <resource>
                 <directory>config</directory>
                 <includes>FILENAME</includes>
                 <excludes>FILENAME</excludes>
            </resource>
        </resources>
    </build>

answered Jun 9, 2020 at 4:43

Navaneet Badami

112 bronze badges

Collectives™ on Stack Overflow

Spring Boot Application not reading application.properties file when using Maven test

UPDATE:

7 Answers 7

3 Comments

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

UPDATE:

7 Answers 7

3 Comments

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related