數(shù)據(jù)源配置
|
1)數(shù)據(jù)源配置在JBossESB-ds.xml文件配置,詳細(xì)信息如下:
<datasources>
? <local-tx-datasource>
??? <jndi-name>JBossESBDS</jndi-name>
?
??? <connection-url>jdbc:jtds:sqlserver://222.118.20.108;DatabaseName=jbossesb</connection-url>
??? <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
??? <user-name>dbname</user-name>
??? <password>access</password>
?
??? <min-pool-size>10</min-pool-size>
??? <max-pool-size>100</max-pool-size>
??? <blocking-timeout-millis>1000</blocking-timeout-millis>
??? <idle-timeout-minutes>5</idle-timeout-minutes>
?
? </local-tx-datasource>
?
</datasources>
2.修改jbossEsb.properties文件:
org.jboss.soa.esb.mail.smtp.host=www.163.com
org.jboss.soa.esb.mail.smtp.port=23
org.jboss.soa.esb.mail.smtp.user=ejinmy
org.jboss.soa.esb.mail.smtp.password=123456789abc
?
?
#
# Object Store Settings
#
org.jboss.soa.esb.objStore.configfile=file:/e:/temp/ObjStore.xml
|
其它說明
|
數(shù)據(jù)庫表(script)
CREATE TABLE batches (
??? batch_num int NOT NULL,
??? seq integer NOT NULL,
??? data varchar,
??? CONSTRAINT batches_pk PRIMARY KEY (batch_num,seq)
);
?
?
CREATE TABLE object_snap (
??? uid int NOT NULL,
??? stamp int,
??? snap_type varchar,
??? object_uid int,
??? batch_num int,
??? xml_data varchar,
??? CONSTRAINT object_snap_pk PRIMARY KEY (uid)
);
?
?
CREATE TABLE people_index (
?
??uid bigint NOT NULL,
??? stamp int,
??? latest_snap_uid int,
??? latest_snap_date varchar,
??? name varchar,
??? phone varchar,
??? address varchar,
??? CONSTRAINT people_index_pk PRIMARY KEY (uid)
);
?
?
CREATE TABLE uid_table (
??? uid integer NOT NULL,
??? sequence_name varchar NOT NULL,
??? last_used_uid bigint NOT NULL,
??? CONSTRAINT uid_table_pk PRIMARY KEY (uid)
);
?
?
INSERT INTO uid_table (uid, sequence_name, last_used_uid) VALUES (1, 'jbossEsb_objuid', 10500000);
INSERT INTO uid_table (uid, sequence_name, last_used_uid) VALUES (2, 'jbossEsb_batchuid', 251000);
|