[Jpox-issues] [JPOX JIRA] Updated: (NUCACCESS-35) Downgrade non-SQL-statement related log level for DataNucleus.Datastore.* Loggers

[Andy J. (JIRA) <web...@jp...>]

     [ http://www.datanucleus.org/servlet/jira/browse/NUCACCESS-35?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andy Jefferson updated NUCACCESS-35:
------------------------------------

    Priority: Minor  (was: Major)

DataNucleus does not make use of "finer", "finest", "very finest", or other such low JDK1.4 levels. It uses levels that map to Log4J levels ... error, warning, info, debug -> in JDK1.4 logger these are SEVERE, WARNING, INFO, FINE. No plans to support other levels, and the lowest is FINE. Printing out PreparedStatement generation allows timings on how long it takes to get basic JDBC objects

> Downgrade non-SQL-statement related log level for DataNucleus.Datastore.* Loggers
> ---------------------------------------------------------------------------------
>
>                 Key: NUCACCESS-35
>                 URL: http://www.datanucleus.org/servlet/jira/browse/NUCACCESS-35
>             Project: DataNucleus Access Platform
>          Issue Type: Improvement
>    Affects Versions: 1.1.0.m3
>            Reporter: Cyril Bouteille
>            Priority: Minor
>
> DataNucleus.Datastore.Retrieve.level=FINE yields the following 4 log messages per query:
> FINE 10:56:58 SQLController.getStatementForQuery: Retrieving PreparedStatement for connection com.mysql.jdbc.Connection@59050a0
> FINE 10:56:58 SQLController.executeStatementQuery: SELECT THIS.`CLIENT_ID`,THIS.`CREATE_DATE`,THIS.`DESTINATION_TEXT`,THIS.`IS_ACTIVE`,THIS.`LENGTH_DAYS`,THIS.`NAME`,THIS.`START_DATE`,THIS.`UPDATE_DATE`,THIS.`VERSION`,THIS.`VISIBILITY_CODE`,THIS.`ID` FROM `TRIP` THIS WHERE (THIS.`ID`=<5506>)
> FINE 10:56:58 SQLController.executeStatementQuery: Execution Time = 0 ms
> FINE 10:56:58 SQLController.closeStatement: Closing PreparedStatement org.datanucleus.store.rdbms.ParamLoggingPreparedStatement@62114b17
> Only the 2nd one with the SQL statement is really valuable and the rest is kind of noisy IMHO. I wish there was a way to turn those off.
> Is it possible to downgrade the 3 others (or at least the 1s & 4th) to FINER or FINEST log level?
> Thank you,

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://www.datanucleus.org/servlet/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira