topic Verbose JPA Configuration in Alfresco Archive

Verbose JPA Configuration

jenniferritz — Mon, 25 Mar 2013 19:37:19 GMT

Newbie question: We recently switched to utilizing JPA for data access within Activiti, and our output console started getting very verbose when executing Activiti SQL. We are using slf4j and log4j. I have tried limiting the logging level for both Activiti and Hibernate JPA and have not been able

Re: Verbose JPA Configuration

gokceng1 — Tue, 26 Mar 2013 01:14:29 GMT

Maybe this one?

log4j.logger.org.apache.ibatis.level=INFO

Re: Verbose JPA Configuration

jbarrez — Tue, 26 Mar 2013 09:53:19 GMT

Indeed, check the log4j.properties logging file and set to the appropriate level (eg WARN if you really want to limit the logging)

Re: Verbose JPA Configuration

jenniferritz — Tue, 26 Mar 2013 11:41:52 GMT

Thanks for the quick responses. Both of which I had tried, but we did find the culprit. ShowSQL was set to TRUE on the Hibernate configuration.

Setting it to false solved our issue.

<!– Configure the JPA Vendor –>
<bean id="hibernateJpaVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="databasePlatform" value="org.hibernate.dialect.Oracle10gDialect" />
<property name="showSql" value="true" />
<property name="generateDdl" value="false" />
</bean>

Re: Verbose JPA Configuration

frederikherema1 — Wed, 27 Mar 2013 12:02:54 GMT

Nice to see your issue got solved.