1.8 Application Logs & Support Information

The View Log window provides three tabs for examining logs, errors and actions taken by Aqua Data Studio. This is useful for troubleshooting issues and support questions, and monitoring server connection status. For details on recording and viewing SQL events, see the SQL Log page.

• Error log: Displays a running list of errors gathered after the View Log has been launched. These errors accumulate only as long as the View Log is open. The Save To Clipboard button makes it easy to include specific log contents in an email or document. The quickfilter within the Error Log allows filtering by log level.


• Console: This can intercept stdout, stderr, and uncaught exceptions. Functions the same as a command prompt or terminal for the operating system for viewing errors. Incorporating this in the application means not having to leave the application to launch a terminal or console during troubleshooting. The Save To Clipboard button makes it easier to include specific console contents in an email or document. 


• Archive: Collection of all of the Error Logs as text files. Each may be opened by double clicking, which launches a text editor. The quickfilter allows quick searching of contents. The columns within the Archive are sortable by clicking on the column headers.


• Startup Log: Displays information on Aqua Data Studio's most recent launch, including version number, date, time, Java version, memory use, system CPU count and file encoding.
   

By default, a rolling file logger is always enabled to ~/.datastudio/datastudio.log

This logger is configured to write up to 3 files of up to 300KB each, using "%d{M/d HH:mm:ss.SSS} %C{1}.%M %m%n layout.  (Logging month/day).

The logger can be turned off by placing logger.config file into ~/.datastudio directory.  This file overrides built-in configuration and offers the developers or end users virtually unlimited configuration choices.

Example Config File

# root logger
log4j.rootLogger=all, stdout, FILELOG

# console appender
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%C{1}.%M %m%n

# file appender
log4j.appender.FILELOG=org.apache.log4j.RollingFileAppender
log4j.appender.FILELOG.File=c:/datastudio.log
log4j.appender.FILELOG.MaxFileSize=20MB
log4j.appender.FILELOG.MaxBackupIndex=5
log4j.appender.FILELOG.layout=org.apache.log4j.PatternLayout
log4j.appender.FILELOG.layout.ConversionPattern=%d{HH:mm:ss.SSS} %C{1}.%M %m%n

Aqua Data Studio Support

When contacting AquaFold with support issues, use the application menu Help -> Support Information then click the 'Copy to Clipboard' button. Paste the copied information with a detailed description of your problem (including as much information as possible about the database vendor and version you are connecting to) in an email to architect (at) aquafold.com