Spring JPA

Download file using Angular and Spring Boot

Introduction In this post we will see how to download file using Angular and Spring Boot. There are situations where you need to download file from server or you need to generate report from database and download it. This example may help you in that situation. Here we will fetch records from database and download […]

Spring Boot Data JPA Left, Right, Inner and Cross Join Examples

Introduction This tutorial will show you Spring Boot Data JPA Left, Right, Inner and Cross Join Examples. We will tell you here how to use this example in Spring Boot application, where we will use Spring Data JPA Repository to query our database tables. We will use here custom query using @Query annotation to fetch […]

Spring Data JPA Specification Criteria Query with IN Clause Example

Introduction Spring Data JPA Specification Criteria Query generally used for search functionality on a page where users want to search by giving some inputs. In this example we will use how to use collection or list of input parameters into CriteriaQuery to fetch data from database. Problem and Solution Suppose you have a web page […]

File download example using Spring REST Controller

Introduction File download example using Spring REST Controller will show you how to download a file from any client (browser or any client) and Spring REST service is used as a server side technology for downloading the file. The file may be any type, i.e., such as excel, text, word, pdf etc. Here we will […]

Spring Data JPA Entity Auditing using EntityListeners

Introduction The tutorial Spring Data JPA Entity Auditing using EntityListeners will show you how you persist the audit log using JPA’s built-in functionality. Spring Data  JPA provides sophisticated support to transparently keep track of who created or changed an entity and at what time. To benefit from this functionality you have to equip your entity classes […]

Hibernate UserType Example using Spring Data JPA

In Hibernate UserType Example using Spring Data JPA we will see how Hibernate allows us to implement and use custom types when built-in types do not satisfy an application’s requirements, or when we want to change the default behavior of a built-in type. As you will see, you can easily implement a custom-type class and […]

Spring EnableEncryptableProperties with Jasypt

Spring EnableEncryptableProperties with Jasypt shows an example how to avoid putting clear text password for database connection credentials in properties file. Jasypt means Java simplified encryption. Here we are going to use Spring version 4 with Jasypt (Java simplified encryption). Here we are also going to use Spring Data JPA to perform the data layer […]

Configure JNDI DataSource with Spring Boot

Introduction JNDI data source is very similar to JDBC data source. The JNDI data source accesses a database connection that is pre-defined and configured in the application server and published as a JNDI resource or service. Instead of specifying a driver and database as we do with JDBC data sources, we only need to specify […]

org.hibernate.MappingException: No Dialect mapping for JDBC type

You might have seen similar kind of exception occurred during performing native queries without entity class and this kind of issue may have been occurred in different databases such as MySQL, Oracle, SQL Server, PostgreSQL etc. Depending upon the database vendor you will get error for JDBC types -4, -9, 7 or 2003 etc. It […]

Scroll to top