nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

turn off sql logs

cutout33

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

Find more posts tagged with

Comments

ronald_van_kuij

Activiti uses mybatis, not hibernate…

cutout33

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 😕

ronald_van_kuij

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

cutout33

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

jbarrez

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.

lsjunior

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>