Change the <force_preparedstatement_reload> directive's value to falseOpen your agent.xml file in a text editing application. Then, locate the <force_preparedstatement_reload> directive and change its directive(s) nested within the <task> directive(s) and change each value to false per the example shown below: Code Block |
---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?> |
name>ivanname>mssql_test_subscribe</task_name> |
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.test | _2" use_basic_consume="true" user="admin">amqps://test.perspectium.net</message_connection> |
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user=" | admintestuser">https://mycompany.service-now. | com>
com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler> |
key>Thecowjumpedoverthemoon and the sun<for testing</decryption_key> |
type>mysql<type>sqlserver</database_type> |
<database_server>localhost</database_server> |
port>3306<port>1433</database_port> |
user>root<user>testuser</database_user> |
password/>
password>testpassword</database_password>
<database_ | parms>characterEncoding=UTF-8 & useSSL=false</database_parms>
parms/>
<database_column_max | _column_size>251</database_column_max | _column
<database>psp_repl</database> |
<temporal> <columns> <column column_type="93" column_size="32" type="from">psp_from</column> <column column_type="93" column_size="32" type="to">psp_to</column> </columns> <max_datetime>2030-12-31 00:00:00</max_datetime> </temporal> <force_preparedstatement_reload>false</force_preparedstatement_reload>
</task> |
<max_reads_per_connect>4000</max_reads_per_connect> |
<polling_interval>5</polling_interval> |
<skip_message_set_processing/> |
|