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 12: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 17:58

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

Report message to a moderator

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

Tue, 30 August 2011 17: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 07: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: Sun Sep 25 07:25:06 GMT 2016

.:: Contact :: Home ::.