show the full query using SQLQuery

Question

how to show the full string of a query using SQLQuery. I tried to use getQueryString() but it doesn't show the parameter values in the returned string.

any idea how to display the full query that will be executed on the MySQL DB server?

Query query = session.createSQLQuery(
"select * from stock s where s.stock_code = :stockCode")
.addEntity(Stock.class)
.setParameter("stockCode", "7277");

query.getQueryString(); 
// this will return "select * from stock s where s.stock_code = :stockCode" 
// and I need  "select * from stock s where s.stock_code = 7277"

the code snippet has been added – Java Fan Oct 11 '14 at 18:12 — Java Fan, Oct 11 '14 at 18:12

score 0 · Accepted Answer · edited May 23 '17 at 12:05

0

You can enable logging of the following categories (using a log4j.properties file here):

 log4j.logger.org.hibernate.SQL=DEBUG
 log4j.logger.org.hibernate.type=TRACE

Refer this :

edited May 23 '17 at 12:05

Community

1
1

answered Oct 11 '14 at 18:23

Tejas

1,361
1
13
26

Thanks, this is helpful – Java Fan Oct 11 '14 at 18:39

show the full query using SQLQuery

1 Answers1