Spring Boot SQL 보기 옵션 정리

SQL 보기

• Hibernate의 DB에 날리는 모든 쿼리(DDL, DML)를 보여준다.

// application.yml
spring:
	jpa:
    	properties:
        	hibernate:
            	show_sql: true

SQL 예쁘게 보기

// application.yml
spring:
	jpa:
    	properties:
        	hibernate:
            	format_sql: true

추가적인 주석을 표시하기

// application.yml
spring:
	jpa:
    	properties:
        	hibernate:
            	use_sql_comments: true

• 바뀐 주석

/* select
	generatedAlias0
from
	User as generatedAlias0
where
	generatedAlias0.name=:param0 */

select 
	user0_.id as id1_0_,
    user0_.age as age2_0_,
    user0_.name as name3_0_
from
	user user0_
where
	user0_.name=?

?에 어떤 값이 들어갔는지 확인하기

// application.yml
logging:
	level:
    	org:
        	hibernate:
            	type:
                	descriptor:
                    	sql: trace

• 결과

/* select
	generatedAlias0
from
	User as generatedAlias0
where
	generatedAlias0.name=:param0 */

select 
	user0_.id as id1_0_,
    user0_.age as age2_0_,
    user0_.name as name3_0_
from
	user user0_
where
	user0_.name=?
    
binding parameter [1] as [VARCHAR] - [홍길동]
extracted value ([id1_0_] : [BIGINT]) - [1]
extracted value ([age2_0_] : [INTEGER]) - [15]
extracted value ([name3_0_] : [VARCHAR]) - [홍길동]

모두 적용하기

/application.yml

spring:
	jpa:
    	properties:
        	hibernate:
            	show_sql: true
                format_sql: true
                use_sql_comments: true
logging:
	level:
    	org:
        	hibernate:
            	type:
                	descriptor:
                    	sql: trace