An Implementation of Spring Boot With Spring Data JPA

DZone 's Guide to

An Implementation of Spring Boot With Spring Data JPA

Check out this tutorial on how to get started building a Spring Boot application with Spring Data JPA.

Hazal Kecoglu

Dec. 13, 19 · Java Zone ·

Free Resource

Like (1)

Comment (0)

Save

{{ articles[0].views | formatCount}} Views

Get started building a Spring Boot application with Spring Data JPA.

This guide includes my interest in how you can handle complex CRUD operations such a simple way with Spring Data JPA and using native queries in case of needs.

In this tutorial, I am using the Oracle database along with Spring Data. Besides, it will be helpful if you have a server dependency for Weblogic.

You may also like: Using the Spring Data JPA

First, we should define our JNDI name in our Spring Boot Project’s application.properties file. We must pay attention to the JNDI name we define in our properties file. It must be the same within our Weblogic’s DataSources JNDI Name.

     Java 
   
          x 
         
spring.datasource.primary.jndi-name=TEST-JNDI

Then, in our DataSourceConfig class, we have some configurations about our JNDI and we define which classes to scan under our project's package as domain objects.

     Java 
   
xxxxxxxxxx
 
package com.company.xxapp.xx.config;
/**
 necessary imports
*/
@Configuration
@EnableTransactionManagement
@ComponentScan({"com.company.xxapp.xx.*"})
@EnableJpaRepositories(basePackages = {"com.company.xxapp.xx.*"},
        entityManagerFactoryRef = "domainEntityManager",
        transactionManagerRef = "domainTransactionManager")
public class DataSourceConfig{
    @Bean(name = "domainEntityManager")
    public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
        LocalContainerEntityManagerFactoryBean em  = new LocalContainerEntityManagerFactoryBean();
        em.setDataSource(dataSource());
        em.setPackagesToScan(new String[]{"com.company.xxapp.xx.domain"});
        JpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        em.setJpaVendorAdapter(vendorAdapter);
        Map<String, Object> properties = new HashMap();
        properties.put("hibernate.dialect","org.hibernate.dialect.Oracle10gDialect");
        properties.put("hibernate.default_schema","XXX");
        properties.put("hibernate.proc.param_null_passing","true");
        em.setJpaPropertyMap(properties);
        return em;
    }
    @Bean
    public PersistenceExceptionTranslationPostProcessor exceptionTranslation() {
        return new PersistenceExceptionTranslationPostProcessor();
    }
    @Value("${spring.datasource.primary.jndi-name}")
    private String primaryJndiName;
    @Bean(name = "domainTransactionManager")
    public JpaTransactionManager getJpaTransactionManager() {
        return new JpaTransactionManager();
    }
    @Bean
    public DataSource dataSource() {
        JndiDataSourceLookup lookup = new JndiDataSourceLookup();
        lookup.setResourceRef(true);
        return lookup.getDataSource(primaryJndiName);
    }
}

Let’s assume we have a customer table in our database.

     Java 
   
xxxxxxxxxx
 
SCHEMA.CUSTOMER
(
  NCUSTOMER_ID             NUMBER(20),
  VCUSTOMER_NAME           VARCHAR2(100 CHAR),
  VCUSTOMER_LNAME          VARCHAR2(50 CHAR),
  VCOMPANY_NAME            VARCHAR2(150 CHAR),
  NINDIVIDUAL_OR_COMPANY   NUMBER(1),
  DSUBSCRIPTION_DATE       DATE,
  VCREATED_BY              VARCHAR2(50 BYTE),
  VCREATED_MACHINE         VARCHAR2(50 BYTE),
  DCREATED_DATE            DATE,
  DMODIFIED_DATE           DATE,
  VMODIFIED_BY             VARCHAR2(50 BYTE),
  VMODIFIED_MACHINE        VARCHAR2(50 BYTE)
)

With its associated JPA Entity:

     Java 
   
xxxxxxxxxx
 
package com.company.xxapp.xx.domain;
import lombok.Getter;
import lombok.Setter;
import javax.persistence.*;
import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
@Getter
@Setter
@Entity
@Table(name="CUSTOMER",schema = "SCHEMA")
public class Customer extends BaseEntity implements Serializable {
    @Id
    @Column(name = "NCUSTOMER_ID")
    private Long customerId;
    @Column(name = "VCUSTOMER_NAME")
    private String customerName;
    @Column(name = "VCUSTOMER_LNAME")
    private String customerLname;
    @Column(name = "VCOMPANY_NAME")
    private String companyName;
    @Column(name = "NINDIVIDUAL_OR_COMPANY")
    private int indOrComp;
    @Column(name = "DSUBSCRIPTION_DATE")
    private Date subscriptionDate;
}

     Java 
   
xxxxxxxxxx
 
