[teiid-issues] [JBoss JIRA] (TEIID-2084) Provide a command logging output example in the admin guide

Tue Aug 14 15:42:16 EDT 2012

     [ https://issues.jboss.org/browse/TEIID-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-2084.
---------------------------------


> Provide a command logging output example in the admin guide
> -----------------------------------------------------------
>
>                 Key: TEIID-2084
>                 URL: https://issues.jboss.org/browse/TEIID-2084
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Documentation
>    Affects Versions: 8.0
>            Reporter: Van Halbert
>            Assignee: Van Halbert
>            Priority: Minor
>
> Provide an example output from the command logging so that it shows what information will be logged.
> Example:
> 2012-06-22 10:35:22,762 DEBUG [org.teiid.COMMAND_LOG] (Worker7_QueryProcessorQueue13:) 	START DATA SRC COMMAND:	startTime=2012-06-22 10:35:22.761	requestID=EynKBWrVxkDI.0	sourceCommandID=2	txID=null	modelName=PartsSupplier_SQL_Server	translatorName=PartsSupplier_SQL_Server_sqlserver	sessionID=EynKBWrVxkDI	principal=user at teiid-security	sql=SELECT g_0.SUPPLIER_ID AS c_0, g_0.SUPPLIER_NAME AS c_1, g_0.SUPPLIER_STATUS AS c_2, g_0.SUPPLIER_CITY AS c_3, g_0.SUPPLIER_STATE AS c_4 FROM PartsSupplier_SQL_Server.SUPPLIER AS g_0 ORDER BY c_0
> 2012-06-22 10:35:22,863 DEBUG [org.teiid.COMMAND_LOG] (Worker7_QueryProcessorQueue16:) 	END SRC COMMAND:	endTime=2012-06-22 10:35:22.863	requestID=EynKBWrVxkDI.0	sourceCommandID=2	txID=null	modelName=PartsSupplier_SQL_Server	translatorName=PartsSupplier_SQL_Server_sqlserver	sessionID=EynKBWrVxkDI	principal=user at teiid-security	finalRowCount=16
> 2012-06-22 10:35:22,921 DEBUG [org.teiid.COMMAND_LOG] (Worker8_QueryProcessorQueue14:) 	START DATA SRC COMMAND:	startTime=2012-06-22 10:35:22.921	requestID=EynKBWrVxkDI.0	sourceCommandID=3	txID=null	modelName=PartsSupplier_Oracle	translatorName=PartsSupplier_Oracle_oracle	sessionID=EynKBWrVxkDI	principal=user at teiid-security	sql=SELECT g_0.SUPPLIER_ID AS c_0, g_0.PART_ID AS c_1, g_0.QUANTITY AS c_2, g_0.SHIPPER_ID AS c_3 FROM PartsSupplier_Oracle.SUPPLIER_PARTS AS g_0 ORDER BY c_0 NULLS FIRST
> 2012-06-22 10:35:23,055 DEBUG [org.teiid.COMMAND_LOG] (Worker8_QueryProcessorQueue14:) 	END SRC COMMAND:	endTime=2012-06-22 10:35:23.055	requestID=EynKBWrVxkDI.0	sourceCommandID=3	txID=null	modelName=PartsSupplier_Oracle	translatorName=PartsSupplier_Oracle_oracle	sessionID=EynKBWrVxkDI	principal=user at teiid-security	finalRowCount=227

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira