OJB + log4j com problemas para mostrar dados e data

1 resposta
rodsm

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.

#<!--
#/* 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

1 Resposta

rodsm

Ninguém pode me ajudar?

Criado 16 de dezembro de 2008
Ultima resposta 24 de dez. de 2008
Respostas 1
Participantes 1