Pessoal estou tendo problemas com o log4j.
O log que está me mostrando, está
imprimindo interrogações em vez dos valores dos selects inserts etc.
Já tentei configurar o meu log4j.properties mas nada, alguém pode me dar um help.
Estou utilizando o OJB para persistencia de dados.
Uma outra coisa é a data que não aparece.
Exemplo de log
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL:
SELECT A0.NR_HISTORICO_USUARIO,A0.CD_USUARIO_INTERNO,A0.NR_HISTORICO_GRUPO,A0.CD_PROJETO,A0.CD_STATUS,A0.CD_SUBGRUPO,A0.DT_HORA,A0.DS_PARECER
FROM INBOX_USUARIO A0
WHERE ((A0.NR_HISTORICO_GRUPO = ?) AND A0.CD_PROJETO = ?) AND A0.CD_SUBGRUPO = ? ORDER BY 7
Segue o .properties para verem.
[code]#<!–
#/* Copyright 2002-2004 The Apache Software Foundation
*
* Licensed under the Apache License, Version 2.0 (the “License”);
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an “AS IS” BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
#–>
An example log4j configuration file that outputs both to System.out
and a file named ‘org.apache.ojb.log’.
For the general syntax of property based configuration files see the
documenation of org.apache.log4j.PropertyConfigurator.
WARNING: Location information can be useful but is very costly in
terms of computation.
The root category uses the appenders called A1 and A2. Since no
priority is set, the root category assumes the default which is
DEBUG
log4j.rootCategory=WARN, A1, A2
The boot log level used to initialize logging
log4j.logger.BOOT=INFO
The Default Logger instance used within OJB
log4j.logger.DEFAULT=WARN
PB-api and Kernel
-----------------
Logger for PB-api base classes
log4j.logger.org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl=WARN
log4j.logger.org.apache.ojb.broker.core.PersistenceBrokerFactorySyncImpl=WARN
log4j.logger.org.apache.ojb.broker.core.PersistenceBrokerImpl=WARN
Logger for metadata classes, useful for debugging parsing of repository.xml!
persistence capable object metadata
log4j.logger.org.apache.ojb.broker.metadata.DescriptorRepository=WARN
log4j.logger.org.apache.ojb.broker.metadata.RepositoryXmlHandler=WARN
log4j.logger.org.apache.ojb.broker.metadata.ConnectionDescriptorXmlHandler=WARN
log4j.logger.org.apache.ojb.broker.metadata.RepositoryPersistor=WARN
log4j.logger.org.apache.ojb.broker.metadata.SuperReferenceDescriptor$SuperReferenceField=WARN
Logger for jdbc access querying and object materialization, useful
for debugging JDBC related problems
log4j.logger.org.apache.ojb.broker.accesslayer.JdbcAccessImpl=WARN
log4j.logger.org.apache.ojb.broker.accesslayer.RsIterator=WARN
log4j.logger.org.apache.ojb.broker.accesslayer.StatementsForClassImpl=WARN
log4j.logger.org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl=DEBUG
Logger for connection handling
log4j.logger.org.apache.ojb.broker.accesslayer.ConnectionManagerImpl=WARN
log4j.logger.org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl=WARN
log4j.logger.org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl=WARN
log4j.logger.org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl=WARN
Logger for object caching
log4j.logger.org.apache.ojb.broker.cache.CacheDistributor=WARN
log4j.logger.org.apache.ojb.broker.cache.MaterializationCache=WARN
log4j.logger.org.apache.ojb.broker.cache.ObjectCacheDefaultImpl=WARN
log4j.logger.org.apache.ojb.broker.cache.ObjectCacheTwoLevelImpl=WARN
Logger for Oracle9i platform, useful for tracing failing Oracle-extensions or large LOB-support
log4j.logger.org.apache.ojb.broker.platforms.PlatformOracle9iImpl=DEBUG
Logger for proxy classes
log4j.logger.org.apache.ojb.broker.core.proxy.IndirectionHandlerJDKImpl=WARN
log4j.logger.org.apache.ojb.broker.core.proxy.IndirectionHandlerCGLIBImpl=DEBUG
log4j.logger.org.apache.ojb.broker.core.proxy.ProxyFactoryJDKImpl=WARN
log4j.logger.org.apache.ojb.broker.core.proxy.ProxyFactoryCGLIBImpl=DEBUG
OJB locking implementations
log4j.logger.org.apache.ojb.broker.locking.LockManagerInMemoryImpl=WARN
log4j.logger.org.apache.ojb.broker.locking.LockManagerCommonsImpl=WARN
log4j.logger.org.apache.ojb.broker.locking.LockManagerRemoteImpl=WARN
log4j.logger.org.apache.ojb.broker.locking.CommonsOJBLockManager=WARN
odmg-api
--------
log4j.logger.org.apache.ojb.odmg.TransactionImpl=WARN
log4j.logger.org.apache.ojb.odmg.J2EETransactionImpl=WARN
log4j.logger.org.apache.ojb.odmg.ImplementationImpl=WARN
log4j.logger.org.apache.ojb.odmg.DatabaseImpl=WARN
log4j.logger.org.apache.ojb.odmg.ObjectEnvelopeTable=WARN
log4j.logger.org.apache.ojb.odmg.ObjectEnvelope=WARN
log4j.logger.org.apache.ojb.odmg.ObjectEnvelopeOrdering=WARN
log4j.logger.org.apache.ojb.odmg.LocalTxManager=DEBUG
log4j.logger.org.apache.ojb.odmg.JTATxManager=WARN
Special Logger categories used in test suite
Logger for the performance tests
log4j.logger.performance=INFO
Logger for the failover tests
log4j.logger.failover=INFO
A1 is set to be ConsoleAppender sending its output to System.out
log4j.appender.A1=org.apache.log4j.ConsoleAppender
A1 uses PatternLayout.
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
The conversion pattern consists of date in ISO8601 format, priority,
thread name, category name truncated to its rightmost two components
and left justified to 17 characters, location information consisting
of file name (padded to 13 characters) and line number, nested
diagnostic context, the and the application supplied message
#log4j.appender.A1.layout.ConversionPattern=%-6r %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n
use a simpler output format
log4j.appender.A1.layout.ConversionPattern=%d{ABSOLUTE} %-5r %-5p [%t] %c{2} - %m%n
Appender A2 writes to the file “org.apache.ojb.log”.
log4j.appender.A2=org.apache.log4j.FileAppender
log4j.appender.A2.File=org.apache.ojb.log
Truncate ‘test’ if it aleady exists.
log4j.appender.A2.Append=false
Appender A2 uses the PatternLayout.
log4j.appender.A2.layout=org.apache.log4j.PatternLayout
log4j.appender.A2.layout.ConversionPattern=%d{ABSOLUTE} %-5r %-5p [%t] %c{2} - %m%n[/code]