About WebConsole

Enables you to manage DataCaster server with web interface.

Database

This group allows you to manage database on the server.

Browse

Use this page to browse through the database on your server, it enables browsing similar to directory browsing. All the database identified on the server will be list at the start. Start browsing the database just by click on the database name.

Search

Use this page to search for the catalog/schema/table/view by name. You can select the databases in which the search should be made (by default all the databases are considered). The search is case-insensitive and looks for matching substring. When you choose to search for, say table, all the tables present in selected databases will be taken as candidates for searching.

SQL Commands

This group gives the support for SQL interaction with the database.

Run Query

Use this page to execute a sql query. You have to provide the database name, the sql query and optionally the schema name. You can select the output format (html, xml, csv). Click RunQuery to execute the query. The page will list limited command history that was recently executed (not repeated), you can select any of the listed query. Query is executed by creating the SQL Statement, compiling it and then execute it. Once the query is executed and the output format is html. The resulting table rows will displayed. In the result page you can edit the query and input a new query. You can bookmark the query link. You can also try other output format, like xml, csv which executes the query again (please be careful when the query changes the database state, say, insert, delete, update). When there is lot of the columns in the result you can hide the entire column by clicking the cross mark and make it appear again by click on the name of the column which is highlighted. RMI Support is added to RunQuery, all you need to do is select the check box "Is Remote" and provide the required information and click RunQuery, like RMI URL, Remote Username and Remote Password. Some non-sql commands like 'show catalogs', 'show schemas', 'show tables' and 'show views' are supported.

The number of rows that is displayed from the resulting query table is set to 1000. It is good to use LIMIT option in query if the resulting table is large.

Search Query

Use this page to search for the queries that have executed on this server. This search will be done on the history file. You can search on different fields, like the query, database name, schema name, or all. By default all the fields will be used to search for the input. The serach present on RunQuery page is for convienence where the default search field is selected as 'query'. The result of the search will be links to the query with the input information that was provided when it was executed. You can select any query for execution.

Run Script

Use this page to run the sql script on the database. The script file will be uploaded to the server and a temporary file is created and will be used. [The temporary file is deleted when the server is stopped]. The output of last query executed will be displayed (the number of rows dispalyed is limited to 1000).

Data Dictionary

This group allows you to document you database with descriptions.

Browse

Use this page to browse through the database, this will allow you to edit the description on the tables and columns.

Table Description

Use this page to set the description for the database table. You have to first select the database, then select the schema which contains the table and select the table on which you want to add/edit the description.

Column Description

Use this page to set the description for the column of the table in the database. You have to first select the database, then select the schema, then the table which contains the column. Then you can add/edit the description.

Logs

This group allows you to view the log file information on the server.

Info Log

Use this page to see the "system.out" (defined in dbprefs.xml, output log). This will list the output log files. You can browse through the output log file using (Paged View) or see the raw content of the file (Show File). When browsing, only log output group starting with [INFO] are filtered for display. The file is read in reverse during browse which can be slow.

Errors

Use this page to see the "system.err" (defined in dbprefs.xml, error log). This will list the error log files. You can browse through the error log file using (Paged View) or see the raw content of the file (Show File). When browsing, only error output group starting with [ERROR] are filtered for display. The file is read in reverse during browse which can be slow.

Stack Trace

Use this page to see the "system.stacktrace" (defined in dbprefs.xml, trace log). This will list the trace log files. You can browse through the trace log file using (Paged View) or see the raw content of the file (Show File). When browsing, only error output group starting with [STACKTRACE] are filtered for display. The file is read in reverse during browse which can be slow.

Audit Log

Use this page to see the "audit.file" (defined in dbprefs.xml, audit log). This will list the audit log files. You can browse through the audit log file using (Paged View) or see the raw content of the file (Show File). The file is read in reverse during browse which can be slow.

Module Trace logs

Use this page to see the trace logs of each module. The trace logs details for each module depends on its trace level setting. You have to select the database first. List of available trace log files are displayed. You view the log output by filtering based on module tag, or see the raw file using "Show File" link, or see all the module output using "Paged View" link.

Users and Roles

This group allows you to manage the users and roles associated with users on this server.

My Roles

Use this page to look at the roles assigned to you. Access to WebAdmin will not be available if you are assigned the webadmin role.

Change Password

Use this page to change your password.