topic turn off sql logs in Alfresco Archive

turn off sql logs

cutout33 — Fri, 28 Dec 2012 17:47:08 GMT

Hello,I upgraded my application to hibernate 4 and since then my logs are overwhilmed with a query on ACT_RU_JOB, if I set hibernate.show_sql=false‍it stops but then it stops my application sql too!is there a way to turn this off for activiti alone?thanks in advance

Re: turn off sql logs

ronald_van_kuij — Fri, 28 Dec 2012 17:55:53 GMT

Activiti uses mybatis, not hibernate…

Re: turn off sql logs

cutout33 — Fri, 28 Dec 2012 18:14:49 GMT

am not sure but this is not a query I have made and it is just keep running, it does not stop! it runs every other second.

Hibernate:
    select
        RES.*
    from
        ACT_RU_JOB RES
    LEFT OUTER JOIN
        ACT_RU_EXECUTION PI
            ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
    where
        (
            RETRIES_ > 0
        )
        and (
            DUEDATE_ is null
            or DUEDATE_ <= ?
        )
        and (
            LOCK_OWNER_ is null
            or LOCK_EXP_TIME_ <= ?
        )
        and (
            (
                RES.EXECUTION_ID_ is null
            )
            or          (
                PI.SUSPENSION_STATE_ = 1
            )
        )       LIMIT ? OFFSET ?

I thought it is an activiti query because it is on activiti table 😕

Re: turn off sql logs

ronald_van_kuij — Fri, 28 Dec 2012 20:25:15 GMT

Oh, yes. That is an activiti query… It queries for jobs to be executed…

Re: turn off sql logs

cutout33 — Sat, 29 Dec 2012 05:38:39 GMT

OK then, how can I stop it in the logs, it is killing me!

Re: turn off sql logs

jbarrez — Thu, 03 Jan 2013 09:32:07 GMT

Like Ronald says, we don't use Hibernate.

If you are using Activiti: simply edit your logging.properties file and set the level higher. or tweak the log level of the mybatis logger.

Re: turn off sql logs

lsjunior — Mon, 05 May 2014 18:46:17 GMT

The problem is that you application uses Hibernate and showSql property is active.
Disabling Hibernate logging solves your problem.

In Hibernate properties/persistence.xml:
<code>
hibernate.show_sql = false or <property name="hibernate.show_sql" value="false" />
</code>

In Spring:
<code>
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="showSql" value="false" />
…
</bean>
</code>