Home > Contents > 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 thecs.mirrorproxyserver
andcs.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 frommirrorabort
when a mirror operation is not currently in progress. -602 Mirror operation in progress. -603 Required variables are missing from themirrorrows
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 themirrorabort
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 thenid
parameter ofFTTreeNode.
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
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.