verbose log
jnl1 Sep 16, 2008 5:47 PMhi 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/