Page tree
Skip to end of metadata
Go to start of metadata

Enabling Confluence logging

By default, PocketQuery is modest with logging in order to avoid flooding your log files. However, PocketQuery will become very talkative if you add some logging entries with level DEBUG at Confluence Admin > Logging and Profiling:

  • de.scandio.confluence.plugins.pocketquery
  • de.scandio.atlassian.plugins.pocketquery

Activate this, if you want to analyze the behaviour of PocketQuery. Information will be written to your atlassian-confluence.log file (if not configured otherwise in your instance).

Below some example log output:

2019-10-22 08:36:11,463 INFO [http-nio-8090-exec-8] [plugins.pocketquery.execution.PocketQueryDefaultExecution] run Running PocketQuery execution in of type {PocketQueryDefaultExecution}: queryName={SectionItems}; parameterString={null}
2019-10-22 08:36:11,465 DEBUG [http-nio-8090-exec-8] [pocketquery.managers.impl.ConfluencePocketQueryPlatformManager] isQueryAllowedInContext Checked if query SectionItems with spaces attribute '' is allowed in current space PQ -- result: true
2019-10-22 08:36:11,467 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.execution.PocketQueryDefaultExecution] executeQueryAndTransformResult Executing query: queryName = SectionItems; databaseName = PocketQuery; databaseUrl = jdbc:mysql://localhost:3306/pocketquery
2019-10-22 08:36:11,470 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.execution.PocketQueryDefaultExecution] mstart Start measuring execution time...
2019-10-22 08:36:11,471 DEBUG [http-nio-8090-exec-8] [managers.impl.delegates.SqlExternalDatabaseManager] connectViaJdbc Trying to connect to JDBC database PocketQuery | jdbc:mysql://localhost:3306/pocketquery | com.mysql.jdbc.Driver | root
2019-10-22 08:36:11,472 DEBUG [http-nio-8090-exec-8] [managers.impl.delegates.SqlExternalDatabaseManager] loadDriver Trying to load database driver com.mysql.jdbc.Driver
2019-10-22 08:36:11,473 DEBUG [http-nio-8090-exec-8] [managers.impl.delegates.SqlExternalDatabaseManager] loadDriver I could load the driver =)
2019-10-22 08:36:11,475 DEBUG [http-nio-8090-exec-8] [managers.impl.delegates.SqlExternalDatabaseManager] connectViaJdbc I'm connected =)
2019-10-22 08:36:11,476 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.execution.PocketQueryDefaultExecution] executeQueryAndTransformResult Raw result retrieved: {[{Section=Red, Item=Apples}, {Section=Red, Item=Cat}, {Section=Red, Item=Frog}, {Section=Blue, Item=Bike}, {Section=Blue, Item=Pig}, {Section=Green, Item=Slug}, {Section=Green, Item=Bird}]}
2019-10-22 08:36:11,477 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.execution.PocketQueryDefaultExecution] mend End measuring execution time. Result: 7 ms.
2019-10-22 08:36:11,478 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.execution.PocketQueryDefaultExecution] mstart Start measuring execution time...
2019-10-22 08:36:11,483 DEBUG [http-nio-8090-exec-8] [pocketquery.managers.impl.DelegatingExternalDatabaseManager] convert Nashorn engine detected on this Java platform. Using Nashorn converter engine.
2019-10-22 08:36:11,488 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.scripting.NashornConverterEngine] executeConverter Loading JS libraries: {/pocketquery-core/lib/moment/moment.min.js}
2019-10-22 08:36:11,488 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.scripting.NashornConverterEngine] executeConverter Loading: {/pocketquery-core/lib/moment/moment.min.js}
2019-10-22 08:36:12,027 DEBUG [http-nio-8090-exec-8] [plugins.pocketquery.scripting.NashornConverterEngine] executeConverter Loading: {/pocketquery-core/core/js/nashorn/pocketquery-converter.js}






  • No labels