Chapter 5 Database Options
209
This option is used by the LTM only. When it is set to ON, the entire
database is set to act as a primary site in a Replication Server installation. All
changes to the database are sent to Replication Server by the LTM.
REPLICATION_ERROR option
For SQL Remote, allows you to specify a stored procedure to be called by
the Message Agent when a SQL error occurs.
Stored procedure name.
No procedure
For SQL Remote, the REPLICATION_ERROR option allows you to specify
a stored procedure to be called by the Message Agent when a SQL error
occurs. By default no procedure is called.
The procedure must have a single argument of type CHAR, VARCHAR, or
LONG VARCHAR. The procedure is called once with the SQL error
message and once with the SQL statement that causes the error.
Although the option allows you to track and monitor SQL errors in
replication, you must still design them out of your setup; this option is not
intended to resolve such errors.
RETURN_JAVA_AS_STRING option
To control how a Java object is passed to the client application when queried.
ON, OFF
Can be set for as a temporary option only, for the duration of the current
connection.
OFF
The option indicates how a Java object is returned to applications connecting
over Open Client or jConnect.
By default, a Java object is returned over TDS as a Sun serialization of the
object. The client, or receiver of the object serialization, is responsible for
deserializing the object into an instance.
If Return_java_as_string is set to ON, the object is first converted to an
instance of java.lang.String using the toString() method, and the String
object is returned to the client.
Description
Function
Allowed values
Default
Description
Function
Allowed values
Scope
Default
Description
To Next Page
Loading...