How can i get my query execution time in logging

Question

I want to know query execution time so i follow this answer

   <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
      <property name="persistenceUnitName" value="persistenceYous" />
      <property name="dataSource" ref="dataSource" />
      <property name="packagesToScan" value="persistence" />
      <property name="jpaVendorAdapter" ref="jpaVendorAdapter" />

   </bean>

 <bean id="jpaVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
    <property name="showSql" value="true" />
    <property name="generate_statistics" value="true" />
</bean>

but i got this error

Caused by: org.springframework.beans.NotWritablePropertyException: 
Invalid property 'generate_statistics' of bean class [org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter]: 
Bean property 'generate_statistics' is not writable or has an invalid setter method. 
Does the parameter type of the setter match the return type of the getter?

Ralph · Accepted Answer · 2014-12-25T11:37:21.253

2

Have you tried to write the property into the persistence.xml instead? (This is only a guess)

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"      
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence 
                       http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit ...>
    ...    
    <properties>
        ...
        <property name="hibernate.generate_statistics" value="true" />
    </properties>
    ...
</persistence-unit>

without persistence.xml:

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
   ...
   <property name="jpaVendorAdapter" .../>
   <property name="jpaPropertyMap">
      <map>
        <entry key="hibernate.generate_statistics" value="true"/>
      </map>
   </property>
</bean>

edited Dec 25 '14 at 11:37

answered Dec 25 '14 at 11:14

Ralph

118,862
56
287
383

I don't use a `persistence.xml` , i have to ? – Hayi Dec 25 '14 at 11:24
I use directly `` – Hayi Dec 25 '14 at 11:27
persistence.xml is only one way to set the generic properties, but I would give it a try – Ralph Dec 25 '14 at 11:30
@Youssef: I added an example of how to set the properites without persistence.xml – Ralph Dec 25 '14 at 11:37
thanks it work now but would be better if i use a separate file ? – Hayi Dec 25 '14 at 11:51
1

Thats up to you - a seperate file would spread the information about different places/files, but if this are a lot of properties, then this is often better to have them in different files instead of in one. – Ralph Dec 25 '14 at 11:54

How can i get my query execution time in logging

1 Answers1