Re: [eclipselink-users] Logging SQL results and more

["Joe Mc." <m_joe_c@xxxxxxxxxxx>]

Hi,

I am using EntityManager.find().
Code-snippet:

@PersistenceContext
public void setEntityManager(EntityManager anEM) {
     this.em = anEM;
}

public Customer findById(Integer id) {
      log.info("findById(): " + id);
		
      log.info("1.find...");
      // to test the 1level cache
      em.find(Customer.class, id);
		
      log.info("2.find...");
      return em.find(Customer.class, id);
}

log is from type log4j.

I tested now the log level "OFF"
<property name="eclipselink.logging.level" value="OFF" />
however, I see the same output.

Thanks for taking this trouble!

Mc. Joe




tware wrote:
> 
> Hi Joe,
> 
>    What code are you running for #2 below.  I just want to make sure that 
> messages below the FINE level are expected.
> 
> BTW: the default logging level is INFO, so the fact that you are seeing
> messages 
> below the INFO level indicates your logging settings are having some
> effect.
> 
> -Tom
> 
> Joe Mc. wrote:
>> Hi Tom,
>> 
>> thanks for your response.
>> My intent is/are:
>> - see every interaction on the first and second level cache. (to know, if
>> the data is retrieved from the first or second level cache or db)
>> - transaction interaction (Unit of Work etc.)
>> 
>> Any adjustments on 
>> <property name="eclipselink.logging.level" value="FINEST" />
>> has no effects.
>> I set the value from SERVER, over WARNING to FINER/FINEST/ALL. I see
>> always
>> the same set of logs.
>> See here some examples (using code paste service):
>> 1. On startup
>> http://rafb.net/p/XD1JUB13.html
>> 
>> 2. Selecting one item from the List
>> http://rafb.net/p/rMq3xb63.html
>> 
>> I never saw some "[EL Finer]" or better.
>> 
>> And yes, I am using the right PU. I see in the logfiles the name of the
>> PU
>> and I get some Exception that no TimeLoadWeaver is found, if I remove the
>> following line:
>> <property name="eclipselink.weaving" value="static" />
>> 
>> 
>> Maybe I am on the wrong way, and it is not possible to see more output?!
>> 
>> Best regards!
>> 
>> Mc. Joe
>> 
>> 
>> tware wrote:
>>> Hi Joe,
>>>
>>>    It is not clear to me what the problem you are seeing is.  Based on
>>> my 
>>> reading, you are not seeing logging messages at a level lower than FINE. 
>>> Is 
>>> that the issue?  If not, can you provide a specific description of the
>>> issue.
>>>
>>>    Assuming your properties are setup properly in your persistence.xml,
>>> I
>>> expect 
>>> setting eclipselink.logging.level to FINEST will result in getting
>>> FINEST
>>> level 
>>> logging.  Note: There is a limited amount of information logged at the
>>> FINEST 
>>> level in EclipseLink.  Significantly more logging occurs at the FINER
>>> level.
>>>
>>>    One thing you might want to try is to remove a couple of the space
>>> from
>>> your 
>>> xml - some parsers are quite picky:
>>>
>>> <property name="eclipselink.logging.level" value="FINEST" />
>>>
>>>    Assuming that does not help, what code are you running?  What do you
>>> expect 
>>> to see that is not shown?
>>>
>>> -Tom
>>>
>>> Joe Mc. wrote:
>>>> Hi folks,
>>>>
>>>> I am using this thread, cause the context of my current problem is the
>>>> same.
>>>>
>>>> I am playing with the logging properties of EclipseLink 1.0 and 1.0.2,
>>>> with
>>>> no success.
>>>> Some settings has no effects.
>>>> I use at the moment in the persistence.xml:
>>>>
>>>> < property name="eclipselink.weaving" value="static" / >
>>>> < property name="eclipselink.logging.level.sql" value="FINEST" / >
>>>> < property name="eclipselink.logging.level" value="FINEST" / >
>>>> < property name="eclipselink.logging.level.cache" value="FINEST" / >
>>>> 			
>>>> < property name="eclipselink.session.customizer"
>>>> value="com...CustomizerLog"
>>>> />
>>>>
>>>>
>>>> I see without the Session Customizer only "[EL Fine]" declared output,
>>>> nothing more.
>>>> However, I will see every interaction with 
>>>> - the database
>>>> - 1level cache
>>>> - 2level cache
>>>> - everything (ok, the raw database response is not necessary ;-)
>>>>
>>>> that means I will see the "FINEST" output.
>>>>
>>>> Does any other configuration is needed?
>>>> Does is it really work? (I saw some bug reports in this context)
>>>>
>>>> Maybe, someone has any hints 
>>>>
>>>> Thanks in advance!
>>>>
>>>> Mc. Joe
>>>>
>>>>
>>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>> 
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Logging-SQL-results-tp19600126p22084696.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.