Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
9 subscribers
Views
3119 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hibernate sql logs P6Spy
charlneb
over 8 years ago
I am wondering if someone already install P6Spy?
And how did you proceed ?
Thanks,
Charlène
OriginalPostID-231168
Discussion posts and replies are publicly visible
0
James Carter
Appian Employee
over 8 years ago
Do the native hibernate logging capabilities that can be enabled out of the box meet your needs?
forum.appian.com/.../Logging.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
charlneb
over 8 years ago
The native hibernate logging just display all parameter values as question mark.
We can see generated sql query, but not the data values.
With Hibernate, we are getting this kind of logs:
Hibernate: insert into mkyong.stock_transaction
(CHANGE, CLOSE, DATE, OPEN, STOCK_ID, VOLUME)
values (?, ?, ?, ?, ?, ?)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
James Carter
Appian Employee
over 8 years ago
The second ("TRACE") logger will provide the values. They will be output separately from the example you provide, so cannot easily copy the query into an external client for testing, but at least provides the exact values that were used.
log4j.logger.org.hibernate.type=TRACE
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel