The stored procedure LOGCONTROLLER changes the log level for a certain log category of the logging engine used by Virtual DataPort.

The changes performed by this procedure are lost when the Server is stopped.

Read more about the logging engine in the section Configuring the Logging Engine of the Administration Guide.


LogController (
       category : text
     , <level>

<level> ::=
    | 'DEBUG'
    | 'INFO'
    | 'WARN'
    | 'ERROR'
    | 'FATAL'
  • category: the category of the log. You can see the list of log categories in the <DENODO_HOME>/conf/vdp/log4j.xml file.

  • level: the type of messages that you want to log for this category.

Privileges Required

Only administrators can invoke this procedure.


CALL LOGCONTROLLER('com.denodo.vdp.requests', 'INFO')

With the default Log4j configuration of the Virtual DataPort server, after executing this query, all the requests sent to the Server will be logged in the <DENODO_HOME>/logs/vdp/vdp-requests.log file.

Add feedback