ActiveMQ 在shareplex8中的使用

来源:互联网 发布:天下3魍魉捏脸数据 编辑:程序博客网 时间:2024/05/22 04:34

ActiveMQ 下载:http://activemq.apache.org/activemq-580-release.html

以Linux (6.3为例)

(1)ActiveMQ server安装。(root)

JDK安装(1.6);ActiveMQtar包解压;启动activeMQ, cd /ActiveMQ/bin/, ./activatemq start;

检查启动进程 ps -ef|grep java


(2)Shareplex 配置(在source端)

[1]copy .tar files to shareplex /opt/splex8/lib/providers/activemq directory

cp $ACM_DIRC/apache-activemq-5.8.0/lib/slf4j-api-1.6.6.jar /opt/splex8/lib/providers/activemq

cp $ACM_DIRC/apache-activemq-5.8.0/activemq-all-5.8.0.jar /opt/splex8/lib/providers/activemq


[2]Open PK/UK supplemental logging in source DB

sqlplus / as sysdba

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

ALTER SYSTEM SWITCH LOGFILE;

alter database add supplemental log data (primary key,unique) columns;

SQL> select supplemental_log_data_min,supplemental_log_data_pk,supplemental_log_data_ui,supplemental_log_data_fk,supplemental_log_data_all from v$database;


SUPPLEME SUP SUP SUP SUP

-------- --- --- --- ---

YES      YES YES NO  NO


[3]set up splex port (cd /opt/splex/bin/ ./ora_setup)


[4]startup port and set the target jms parameter

target x.jms set jms factory_class =org.apache.activemq.jndi.ActiveMQInitialContextFactory

target x.jms set jms provider_url=tcp://amqserver_host:61616

target x.jms set jms lib_location =activemq


[4]configuration the jms configuration file

sp_ctrl (hostname:7003)> view config t

Datasource:o.cfga

test.LOGIN              !jms                  hostname

test.CUSER              !jms                  hostname

test.TAB_NO             !jms                  hostname

and then active config file.

5)test the JMS data in the web page.(admin/admin)

http://activemqserver_IP:8161


0 0