package com.company.xxapp.xx.domain;
import lombok.Getter;
import lombok.Setter;
import javax.persistence.Column;
import javax.persistence.MappedSuperclass;
import java.util.Date;
@Getter
@Setter
@MappedSuperclass
public abstract class BaseEntity {
        @Column(name = "VCREATED_BY")
        protected String createdBy;
        @Column(name = "DCREATED_DATE")
        protected Date createdDate;
        @Column(name = "VCREATED_MACHINE")
        protected String createdMachine;
        @Column(name = "VMODIFIED_BY")
        protected String modifiedBy;
        @Column(name = "DMODIFIED_DATE")
        protected Date modifiedDate;
        @Column(name = "VMODIFIED_MACHINE")
        protected String modifiedMachine;

Our query would be like below if we want to get 1000 corporate customers that subscribed on a given date.

     SQL 
   
xxxxxxxxxx
 
SELECT NCUSTOMER_ID,  VCUSTOMER_NAME, VCUSTOMER_LNAME,
       VCOMPANY_NAME, NINDIVIDUAL_OR_COMPANY, DSUBSCRIPTION_DATE
  FROM SCHEMA.CUSTOMER CUST
 WHERE     DSUBSCRIPTION_DATE >= :paramDate
       AND NINDIVIDUAL_OR_COMPANY = :paramIndOrComp
       AND ROWNUM < 1000

We can query our records with that SQL but we can also query like below in a simpler way and our codebase will be consistent with our Repository class.

     Java 
   
xxxxxxxxxx
 
package com.company.xxapp.xx.repository;
/**
 necessary imports
*/
public interface ICustomerRepository extends CrudRepository<Customer,String> {
   List<Customer> findTop1000BySubscriptionDateGreaterThanEqualAndIndOrComp (Date subsDate, int indOrComp);
}

Now, we able to list our records like this.

     Java 
   
xxxxxxxxxx
 
package com.company.xxapp.xx.service;
/**
 necessary imports
*/
@Slf4j
@Service
public class CustomerService implements ICustomerService {
    @Autowired
    private ICustomerRepository customerRepository;
    @Override
    public void getCustomers() {
        try {
               List<Customer> poolList = customerRepository. findTop1000BySubscriptionDateGreaterThanEqualAndIndOrComp( GeneralUtils.getDateWithoutTime( new Date(), 0 ), CustomerEnum.CORPORATE.getType());
        } catch (Exception ex) {
            log.error( "CustomerService exception occured {}", ExceptionUtils.getStackTrace(ex));
        }
    }
  }

Also, we will be able to implement general CRUD operations like below without extra effort.

     Java 
   
xxxxxxxxxx
 
package com.turkcelltech.company.xxapp.repository;
/**
 necessary imports
*/
public interface ICustomerRepository extends CrudRepository<Customer,String> {
}

I also try to sample a native query call and also how to call a stored procedure with Spring Data below.

     Java 
   
xxxxxxxxxx
 
package com.turkcelltech.trace.collector.repository;
/**
 necessary imports
*/
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
public interface ICustomerLiteRepository extends CrudRepository<Customer,Long> {
    @Query(value = "SELECT NCUSTOMER_ID,  VCUSTOMER_NAME, VCUSTOMER_LNAME," +
        "       VCOMPANY_NAME, NINDIVIDUAL_OR_COMPANY, DSUBSCRIPTION_DATE" +
        "  FROM SCHEMA.CUSTOMER CUST" +
        " WHERE     DSUBSCRIPTION_DATE >= :paramDate" +
        "       AND NINDIVIDUAL_OR_COMPANY = :paramIndOrComp" +
        "       AND ROWNUM < 1000", nativeQuery =  true)
List<Customer> getCustomers(Date subsDate, int indOrComp);
}

If you need to call Stored Procedure it is also similar to querying a table. We create our Entity like a database table and Repository class to call it.

     Java 
   
xxxxxxxxxx
 
package com.compmany.xxapp.xx.repository;
/**
 necessary imports
*/
import org.springframework.data.jpa.repository.query.Procedure;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;
import java.math.BigDecimal;
import java.sql.Date;
public interface ICustomerTypeRepository extends CrudRepository<CustomerTypeProc,Long> {
    @Procedure(name  = "isIndOrComp")
    int inProvision(@Param("p_customer_id") Long customerId,
                    @Param("p_customer_type") Integer customerType);
}

I hope everything goes well, thanks a lot...

An Implementation of Spring Boot With Spring Data JPA

An Implementation of Spring Boot With Spring Data JPA

Check out this tutorial on how to get started building a Spring Boot application with Spring Data JPA.

Further Reading

Java Partner Resources

{{ editionName }}

{{ parent.title || parent.header.title}}

{{ parent.linkDescription }}

An Implementation of Spring Boot With Spring Data JPA

An Implementation of Spring Boot With Spring Data JPA

Check out this tutorial on how to get started building a Spring Boot application with Spring Data JPA.

Further Reading

Like This Article? Read More From DZone

Java Partner Resources

{{ editionName }}

{{ parent.title || parent.header.title}}

{{ parent.linkDescription }}