<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">

<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>

                                <td>

                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>

                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px;  -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
    Re: how turn off jbpm and hibernate logging?
</h3>
<span style="margin-bottom: 10px;">
    created by <a href="http://community.jboss.org/people/simonbaker">s b</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/587352#587352">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">

<div class="jive-rendered-content"><p> Thanks, I'll try that --&#160; have not&#160; done that as I wanted to control it through the logging system itself if possible.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>Do you know what loggers these properties correspond to?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><strong>&lt;!-- logging properties (begin) --&gt;</strong></p><p><strong>&#160;&#160;&#160; &lt;property name="hibernate.show_sql"&gt;false&lt;/property&gt;</strong></p><p><strong>&#160;&#160;&#160; &lt;property name="hibernate.format_sql"&gt;false&lt;/property&gt;</strong></p><p><strong>&#160;&#160;&#160; &lt;property name="hibernate.use_sql_comments"&gt;false&lt;/property&gt;</strong></p><p><strong>&#160;&#160;&#160; &lt;!-- logging properties (end) --&gt;</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><strong>-------------------------------------------------------</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>Also, do you know where this type of logging is coming from?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p><strong>14:03:39,620 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors</strong><br/><strong>14:03:39,620 [http-443-5] DEBUG HqlSqlBaseWalker : select &lt;&lt; begin [level=1, statement=select]</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromElement : FromClause{level=1} :&#160; org.jbpm.taskmgmt.exe.TaskInstance (ti) -&gt; taskinstan0_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :&#160; ti -&gt; taskinstan0_.ID_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :&#160; ti -&gt; taskinstan0_.ID_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -&gt; actorId (class)]</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : actorId -&gt; <a class="" href="http://community.jboss.org/mailto:org.hibernate.type.StringType@17a8369">org.hibernate.type.StringType@17a8369</a></strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :&#160; ti.actorId -&gt; taskinstan0_.ACTORID_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :&#160; ti -&gt; taskinstan0_.ID_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -&gt; isSuspended (class)]</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : isSuspended -&gt; <a class="jive-link-external-small" href="mailto:org.hibernate.type.BooleanType@1b52eaf">org.hibernate.type.BooleanType@1b52eaf</a></strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :&#160; ti.isSuspended -&gt; taskinstan0_.ISSUSPENDED_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :&#160; ti -&gt; taskinstan0_.ID_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -&gt; isOpen (class)]</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : isOpen -&gt; <a class="jive-link-external-small" href="mailto:org.hibernate.type.BooleanType@1b52eaf">org.hibernate.type.BooleanType@1b52eaf</a></strong><br/><strong>14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :&#160; ti.isOpen -&gt; taskinstan0_.ISOPEN_</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG HqlSqlBaseWalker : select : finishing up [level=1, statement=select]</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG HqlSqlWalker : processQuery() :&#160; ( SELECT ( {select clause} taskinstan0_.ID_ ) ( FromClause{level=1} JBPM_TASKINSTANCE taskinstan0_ ) ( where ( and ( and ( in ( taskinstan0_.ACTORID_ taskinstan0_.ID_ actorId ) ( inList ? ) ) ( != ( taskinstan0_.ISSUSPENDED_ taskinstan0_.ID_ isSuspended ) 1 ) ) ( = ( taskinstan0_.ISOPEN_ taskinstan0_.ID_ isOpen ) 1 ) ) ) )</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG JoinProcessor : Using FROM fragment [JBPM_TASKINSTANCE taskinstan0_]</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG HqlSqlBaseWalker : select &gt;&gt; end [level=1, statement=select]</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : --- SQL AST ---</strong><br/><strong> \-[SELECT] QueryNode: 'SELECT'&#160; querySpaces (JBPM_TASKINSTANCE)</strong><br/><strong>&#160;&#160;&#160; +-[SELECT_CLAUSE] SelectClause: '{select clause}'</strong><br/><strong>&#160;&#160;&#160; |&#160; +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_ as ID1_27_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}</strong><br/><strong>&#160;&#160;&#160; |&#160; \-[SQL_TOKEN] SqlFragment: 'taskinstan0_.VERSION_ as VERSION3_27_, taskinstan0_.NAME_ as NAME4_27_, taskinstan0_.DESCRIPTION_ as DESCRIPT5_27_, taskinstan0_.ACTORID_ as ACTORID6_27_, taskinstan0_.CREATE_ as CREATE7_27_, taskinstan0_.START_ as START8_27_, taskinstan0_.END_ as END9_27_, taskinstan0_.DUEDATE_ as DUEDATE10_27_, taskinstan0_.PRIORITY_ as PRIORITY11_27_, taskinstan0_.ISCANCELLED_ as ISCANCE12_27_, taskinstan0_.ISSUSPENDED_ as ISSUSPE13_27_, taskinstan0_.ISOPEN_ as ISOPEN14_27_, taskinstan0_.ISSIGNALLING_ as ISSIGNA15_27_, taskinstan0_.ISBLOCKING_ as ISBLOCKING16_27_, taskinstan0_.TASK_ as TASK17_27_, taskinstan0_.TOKEN_ as TOKEN18_27_, taskinstan0_.PROCINST_ as PROCINST19_27_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN20_27_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM21_27_'</strong><br/><strong>&#160;&#160;&#160; +-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[ti], fromElementByTableAlias=[taskinstan0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}</strong><br/><strong>&#160;&#160;&#160; |&#160; \-[FROM_FRAGMENT] FromElement: 'JBPM_TASKINSTANCE taskinstan0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ti,role=null,tableName=JBPM_TASKINSTANCE,tableAlias=taskinstan0_,origin=null,colums={,className=org.jbpm.taskmgmt.exe.TaskInstance}}</strong><br/><strong>&#160;&#160;&#160; \-[WHERE] SqlNode: 'where'</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160; \-[AND] SqlNode: 'and'</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; +-[AND] SqlNode: 'and'</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; +-[IN] InLogicOperatorNode: 'in'</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; |&#160; +-[DOT] DotNode: 'taskinstan0_.ACTORID_' {propertyName=actorId,dereferenceType=4,propertyPath=actorId,path=ti.actorId,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; |&#160; |&#160; +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; |&#160; |&#160; \-[IDENT] IdentNode: 'actorId' {originalText=actorId}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; |&#160; \-[IN_LIST] SqlNode: 'inList'</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; |&#160;&#160;&#160;&#160; \-[NAMED_PARAM] ParameterNode: '?' {name=actorIds, <a class="" href="http://community.jboss.org/mailto:expectedType=org.hibernate.type.StringType@17a8369">expectedType=org.hibernate.type.StringType@17a8369</a>}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; \-[NE] BinaryLogicOperatorNode: '!='</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160;&#160;&#160;&#160; +-[DOT] DotNode: 'taskinstan0_.ISSUSPENDED_' {propertyName=isSuspended,dereferenceType=4,propertyPath=isSuspended,path=ti.isSuspended,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160;&#160;&#160;&#160; |&#160; +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160;&#160;&#160;&#160; |&#160; \-[IDENT] IdentNode: 'isSuspended' {originalText=isSuspended}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160;&#160;&#160;&#160; \-[TRUE] BooleanLiteralNode: '1'</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; \-[EQ] BinaryLogicOperatorNode: '='</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; +-[DOT] DotNode: 'taskinstan0_.ISOPEN_' {propertyName=isOpen,dereferenceType=4,propertyPath=isOpen,path=ti.isOpen,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; |&#160; \-[IDENT] IdentNode: 'isOpen' {originalText=isOpen}</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; \-[TRUE] BooleanLiteralNode: '1'</strong></p><p><strong>14:03:39,636 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : HQL: </strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160;&#160;&#160;&#160;&#160; select ti</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; from org.jbpm.taskmgmt.exe.TaskInstance as ti</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; where ti.actorId in ( :actorIds )</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160; and ti.isSuspended != true</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160; and ti.isOpen = true</strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160; </strong><br/><strong>14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : SQL: select taskinstan0_.ID_ as ID1_27_, taskinstan0_.VERSION_ as VERSION3_27_, taskinstan0_.NAME_ as NAME4_27_, taskinstan0_.DESCRIPTION_ as DESCRIPT5_27_, taskinstan0_.ACTORID_ as ACTORID6_27_, taskinstan0_.CREATE_ as CREATE7_27_, taskinstan0_.START_ as START8_27_, taskinstan0_.END_ as END9_27_, taskinstan0_.DUEDATE_ as DUEDATE10_27_, taskinstan0_.PRIORITY_ as PRIORITY11_27_, taskinstan0_.ISCANCELLED_ as ISCANCE12_27_, taskinstan0_.ISSUSPENDED_ as ISSUSPE13_27_, taskinstan0_.ISOPEN_ as ISOPEN14_27_, taskinstan0_.ISSIGNALLING_ as ISSIGNA15_27_, taskinstan0_.ISBLOCKING_ as ISBLOCKING16_27_, taskinstan0_.TASK_ as TASK17_27_, taskinstan0_.TOKEN_ as TOKEN18_27_, taskinstan0_.PROCINST_ as PROCINST19_27_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN20_27_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM21_27_ from JBPM_TASKINSTANCE taskinstan0_ where (taskinstan0_.ACTORID_ in (?)) and taskinstan0_.ISSUSPENDED_&lt;&gt;1 and taskinstan0_.ISOPEN_=1</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG HQLQueryPlan : HQL param location recognition took 0 mills (</strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160;&#160;&#160;&#160;&#160; select ti</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; from org.jbpm.taskmgmt.exe.TaskInstance as ti</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; where ti.actorId in ( :actorIds )</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160; and ti.isSuspended != true</strong><br/><strong>&#160;&#160;&#160;&#160;&#160;&#160;&#160; and ti.isOpen = true</strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160; )</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG SessionFactoryImpl : Checking named query: LoggingSession.findLogsByToken</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG QueryPlanCache : unable to locate HQL query plan in cache; generating (</strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160;&#160;&#160;&#160;&#160; select pl</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; from org.jbpm.logging.log.ProcessLog as pl</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; where pl.token = :token</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; order by pl.index</strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160; )</strong><br/><strong>14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : parse() - HQL: </strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160;&#160;&#160;&#160;&#160; select pl</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; from org.jbpm.logging.log.ProcessLog as pl</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; where pl.token = :token</strong><br/><strong>&#160;&#160;&#160;&#160;&#160; order by pl.index</strong><br/><strong>&#160;&#160;&#160; </strong><br/><strong>&#160; </strong><br/><strong>14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : --- HQL AST ---</strong></p></div>

<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
    <p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/587352#587352">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
                        </tr>
                    </tbody>
                </table>


                </td>
            </tr>
        </tbody>
    </table>

</div>

</body>
</html>