Announcement Announcement Module
Collapse
No announcement yet.
hibernate ConnectionManger loop when navigating to Roo-created update.jspx Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • hibernate ConnectionManger loop when navigating to Roo-created update.jspx

    When navigating from a Roo created list.jspx to the update.jspx, I am getting dozens and dozens of these logged items:

    Code:
    012-02-07 17:37:34,514 [tomcat-http--29] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
    2012-02-07 17:37:34,902 [tomcat-http--29] TRACE org.hibernate.jdbc.JDBCContext - after autocommit
    Here is the persistence.xml:
    Code:
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.0" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
    <persistence-unit name="persistenceUnit" transaction-type="RESOURCE_LOCAL">
            <provider>org.hibernate.ejb.HibernatePersistence</provider>
            <properties>
                <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
                <!-- value="create" to build a new database on each run; value="update" to modify an existing database; value="create-drop" means the same as "create" but also drops tables when Hibernate closes; value="validate" makes no changes to the database -->
                <property name="hibernate.hbm2ddl.auto" value="none"/>
                <property name="hibernate.ejb.naming_strategy" value="org.hibernate.cfg.ImprovedNamingStrategy"/>
                <property name="hibernate.connection.charSet" value="UTF-8"/>
                <property name = "hibernate.show_sql" value = "true" />
                <property name = "hibernate.connection.autocommit" value = "false" />
                <!-- Uncomment the following two properties for JBoss only -->
                <!-- property name="hibernate.validator.apply_to_ddl" value="false" /-->
                <!-- property name="hibernate.validator.autoregister_listeners" value="false" /-->
            </properties>
        </persistence-unit>
    </persistence>
    Here is the log4j:
    Code:
    #Updated at Tue Feb 07 16:10:10 CST 2012
    #Tue Feb 07 16:10:10 CST 2012
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.R.File=application.log
    log4j.rootLogger=error, stdout
    log4j.appender.R.MaxFileSize=100KB
    log4j.appender.R.layout=org.apache.log4j.PatternLayout
    log4j.appender.R.MaxBackupIndex=1
    log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n
    log4j.appender.stdout.layout.ConversionPattern=%d [%t] %-5p %c - %m%n
    log4j.logger.org.hibernate.SQL=ALL
    log4j.logger.org.hibernate.type=ALL
    log4j.logger.org.hibernate.jdbc=ALL
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.R=org.apache.log4j.RollingFileAppender
    I added the hibernate.show_sql and hibernate.connection.autocommit above and beyond what Roo created.

    Transitioning to the update view takes over 30 seconds!!!!

    Any ideas as to to how to make this run faster? Whats going on with the connections? This is all pretty much standard Roo stuff except for some custom converters.
Working...
X