1 Reply Latest reply on Sep 17, 2008 10:30 AM by erasmo2 marciano2

    verbose log

    Jon Loe Newbie

      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/