How to create the application.properties file in a Spring Boot project?

[Sam Peterson]

I'm using Eclipse to develop a Spring Boot with devtools project, and I get the following error when I try to run it:


***************************
APPLICATION FAILED TO START
***************************

Description:

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

Reason: Failed to determine a suitable driver class


I suspect the main reason for this is that I don't have an application.properties file in the src/main/resources folder. I tried to right-click-new, but nothing pops up that gives me the option to create a .properties file manually. Do I need to configure a build path to get this file created? If so, how do I do that once I'm in the Java Build Path menu?

[Rob Spoor]

Just create a new "File" and name it application.properties. You can do that with any file that doesn't have a special editor. I even do it for new XML files.

And welcome to the Ranch!

[Sam Peterson]

I'm still having issues launching my Spring Boot application:

properties file:
#spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl #spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver #spring.datasource.username=c##sam #spring.datasource.password=cartman86 spring.jpa.hibernate.hbm2ddl-auto=update spring.jpa.show-sql=true spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.OracleDialect spring.datasource.driver-class-name=org.h2.Driver spring.datasource.url=jdbc:h2:mem:localhost spring.datasource.username=admin
pom.xml file:
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>sam.springboot</groupId>  <artifactId>maven-api</artifactId>  <version>0.0.1-SNAPSHOT</version>  <name>SamSpringBoot01</name>    <parent>   <groupId>org.springframework.boot</groupId>   <artifactId>spring-boot-starter-parent</artifactId>   <version>2.1.7.RELEASE</version>  </parent>    <properties>   <java.version>1.8</java.version>  </properties>    <dependencies>  <!--       <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0</version> </dependency> --> <dependency> <groupId>com.h2database</groupId> <artifactId>h2</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-actuator</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <scope>runtime</scope> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency>    </dependencies>     </project>

[Console Output]
***************************
APPLICATION FAILED TO START
***************************

Description:

Field MMR in sam.springboot.service.MedicalMemberService required a bean of type 'sam.springboot.dao.MedicalMemberRepo' that could not be found.

The injection point has the following annotations:
- @org.springframework.beans.factory.annotation.Autowired(required=true)


Action:

Consider defining a bean of type 'sam.springboot.dao.MedicalMemberRepo' in your configuration.
[/Console Output]

MedicalMemberRepo class:

package sam.springboot.dao;

import sam.springboot.model.MedicalMemberEntity;

import org.springframework.context.annotation.Configuration;
import org.springframework.data.repository.CrudRepository;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

@Configuration
@Repository
public interface MedicalMemberRepo extends CrudRepository<MedicalMemberEntity, Integer>{

}

MedicalMemberService class:

package sam.springboot.service;
import sam.springboot.dao.MedicalMemberRepo;
import sam.springboot.model.MedicalMemberEntity;
//import sam.springboot.dao.MedicalInventoryRepo;

import java.util.ArrayList;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.stereotype.Service;

@Service
public class MedicalMemberService {
	
	@Bean("sam.springboot.dao.MedicalMemberRepo")//The annotation @Bean is disallowed for this location
	//The easiest way to get an instance of the interface in the dao package is with the @Autowired annotation
	@Autowired
	private MedicalMemberRepo MMR;//Instance of the dao interface (instead of doing "implements MedicalMemeber" in the Service class declaration).
							 	  //This MMR instance also gives us access to the CrudRepository built-in methods.
	
	@Bean//The annotation @Bean is disallowed for this location
	private List<MedicalMemberEntity> mmList = new ArrayList<>();
	
	//get all medical members
	public List<MedicalMemberEntity> getAllMedicalMembers(){
		Iterable<MedicalMemberEntity> it = MMR.findAll();
		//List<MedicalMemberEntity> mmList = new ArrayList<>();
		it.forEach(mm -> mmList.add((MedicalMemberEntity) mm));
		it.forEach(mm -> mmList.add(mm));
		return mmList;
	}
	
	//get a specific medical member
	public MedicalMemberEntity getMedicalMemberByID(int mmID){
		return mmList.stream().filter(mm -> mm.getMmID() == mmID).findFirst().get();
	}
		
	//add medical member
	public void addMedicalMember(MedicalMemberEntity mme) {
		MMR.save(mme);
	}
	
	public void updateMedicalMember(int mmID, MedicalMemberEntity mme) {
		MMR.save(mme);
	}
}

As you can see on lines 16 and 22, I've added the @Bean annotations, but it gives the error, "The annotation @Bean is disallowed for this location".
What am I missing?

[Al Hobbs]

You dont need to use @bean.   Just have the auto wired and it will find the bean.  Also why do you have the repo annotated with @configuration.  Did you put configurations in there ?  Dont know why that would ever be a good idea.  
The bean annotation is used for creating beans to be used in places like the service.  Not for injection.  Heres the docs : https://docs.spring.io/spring-javaconfig/docs/1.0.0.M4/reference/html/ch02s02.html

[Rob Spoor]

What package is your @SpringBootApplication in? Is it sam.springboot, or something else? If it's something else, what packages is it scanning?