Plugin:org.tolven.oraclemgr

From DOC

Contents 1 Overview 2 Command Line 2.1 Test connection from admin to Oracle 2.2 Simulate connection from appserver to Oracle 2.3 Update Schemas In Oracle 2.4 Update Indexes In Oracle 3 Oracle Manager GUI 3.1 Standalone GUI 3.2 Component Of Configuration Manager GUI 4 Version Notes 4.1 Version 0.0.9 4.2 Version 0.0.8 4.3 Version 0.0.7 4.4 Version 0.0.6 4.5 Version 0.0.5 4.6 Version 0.0.4 4.7 Version 0.0.3 4.8 Version 0.0.2 4.9 Version 0.0.1

Overview

Command Line

Test connection from admin to Oracle

tpf -plugin org.tolven.oraclemgr -testAdminDB

Simulate connection from appserver to Oracle

tpf -plugin org.tolven.oraclemgr -testAppServerDB

Update Schemas In Oracle

The command is normally executed only once during initial configuration, but repeated execution causes no harm. This command is activated during the configPhase2 command where the database must already have been configured to work with Tolven. configPhase2 basically executes the command below (in addition to executing commands which update LDAP schemas). To update only the Oracle schemas, you can execute the command below:

tpf -plugin org.tolven.oraclemgr -updateSchemas

Update Indexes In Oracle

The command is normally executed only once during initial configuration, but repeated execution causes no harm. This command is activated during updateDBIndexes command where the database must already have been configured to work with Tolven and the application server must already have been started. updateDBIndexes basically executes the command below:

tpf -plugin org.tolven.oraclemgr -updateIndexes

Oracle Manager GUI

Standalone GUI

tpf -plugin org.tolven.oraclemgr -gui

Component Of Configuration Manager GUI

GUI components like this one can be a component of a parent GUI. To make this plugin's GUI a child of org.tolven.configurationmgr, ensure that the following property appears in this plugin's entry in the <config-dir>/plugins.xml:

<plugin id="org.tolven.oraclemgr">
	<root />
	<property name="guiComponentParentId" value="org.tolven.configurationmgr" />
</plugin>

org.tolven.configurationmgr must also be in the <config-dir>/plugins.xml as a <root> plugin, so that it can be referenced. The sort order id is: org.tolven.oraclemgr_oracle

Version Notes

Version 0.0.9

1. Added error message to indicate when a DB root password has not been stored in the password store, thus removing the NullPointerException

Version 0.0.8

1. Add index on MenuData.referenceId to facilitate faster access when looking for MenuData items that reference a placeholder.

Version 0.0.7

1. Clarified output messages for the tests
2. Also writes messages to the tolven.log as well as stdout

Version 0.0.6

1. tolvenRemoteClient is now assembled during configPhase1, and placed in the public/download directory of the /Tolven context, where it can be automatically downloaded from the server via http to the installDir/remoteLib directory for use during the execution of configPhase3

Version 0.0.5

1. Placeholder ID index was updated to include menustructure_id. Requires updateIndexes to take effect.

Version 0.0.4

1. Fixed bug in the oracle connection string which had the correct values, but used the same format as Postgresql, and that did not work. This would have been noticed when carrying out an Oracle database test using the Configuration Manager.

Version 0.0.3

GUI for testing Oracle connection

1. Fixed a typo in the manifest for the location of an end </extension> tag.

Version 0.0.2

GUI for testing Oracle connection

1. Added an option to updateSchemas and updateIndexes

Version 0.0.1

GUI for testing Oracle connection