| 
												數據源配置
												
														
														
												
										 | 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); |