[jboss-user] [jBPM] - Re: how turn off jbpm and hibernate logging?
s b
do-not-reply at jboss.com
Mon Feb 14 18:55:28 EST 2011
s b [http://community.jboss.org/people/simonbaker] created the discussion
"Re: how turn off jbpm and hibernate logging?"
To view the discussion, visit: http://community.jboss.org/message/587352#587352
--------------------------------------------------------------
Thanks, I'll try that -- have not done that as I wanted to control it through the logging system itself if possible.
Do you know what loggers these properties correspond to?
*<!-- logging properties (begin) -->*
* <property name="hibernate.show_sql">false</property>*
* <property name="hibernate.format_sql">false</property>*
* <property name="hibernate.use_sql_comments">false</property>*
* <!-- logging properties (end) -->*
*-------------------------------------------------------*
Also, do you know where this type of logging is coming from?
*14:03:39,620 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors*
*14:03:39,620 [http-443-5] DEBUG HqlSqlBaseWalker : select << begin [level=1, statement=select]*
*14:03:39,636 [http-443-5] DEBUG FromElement : FromClause{level=1} : org.jbpm.taskmgmt.exe.TaskInstance (ti) -> taskinstan0_*
*14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved : ti -> taskinstan0_.ID_*
*14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved : ti -> taskinstan0_.ID_*
*14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -> actorId (class)]*
*14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : actorId -> http://community.jboss.org/mailto:org.hibernate.type.StringType@17a8369 org.hibernate.type.StringType at 17a8369*
*14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved : ti.actorId -> taskinstan0_.ACTORID_*
*14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved : ti -> taskinstan0_.ID_*
*14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -> isSuspended (class)]*
*14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : isSuspended -> mailto:org.hibernate.type.BooleanType at 1b52eaf org.hibernate.type.BooleanType at 1b52eaf*
*14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved : ti.isSuspended -> taskinstan0_.ISSUSPENDED_*
*14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved : ti -> taskinstan0_.ID_*
*14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -> isOpen (class)]*
*14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : isOpen -> mailto:org.hibernate.type.BooleanType at 1b52eaf org.hibernate.type.BooleanType at 1b52eaf*
*14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved : ti.isOpen -> taskinstan0_.ISOPEN_*
*14:03:39,636 [http-443-5] DEBUG HqlSqlBaseWalker : select : finishing up [level=1, statement=select]*
*14:03:39,636 [http-443-5] DEBUG HqlSqlWalker : processQuery() : ( 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 ) ) ) )*
*14:03:39,636 [http-443-5] DEBUG JoinProcessor : Using FROM fragment [JBPM_TASKINSTANCE taskinstan0_]*
*14:03:39,636 [http-443-5] DEBUG HqlSqlBaseWalker : select >> end [level=1, statement=select]*
*14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : --- SQL AST ---*
*\-[SELECT] QueryNode: 'SELECT' querySpaces (JBPM_TASKINSTANCE)*
* +-[SELECT_CLAUSE] SelectClause: '{select clause}'*
* | +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_ as ID1_27_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}*
* | \-[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_'*
* +-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[ti], fromElementByTableAlias=[taskinstan0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}*
* | \-[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}}*
* \-[WHERE] SqlNode: 'where'*
* \-[AND] SqlNode: 'and'*
* +-[AND] SqlNode: 'and'*
* | +-[IN] InLogicOperatorNode: 'in'*
* | | +-[DOT] DotNode: 'taskinstan0_.ACTORID_' {propertyName=actorId,dereferenceType=4,propertyPath=actorId,path=ti.actorId,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}*
* | | | +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}*
* | | | \-[IDENT] IdentNode: 'actorId' {originalText=actorId}*
* | | \-[IN_LIST] SqlNode: 'inList'*
* | | \-[NAMED_PARAM] ParameterNode: '?' {name=actorIds, http://community.jboss.org/mailto:expectedType=org.hibernate.type.StringType@17a8369 expectedType=org.hibernate.type.StringType at 17a8369}*
* | \-[NE] BinaryLogicOperatorNode: '!='*
* | +-[DOT] DotNode: 'taskinstan0_.ISSUSPENDED_' {propertyName=isSuspended,dereferenceType=4,propertyPath=isSuspended,path=ti.isSuspended,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}*
* | | +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}*
* | | \-[IDENT] IdentNode: 'isSuspended' {originalText=isSuspended}*
* | \-[TRUE] BooleanLiteralNode: '1'*
* \-[EQ] BinaryLogicOperatorNode: '='*
* +-[DOT] DotNode: 'taskinstan0_.ISOPEN_' {propertyName=isOpen,dereferenceType=4,propertyPath=isOpen,path=ti.isOpen,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}*
* | +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}*
* | \-[IDENT] IdentNode: 'isOpen' {originalText=isOpen}*
* \-[TRUE] BooleanLiteralNode: '1'*
*14:03:39,636 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors*
*14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : HQL:*
* *
* select ti*
* from org.jbpm.taskmgmt.exe.TaskInstance as ti*
* where ti.actorId in ( :actorIds )*
* and ti.isSuspended != true*
* and ti.isOpen = true*
* *
* *
*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_<>1 and taskinstan0_.ISOPEN_=1*
*14:03:39,636 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors*
*14:03:39,636 [http-443-5] DEBUG HQLQueryPlan : HQL param location recognition took 0 mills (*
* *
* select ti*
* from org.jbpm.taskmgmt.exe.TaskInstance as ti*
* where ti.actorId in ( :actorIds )*
* and ti.isSuspended != true*
* and ti.isOpen = true*
* *
* )*
*14:03:39,636 [http-443-5] DEBUG SessionFactoryImpl : Checking named query: LoggingSession.findLogsByToken*
*14:03:39,636 [http-443-5] DEBUG QueryPlanCache : unable to locate HQL query plan in cache; generating (*
* *
* select pl*
* from org.jbpm.logging.log.ProcessLog as pl*
* where pl.token = :token*
* order by pl.index*
* *
* )*
*14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : parse() - HQL:*
* *
* select pl*
* from org.jbpm.logging.log.ProcessLog as pl*
* where pl.token = :token*
* order by pl.index*
* *
* *
*14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : --- HQL AST ---*
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/587352#587352]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110214/c461d9aa/attachment-0001.html
More information about the jboss-user
mailing list