Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

---

CATALOGMANAGER.mirrorrows

Copies rows from a table in one database to a table in another database using the CATALOGMANAGER command.

Note errno is not set. No error is generated if the value for a particular column is invalid (for example, enter a text character into an integer type field). Valid column edits succeed, invalid column edits do not. We recommend that you check your input carefully.

Syntax

<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="mirrorrows" />
<ARGUMENT NAME="tablekey" VALUE="name" />
<ARGUMENT NAME="tablekeyvalue" VALUE="value"/>
[<ARGUMENT NAME="mirrorport" VALUE="target port"/>]
<ARGUMENT NAME="mirrortarget" VALUE="target"/>
[<ARGUMENT NAME="mirrorauthusername" VALUE="username"/>]
[<ARGUMENT NAME="mirrorauthpassword" VALUE="password"/>]
[<ARGUMENT NAME="useProxyServer" VALUE="true or false"/>]
[<ARGUMENT NAME="cgiprefix" VALUE="some prefix"/>]
[<ARGUMENT NAME="inimerge" VALUE="ini file"/>]
[<ARGUMENT NAME="secureCommunication" VALUE="HTTPS"/>]
</CATALOGMANAGER>   

Parameters

ftcmd (required)

Value must be set to mirrorrows.

tablename (required)

Name of the source table.

tablekey (required)

Name of the table column to perform a selection on. If the system does not find the key, it uses the primary key of the specified table as the selection column. Contentname is the default value. See the Sites properties file, futuretense.ini to change this default.

tablekeyvalue (required)

Value of tablekey.

mirrorport (optional)

HTTP target port. Port 80 is used if a value is not specified.

mirrortarget (required)

Network name of the mirror target machine.

mirrorauthusername (optional)

Sites user name to log in to the target machine. Value is required if security is enabled on the mirror target.

mirrorauthpassword (optional)

Password associated with the value of mirrorauthusername to log in to the mirror target machine. Value is required if security is enabled on the mirror target.

useProxyServer (optional)

If the value is true, transmission should be routed through the proxy server. The proxy server and port to use are specified using the cs.mirrorproxyserver and cs.mirrorproxyport properties.

cgiprefix (optional)

Specifies the application server type on the target system. For iPlanet Application Server, set it to:

  /NASApp/CS/

For WebLogic and WebSphere, set it to:

  /servlet

inimerge (optional)

Name of a property file on the target system that should be loaded before the mirroring operation proceeds. This parameter is used to define primary key values for tables on the target server.

secureCommunication (optional)

If true, uses secure protocol (HTTPS) to transmit the data to the target server.

Error Numbers

The possible values of errno include:

Value	Description
0	Mirror operation succeeded.
-105	Database error.
-601	Returned from mirrorabort when a mirror operation is not currently in progress.
-602	Mirror operation in progress.
-603	Required variables are missing from the mirrorrows CatalogManager command.
-604	The data (file) associated with a url column could not be found on the source machine.
-605	The schema for a column on the source machine cannot be determined.
-606	No rows to mirror from the target system.
-607	Current mirroring operation was aborted via the mirrorabort command.
-608	A connection could not be established to the mirror target server.
-609	The network disconnected communication between the source and target machines.
-610	An attempt was made to mirror from a machine where the database columns are mixed case to a system where the database columns are case-sensitive.
-611	Mirror commit operation failed.
-612	Target server returned an invalid configuration connection message.
-613	Obsolete; is not returned.
-614	Could not create a temporary table on the target server.
-615	Could not delete the temporary table.
-616	Server does not support this mirror operation.
-617	Table is not an Object table.
-618	No tree nodes found matching the nid parameter of FTTreeNode.

Example

This example passes mirror parameters that a user has entered in an HTML form to the mirror command.

<SETVAR NAME="errno" VALUE="0" />
<CATALOGMANAGER SCOPED="GLOBAL">
   <ARGUMENT NAME="ftcmd" VALUE="mirrorrows" />
   <ARGUMENT NAME="tablename" VALUE="movies" />
   <ARGUMENT NAME="tablekey" VALUE="id" />
   <ARGUMENT NAME="tablekeyvalue" VALUE="your_server" />
   <ARGUMENT NAME="mirrortarget" VALUE="" />
   <ARGUMENT NAME="mirrorauthusername" VALUE="ContentServer"" />
   <ARGUMENT NAME="mirrorauthpassword" VALUE="FutureTense" />
</CATALOGMANAGER>   
<IF COND="IsError.Variables.errno=true">
	 	 <THEN>
	 	 <!--Handle error-->
	 	 </THEN>
</IF>

See Also

mirrorabort

		Home >	Contents >	Index >
	Oracle XML Tag Reference Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.