This section describes how to define the information that RepConnector uses to connect to the Replication Server System Database (RSSD) to gather metadata information for use in processing the events that RepConnector receives from Replication Server.
This section also describes how to designate whether RepConnector groups all the commands in a specific transaction into a single XML message or sends each command in that transaction to a separate XML message.
Entering Replication Server System Database information
On the Replication Server System Database Information page, enter the JDBC URL string that connects to the RSSD in the RSSD URL field.
The syntax for the RSSD URL string is:
jdbc:sybase:Tds:<RSSD host machine name>: < RSSD port number >/< RSSD database name>
where:
jdbc:sybase:Tds is the URL prefix.
<RSSD host machine name> is the name of the host machine on which the RSSD is running.
< RSSD port number > is the port number on which the RSSD is listening.
< RSSD database name> is the RSSD database name.
For example:
jdbc:sybase:Tds:mymachine:4501/SAMPLE_RS_RSSD
Enter the user name and password to connect to the RSSD in the User Name and the Password fields, respectively.
Select your message grouping preference using the Message Grouping Preference check boxes.
Individual – each command in a transaction sent as separate XML message or event.
Group – all the commands in a transaction grouped into a single XML message or event.
If you use RepConnector to replicate tables containing large
text or image type fields, Sybase recommends that you do not use
the Group option. With large text or image data groupings, your
system may run out of memory after accumulating only several messages.
This is a limitation in RepConnector.
Go back to step 10 in “Adding and configuring a new connection”.
