Eclipse Community Forums: EclipseLink » Logging sql with logback

Help

Home

Home » Eclipse Projects » EclipseLink » Logging sql with logback(Logging sql with logback)

Show: Today's Messages :: Show Polls :: Message Navigator

Logging sql with logback [message #718154]

Tue, 23 August 2011 08:37

klind Mising name
Messages: 5
Registered: August 2011

Junior Member

Weblogic 10.3.0.0
Eclipselink 2.1.0
logback 0.9.21
slf4j 1.6.0

I would like to log the jpa sql using the logback configuration.
And be able to change the eclipselink log level on the fly.

Anyone knows how to do that ???

Report message to a moderator

Re: Logging sql with logback [message #720498 is a reply to message #718154]

Tue, 30 August 2011 13:58

James Sutherland
Messages: 1834
Registered: July 2009

Senior Member

James : Wiki : Book : Blog

Report message to a moderator

(no subject) [message #720499 is a reply to message #718154]

Tue, 30 August 2011 13:58

James
Messages: 272
Registered: July 2009

Senior Member

You can implement your own logger to integrate with a third party logging service.

See,
http://wiki.eclipse.org/EclipseLink/Examples/JPA/CustomLogger

http://wiki.eclipse.org/EclipseLink/Examples/Foundation/Logging
--
James : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/

Report message to a moderator

Re: Logging sql with logback [message #890115 is a reply to message #718154]

Thu, 21 June 2012 03:49

Tom Wald
Messages: 1
Registered: June 2012

Junior Member

A nice developer (Miguel Angel Sosvilla Luis) has written a class to do this. I can't post links as I'm new but search for

gist: 1325764

And you'll find it on github.

And configure it something like this in your persistence.xml

<properties>
	<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
	<property name="javax.persistence.jdbc.url"  value="jdbc:mysql://localhost:3306/dbname" />
	<property name="javax.persistence.jdbc.user" value="root" />
	<property name="javax.persistence.jdbc.password" value="" />
	<property name="eclipselink.target-database" value="MySQL"/>
	<property name="eclipselink.logging.level" value="FINE"/>
	<property name="eclipselink.logging.parameters" value="true"/>
	<property name="eclipselink.logging.timestamp" value="false"/>
	<property name="eclipselink.logging.logger" value="yourpackage.Slf4jSessionLogger"/>
</properties>

Report message to a moderator

Previous Topic:	fixed timestamp for start/end values for historical data
Next Topic:	exclude-unlisted-classes=false in Equinox OSGI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 01:09:15 EDT 2013