Springboot JPA SQL output

[naresh babu]

Hi ,

 I am developing spring boot app to get an entity  which has join of 3-4 tables.  I enabled sql output in application.properties . But i am seeing only high level SQL . Is there
any way i can print all join queries also when fetching the data :

---------------SQL output --------------------------

select
       parent0_.pk_pk_key as pk__p1_6_,
     from
       mainentity0_
   where
       mainentity0_.pk_emp_key in (
           ? , ? , ? , ? , ?
       )

---------------------------Tables -------------------------------------------------------------------------------------------------------

public class MainEntity {

	@Id
	@Column(name="pk_emp_key")
	 private BigInteger empId ;

	@Column(name="ful_nm")
	 private String  fullName ;
	
	
	@OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, orphanRemoval = true,mappedBy="childTable1FkKey")
   	private List<ChildTable1> childTables1;

	@OneToMany(fetch = FetchType.LAZY,cascade = CascadeType.ALL, orphanRemoval = true,mappedBy="childTable2FkKey")
   	private List<ChildTable2> childTables2;

    @OneToMany(fetch = FetchType.LAZY,cascade = CascadeType.ALL, orphanRemoval = true,mappedBy="childTable3FkKey")
   	private List<ChildTable3> childTables3;

}


public class ChildTable1 {
	
	@Column(name="fk_child_key")
	 private BigInteger childTable1FkKey;

	@Id
	@Column(name="pk_child_pk_key")
	 private String   childTable1PkKey;
	
}

Thanks

[Himai Minh]

Hi,
You may want to use Logger to log the SQL queries. Here is an example https://stackoverflow.com/questions/30118683/how-to-log-sql-statements-in-spring-boot

[Tim Holloway]

If you are using Hibernate JPA, there are a set of logging identifiers that can tell you more than you'll ever want to know about what Hibernate is doing, and yes, there's one that specifically prints out the generated SQL.

Other JPA facilities will generally have similar log options, but since Hibernate is probably the most popular JPA provider, I did want to be specific about it.

[naresh babu]

Thank you! for the inputs.  Springboot is able to log query output when retreiving 1 entity using

repo.findOne(1)

.

But incase of using

 findAll(Iterable idList) 

- its printing only main query . But its not logging mapped Entities SQL queries.

Please update if there is any other way i can get this info

[Tim Holloway]

I'm afraid I don't understand what you just said.

However, the Hibernate SQL log facility does print out the full text of every SQL statement it generates. Spring Boot has nothing to do with that. It works the same everywhere.