[jboss-user] [Beginners Corner] - verbose log

[jnl1]

hi all...

   my app is dying around the time it hits the db.  i changed the log4j level from INFO to DEBUG for my console appender to get more information from jboss, but no luck.  i'm using jdk1.5 and jboss 4.2.3.  below is the log.  i'm wondering if someone can tell me how to get more debug, or what the problem could be.  it's difficult to solve without knowing more about the problem.
   My initial web page just displays a 404 with the context (/datastandards) followed by a null:


  | http://127.0.0.1:8087/datastandardsnull
  | 

I print out the hibernate sql, but nothing shows up in the log.  so, i thought the problem is related to the connection.

This was working fine.  it was only after updating to a later version of hibernate  (3.1.3 -> 3.2.6.ga) and jboss (4.0.3sp1 -> 4.3.2.ga) and oracle dialect.  i put debug between 2 operations that hit the db.  the first one outputs to the log, but the second one doesn't.  which is another indication that it's connection related.


thanks


  | 15:05:36,365 INFO  [STDOUT] 15:05:36,365 INFO  [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 11.1.0.6.0-Pr
  | oduction+
  | 15:05:36,389 INFO  [STDOUT] 15:05:36,389 INFO  [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect
  | 15:05:36,402 INFO  [STDOUT] 15:05:36,402 INFO  [TransactionFactoryFactory] Using default transaction strategy (direct JD
  | BC transactions)
  | 15:05:36,407 INFO  [STDOUT] 15:05:36,407 INFO  [TransactionManagerLookupFactory] No TransactionManagerLookup configured
  | (in JTA environment, use of read-write or transactional second-level cache is not recommended)
  | 15:05:36,408 INFO  [STDOUT] 15:05:36,408 INFO  [SettingsFactory] Automatic flush during beforeCompletion(): disabled
  | 15:05:36,409 INFO  [STDOUT] 15:05:36,409 INFO  [SettingsFactory] Automatic session close at end of transaction: disabled
  | 
  | 15:05:36,410 INFO  [STDOUT] 15:05:36,410 INFO  [SettingsFactory] JDBC batch size: 15
  | 15:05:36,411 INFO  [STDOUT] 15:05:36,411 INFO  [SettingsFactory] JDBC batch updates for versioned data: disabled
  | 15:05:36,412 INFO  [STDOUT] 15:05:36,412 INFO  [SettingsFactory] Scrollable result sets: enabled
  | 15:05:36,415 INFO  [STDOUT] 15:05:36,415 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
  | 15:05:36,416 INFO  [STDOUT] 15:05:36,415 INFO  [SettingsFactory] Connection release mode: on_close
  | 15:05:36,416 INFO  [STDOUT] 15:05:36,416 INFO  [SettingsFactory] Default batch fetch size: 1
  | 15:05:36,417 INFO  [STDOUT] 15:05:36,417 INFO  [SettingsFactory] Generate SQL with comments: disabled
  | 15:05:36,417 INFO  [STDOUT] 15:05:36,417 INFO  [SettingsFactory] Order SQL updates by primary key: disabled
  | 15:05:36,418 INFO  [STDOUT] 15:05:36,418 INFO  [SettingsFactory] Order SQL inserts for batching: disabled
  | 15:05:36,418 INFO  [STDOUT] 15:05:36,418 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTransla
  | torFactory
  | 15:05:36,424 INFO  [STDOUT] 15:05:36,424 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
  | 15:05:36,425 INFO  [STDOUT] 15:05:36,425 INFO  [SettingsFactory] Query language substitutions: {}
  | 15:05:36,426 INFO  [STDOUT] 15:05:36,426 INFO  [SettingsFactory] JPA-QL strict compliance: disabled
  | 15:05:36,427 INFO  [STDOUT] 15:05:36,427 INFO  [SettingsFactory] Second-level cache: enabled
  | 15:05:36,428 INFO  [STDOUT] 15:05:36,428 INFO  [SettingsFactory] Query cache: disabled
  | 15:05:36,429 INFO  [STDOUT] 15:05:36,429 INFO  [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
  | 15:05:36,436 INFO  [STDOUT] 15:05:36,436 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled
  | 15:05:36,437 INFO  [STDOUT] 15:05:36,437 INFO  [SettingsFactory] Structured second-level cache entries: disabled
  | 15:05:36,445 INFO  [STDOUT] 15:05:36,445 INFO  [SettingsFactory] Statistics: disabled
  | 15:05:36,445 INFO  [STDOUT] 15:05:36,445 INFO  [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
  | 15:05:36,446 INFO  [STDOUT] 15:05:36,446 INFO  [SettingsFactory] Default entity-mode: pojo
  | 15:05:36,447 INFO  [STDOUT] 15:05:36,447 INFO  [SettingsFactory] Named query checking : enabled
  | 15:05:36,492 INFO  [STDOUT] 15:05:36,492 INFO  [SessionFactoryImpl] building session factory
  | 15:05:37,184 INFO  [STDOUT] 15:05:37,184 INFO  [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
  | 15:05:38,001 INFO  [STDOUT] 15:05:38,000 INFO  [DefaultListableBeanFactory] Destroying singletons in {org.springframewor
  | k.beans.factory.support.DefaultListableBeanFactory defining beans [messageSource,sessionFactory,hibernateInterceptor,sta
  | ndardDao,statusDao,codeValueDao,proposalDao,standardTypeDao,groupDao,organizationDao,subCategoryDao,categoryDao,organiza
  | tionCategoryDao,proposalTypeDao,dataStandardsService,abstractService,codeValueManager,dataSource,transactionManager]; ro
  | ot of BeanFactory hierarchy}
  | 15:05:38,008 INFO  [STDOUT] 15:05:38,008 INFO  [LocalSessionFactoryBean] Closing Hibernate SessionFactory
  | 15:05:38,009 INFO  [STDOUT] 15:05:38,009 INFO  [SessionFactoryImpl] closing
  | 15:05:38,013 INFO  [STDOUT] 15:05:38,013 INFO  [DefaultListableBeanFactory] Destroying singletons in {org.springframewor
  | k.beans.factory.support.DefaultListableBeanFactory defining beans [beanRefFactory,beanRefFactoryEjb]; root of BeanFactor
  | y hierarchy}
  | 15:05:41,870 INFO  [Server] Runtime shutdown hook called, forceHalt: true
  | 15:05:41,872 INFO  [Server] JBoss SHUTDOWN: Undeploying all packages
  | 15:05:41,879 INFO  [TomcatDeployer] undeploy, ctxPath=/datastandards-ws, warUrl=.../tmp/deploy/tmp24399datastandards-1.1
  | .2.ear-contents/datastandards-webservice-1.1.2-exp.war/
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4176942#4176942

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4176942