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 17:44 Go to previous 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>
 
Read Message
Read Message
Read Message
Previous Topic:@CascadeOnDelete
Next Topic:eclipselink.ddl-generation and JTA datasources
Goto Forum:
  


Current Time: Mon May 20 18:23:52 EDT 2013

Powered by FUDForum. Page generated in 0.01680 seconds