數據源配置
|
1)數據源配置在JBossESB-ds.xml文件配置,詳細信息如下:
<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
|
其它說明
|
數據庫表(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);
|