H2 Console in Spring Boot Integration Test

Question

I'm working with Spring Boot 1.3.1.RELEASE. I enabled the H2 web console by setting spring.h2.console.enabled=true in the application.properties file. If I launch my Spring Boot application I can access the H2 Web console via http://localhost:8080/h2-console/.

However, I am not able to access the console when I perform an integration test in debug mode, where I have set a breakpoint. Unfortunately, this is not working (site is not available). The integration test is configured as follows:

@ActiveProfiles("local,unittest")
@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = MyApplication.class)
@WebAppConfiguration
@IntegrationTest
public class MyResourceTest {

What I have not considered?

Have you tried adding "test" to @ActiveProfiles ? – yugo Feb 02 '16 at 20:22 — yugo, Feb 02 '16 at 20:22
Yes, but this does not work as well. – René Winkler Feb 02 '16 at 20:35 — René Winkler, Feb 02 '16 at 20:35

score 4 · Accepted Answer · edited Feb 02 '16 at 21:55

4

To enable the H2 Web console, you should agregate the value of your properties file related to this item as optional element of the annotation @IntegrationTest.

String[]value Properties in form key=value that should be added to the Spring Environment before the test runs.

Example:

@IntegrationTest({"spring.h2.console.enabled=true"})

And keep in mind this recomendation :

If your test also uses @WebAppConfiguration consider using the @WebIntegrationTest instead of @IntegrationTest

So, try to use @WebIntegrationTest instead of @IntegrationTest and add the key spring.h2.console.enabled = true

http://docs.spring.io/spring-boot/docs/current/api/org/springframework/boot/test/IntegrationTest.html

http://docs.spring.io/spring-boot/docs/current/api/org/springframework/boot/test/WebIntegrationTest.html

Maybe you could need add the key "server.port=8080" as another value for the annotation @WebIntegrationTest

edited Feb 02 '16 at 21:55

amit_saxena

7,450
5
49
64

answered Feb 02 '16 at 20:24

Jesus Zavarce

1,729
1
17
27

Thank you for your suggestion. Meanwhile I have tried it, but unfortunately it does not work. – René Winkler Feb 02 '16 at 20:40
Remove the annotation @IntegrationTest, your test finish with succes ? – Jesus Zavarce Feb 02 '16 at 20:51
No, it does not. The following Exception is thrown: java.lang.IllegalArgumentException: Could not resolve placeholder 'local.server.port' in string value "${local.server.port}"` – René Winkler Feb 02 '16 at 20:55
aahh , try to add "server.port=8080" as key of your annotation, put also this key in your properties file – Jesus Zavarce Feb 02 '16 at 20:57
it's loading...site never appears. But at least I no longer get an error :-) – René Winkler Feb 02 '16 at 21:08
try to change your port, ex 8081, run your test and go to http://localhost:8081/h2-console/. – Jesus Zavarce Feb 02 '16 at 21:14
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/102403/discussion-between-jesus-zavarce-and-rene-winkler). – Jesus Zavarce Feb 02 '16 at 21:37
Did you try creating a @Bean for the /console? – Paulo Pedroso Feb 02 '16 at 22:10
What more do you add to fix your problem ? – Jesus Zavarce Feb 03 '16 at 13:44
debugging seems to block the H2 console as well. I opened a new question for that: http://stackoverflow.com/questions/35179110/spring-boot-is-blocking-h2-console-in-debug-mode – René Winkler Feb 03 '16 at 13:59

H2 Console in Spring Boot Integration Test

1 Answers1