Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Slow Hibernate Save

 
Mike London
Ranch Hand
Posts: 1224
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I have a simple JSP page that saves contact information. It's just a single table that saves user fields from query parameters on the JSP form. I'm using all the hibernate defaults and am using the C3PO connection pool.

When the user hits submit, however, there's about a 5 second delay before the page is done and is completely refreshed. Looking at the log file, I don't see anything obvious.

Not sure what to try. Is it Hibernate, MYSQL, the server, or something else?

Any advice how to debug this type of Hibernate issue, if it is one that is, would be appreciated.

Thanks.

-- M

Here are some basic log entries.

12 Jul 2009 06:38:20,282INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
12 Jul 2009 06:38:20,344INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
12 Jul 2009 06:38:20,344INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
12 Jul 2009 06:38:20,344INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
12 Jul 2009 06:38:20,344INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
12 Jul 2009 06:38:20,346INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
12 Jul 2009 06:38:20,346INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Connection release mode: auto
12 Jul 2009 06:38:20,346INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
12 Jul 2009 06:38:20,347INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
12 Jul 2009 06:38:20,347INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
12 Jul 2009 06:38:20,348INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
12 Jul 2009 06:38:20,348INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
12 Jul 2009 06:38:20,348INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
12 Jul 2009 06:38:20,348INFO TP-Processor3 org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
12 Jul 2009 06:38:20,379INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
12 Jul 2009 06:38:20,380INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
12 Jul 2009 06:38:20,380INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
12 Jul 2009 06:38:20,380INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Query cache: disabled
12 Jul 2009 06:38:20,380INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
12 Jul 2009 06:38:20,380INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
12 Jul 2009 06:38:20,380INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
12 Jul 2009 06:38:20,381INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
12 Jul 2009 06:38:20,437INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Statistics: disabled
12 Jul 2009 06:38:20,696INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
12 Jul 2009 06:38:20,696INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
12 Jul 2009 06:38:20,696INFO TP-Processor3 org.hibernate.cfg.SettingsFactory - Named query checking : enabled
12 Jul 2009 06:38:20,696INFO TP-Processor3 org.hibernate.impl.SessionFactoryImpl - building session factory
12 Jul 2009 06:38:20,941INFO TP-Processor3 org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic