Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Loging SQL to a file
Loging SQL to a file [message #988720] Sat, 01 December 2012 22:44 Go to next message
Anis Malik is currently offline Anis Malik
Messages: 1
Registered: December 2012
Junior Member
Hi

I need help with configuration settings for logging SQL statements. If I use the Default Logger, the INPUT statements are displayed on the console. But when I change the configuration setting to output the logs to file, EclipseLink no longer logs the INPUT statements...

I would be very grateful if someone could provide me guidance as to what I need to do to get this fixed.

-Anis

I have provided my persistence.xml below:

<?xml version="1.0" encoding="UTF-8"?>
<persistence 
version="1.0">
    <persistence-unit name="PerformanceMonitoring" transaction-type="JTA">
        <description>PerformanceMoniotring</description>
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
        <jta-data-source>MonitoringXA</jta-data-source>
        <non-jta-data-source>MonitoringNonXA</non-jta-data-source>        
        <jar-file>monitored_activities_analyzer_mdb.jar</jar-file>
        <class>org.company.MonitoredActivityVO</class>
        <class>org.company.MonitoringSystemProperty</class>
        <class>org.company.MonitoredActivityThreshold</class>
        <properties>
        	<property name="eclipselink.logging.file" value="./monitoring.log"/>
         	<property name="eclipselink.logging.level" value="FINEST" />
			<property name="eclipselink.logging.level.sql" value="FINE" />
			<property name="eclipselink.logging.parameters" value="true"/>			
			<property name="eclipselink.logging.level.connection" value="FINE" />
			<property name="eclipselink.logging.level.cache" value="FINE" />
			<property name="eclipselink.logging.level.sequencing" value="FINE" />
			<property name="eclipselink.logging.level.transaction" value="FINE" />
			<property name="eclipselink.logging.level.query" value="FINEST" />			         	
      	</properties>                
    </persistence-unit>
</persistence>
Re: Loging SQL to a file [message #989100 is a reply to message #988720] Tue, 04 December 2012 15:37 Go to previous messageGo to next message
James Sutherland is currently offline James Sutherland
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

What are the INPUT statements?

James : Wiki : Book : Blog : Twitter
Re: Loging SQL to a file [message #989615 is a reply to message #989100] Thu, 06 December 2012 23:21 Go to previous message
J LM is currently offline J LM
Messages: 11
Registered: December 2012
Junior Member
Do you mean binding in case of prepared statements ?
Previous Topic:@CascadeOnDelete
Next Topic:eclipselink.ddl-generation and JTA datasources
Goto Forum:
  


Current Time: Sun Sep 21 16:23:19 GMT 2014

Powered by FUDForum. Page generated in 0.01881 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software