How do you use a Tomcat JNDI JDBC datasource in Spring Boot

tomcat7 spring-data-jpa spring-boot
Zac Tolley picture Zac Tolley · Feb 28, 2014 · Viewed 23.4k times · Source

I have a Spring boot application and want to deploy as a WAR to Tomcat 7. As part of this I need to keep configuration out of the WAR, so that I can deploy the same war to my stage and production servers and have it pickup the mysql connection via configuration.

To this end I want to configure my Spring Boot app to use a mysql connection configured as a JNDI datasource in the Tomcat instance.

Can spring boot do this and if so how?

Alternatively is this easy to do in Spring 4 without resorting to xml based configuration.

Answer

dustin.schultz picture dustin.schultz · Mar 20, 2015

If you're using Spring Boot 1.2 or greater, this got easier. You can just add this to application.properties

spring.datasource.jndi-name=java:comp/env/jdbc/my_database

The relevant docs: http://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-sql.html#boot-features-connecting-to-a-jndi-datasource

Related questions

Tomcat 7 SEVERE: Context [] startup failed due to previous errors after add spring-data-jpa to dependency in pom

I have a spring rest app.It is configured with annotations. When I add spring-data-jpa dependency the application is falling with error on Tomcat 7(jdk 1.7): Jun 22, 2015 5:05:18 PM org.apache.catalina.startup.HostConfig deployWAR INFO: Deploying web application archive /var/lib/…

Read More
java.lang.ClassNotFoundException: org.springframework.web.context.ContextLoaderListener

I included these in the Build Path: all Spring libs Apache Tomcat 7.0 library The project still fails during startup: SEVERE: Error configuring application listener of class org.springframework.web.context.ContextLoaderListener java.lang.ClassNotFoundException: org.springframework.web.context.ContextLoaderListener at …

Read More
How to set the context path of a web application in Tomcat 7.0

I know that I can rename my webapp (or it's WAR file) to ROOT but this is a terrible way to do it, IMHO. Now I checked out the tomcat doc & it says It is NOT recommended to place …

Read More