hibernate show_sql value

Question

this is example of how sql is showed when using show_sql=true

Hibernate:
    select
        propertyse0_.entity_name as entity1_3_0_,
        propertyse0_.entity_id as entity2_3_0_,
        propertyse0_.entity_key as entity3_3_0_,
        propertyse0_.key_type as key4_3_0_,
        propertyse0_.boolean_val as boolean5_3_0_,
        propertyse0_.double_val as double6_3_0_,
        propertyse0_.string_val as string7_3_0_,
        propertyse0_.long_val as long8_3_0_,
        propertyse0_.int_val as int9_3_0_,
        propertyse0_.date_val as date10_3_0_
    from
        OS_PROPERTYENTRY propertyse0_
    where
        propertyse0_.entity_name=?
        and propertyse0_.entity_id=?
        and propertyse0_.entity_key=?

possible to show value to gather with the sql rather than '?'

EJB · Accepted Answer · 2010-01-13 10:18:03Z

2

Set your logging leven to "TRACE". In your log4j.properties (assuming your using Log4J):

log4j.logger.org.hibernate=TRACE

Will result in lots of logging tough...

answered Jan 13, 2010 at 10:18

EJB

2,41315 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

skaffman · Accepted Answer · 2010-01-13 10:13:10Z

2

You need to set up your logging framework to log this level of details. See here for the various loggers that Hibernate uses, and how to use them.

The particular one that you want is:

org.hibernate.type - Log all JDBC parameters

answered Jan 13, 2010 at 10:13

skaffman

405k96 gold badges825 silver badges775 bronze badges

Comments

bertolami · Accepted Answer · 2010-01-13 09:54:15Z

0

not directly. you can use log4jdbc to log all the data that is sent over jdbc. It has a logger that inlines the prepared statement values.

answered Jan 13, 2010 at 9:54

bertolami

2,9363 gold badges27 silver badges41 bronze badges

2 Comments

cometta Over a year ago

can elaborate more how to integrate with spring+hibernate existing app

bertolami Over a year ago

I created a proxy for my datasource in spring that added the logger spy of log4jdbc. And I have to admit that this is not done in 10 minutes. However, for my purpose it was worth the effort. But I just included it for my tests and not in the app server.

Collectives™ on Stack Overflow

hibernate show_sql value

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related