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/