BizTalk动手实验（十二）WCF-Oracle适配器使用

ゞ浴缸里的玫瑰 2021-11-13 16:34 274阅读 0赞

**更多内容请查看：[BizTalk动手实验系列目录][BizTalk]**

**                      [BizTalk 开发系列][BizTalk 1]**

### 1 课程简介 ###

通过本课程熟悉WCF-Oracle适配器的的使用

### 2 准备工作 ###

1. 新建BizTalk空项目

2. 配置BizTalk项目的应用程序名称及程序签名。

3. Oracle数据库

( Oracle Database Expression [http://www.oracle.com/technetwork/products/express-edition/downloads/index.html][http_www.oracle.com_technetwork_products_express-edition_downloads_index.html] )

4. Oracle SQL developer ([http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html][http_www.oracle.com_technetwork_developer-tools_sql-developer_downloads_index.html] )

5. BizTalk WCF Operation Promote Pipeline Component ( [http://btsoperationpromote.codeplex.com][http_btsoperationpromote.codeplex.com]  )

### 3 演示 ###

#### 3.1 生成数据库表相应操作的Schema ####

注：创建BizTalk项目过程请参见：《BizTalk开发综合实验》

1. 右击项目，添加生成项

#### 3.2 点击Consume Adapter Service ####

[![clip\_image001][clip_image001]][clip_image001_clip_image001]

2. 绑定类型中选择sqlBinding

[![clip\_image003][clip_image003]][clip_image003_clip_image003]

3. 在适配器属性配置的安全选项中输入账户信息

[![clip\_image005][clip_image005]][clip_image005_clip_image005]

4. URI属性中输入服务器地址及数据库名称

[![clip\_image007][clip_image007]][clip_image007_clip_image007]

5. 在绑定窗口中将“UseAmbientTransaction”选项置为False，“EnableBizTalkCompatibilityMode”置为True

6. 点击OK保存

7. 点击连接按钮

8. Select contract type选择Client(Outbound Operations), 在category的Tables中选择 contacts,在操作中选择Insert、 Select、Update和Delete。

[![clip\_image009][clip_image009]][clip_image009_clip_image009]

9. 生成向导会生成相应的Schema文件及绑定文件

[![clip\_image011][clip_image011]][clip_image011_clip_image011]

10. 生成并部署项目

#### 3.3 发布Schema为WCF-BasicHttp服务 ####

1. 点击Visual Studio 工具菜单中的BizTalk WCF Service 发布向导。

[![clip\_image012\[14\]][clip_image012_14]][clip_image012_14_clip_image012_14]

2. 点击下一步

[![clip\_image013][clip_image013]][clip_image013_clip_image013]

3. 在传输类型中选择WCF-BasicHttp，并选择在刚才部署的BizTalk应用程序中创建接收端口

[![clip\_image015][clip_image015]][clip_image015_clip_image015]

4. 在创建依法中选择发布Schema为WCF服务

[![clip\_image016\[14\]][clip_image016_14]][clip_image016_14_clip_image016_14]

5. 创建Select跟Insert方法

[![clip\_image017][clip_image017]][clip_image017_clip_image017]

6. 右击方法相应的请求与输出参数，选择Schema类型

[![clip\_image019][clip_image019]][clip_image019_clip_image019]

7. 根据命令空间选择相应的Schema

[![clip\_image021][clip_image021]][clip_image021_clip_image021]

8. 配置好相应的操作与参数类型

输入相应的命名空间

[![clip\_image023][clip_image023]][clip_image023_clip_image023]

9. 输入URL地址，启用匿名访问

[![clip\_image025\[50\]][clip_image025_50]][clip_image025_50_clip_image025_50]

10. 确认配置并点击创建

[![clip\_image027][clip_image027]][clip_image027_clip_image027]

11. 创建完成

[![clip\_image029][clip_image029]][clip_image029_clip_image029]

12. BizTalk应用程序中会有相应的接收端口被创建

[![clip\_image031][clip_image031]][clip_image031_clip_image031]

13. 打开IIS 7 管理器，新建应用程序池BTSAppPool,将运行账户改为Administrator

[![clip\_image032][clip_image032]][clip_image032_clip_image032]

14. 修改WCF-SQLDemo应用程序的运行池为BTSAppPool

15. 修改Web应用的Web.config(默认文件夹位置为：C:\\inetpub\\wwwroot\\WCF-SQLDemo)，开启通过http get 的方式获取服务的WSDL

#### 3.4 配置WCF-SQL发送端口 ####

1. 右击BizTalk管理控制台的应用程序，右键选择导入Binding

[![clip\_image033][clip_image033]][clip_image033_clip_image033]

2. 选择项目文件夹下的WcfSendPort\_SqlAdapterBinding\_Custom.bindinginfo.xml

3. BizTalk将自动生成发送端口

[![clip\_image035][clip_image035]][clip_image035_clip_image035]

4. 需要在在发送端口中重新配置数据库用户名和密码

[![clip\_image037][clip_image037]][clip_image037_clip_image037]

5. 配置发送端口的发送管道为PromotePipeline

[![clip\_image039][clip_image039]][clip_image039_clip_image039]

6. 在发送端口的配置文件中配置订阅条件，即接收端口名称为WCF-BasicHttp发布向导生成的接收端口名称：

[![clip\_image041][clip_image041]][clip_image041_clip_image041]

7. 为便于测试，将发送端口传输选项的重试次数和间隔时间设为0

[![clip\_image043][clip_image043]][clip_image043_clip_image043]

#### 3.5 测试服务 ####

1.  启动WCFOracleDemo应用程序
2.  开启soapUI,新创建项目，在BTSOracleWCF.svc访问地址后面加上 ?wsdl ，即可得到WSDL

[![clip\_image045][clip_image045]][clip_image045_clip_image045]

1.  编辑相应的Insert、Select、Update数据，并请求。将接收到相应的返回数据。

[![clip\_image047][clip_image047]][clip_image047_clip_image047]

1.  使用SQL Developer 查询数据

[![clip\_image049][clip_image049]][clip_image049_clip_image049]

#### 3.6 轮询Oracle数据库 ####

1.  在BizTalk中右键选择生成项目

[![clip\_image051][clip_image051]][clip_image051_clip_image051]

1.  使用适配器服务

[![clip\_image053][clip_image053]][clip_image053_clip_image053]

1.  在适配器服务配置中点击配置，在连接配置中输入用户和密码，在URI属性中的轮询标识中输入唯一的数字标识

[![clip\_image055][clip_image055]][clip_image055_clip_image055]

11. 在绑定属性中配置轮询命令为：select \* from contacts , 同时设置“UseAmbientTransaction”为False，“EnableBizTalkCompatibilityMode”为True

[![clip\_image057][clip_image057]][clip_image057_clip_image057]

1.  点击OK保存，点击Connect连接到Oracle数据库。
2.  在contract type中选择Service（Inbound Service），同时点击“/”根节点，在右侧可用的类别与操作中选择POLLINGSTMG。

[![clip\_image059][clip_image059]][clip_image059_clip_image059]

1.  点击OK保存，系统将会生成相应的轮询架构与绑定

[![clip\_image061][clip_image061]][clip_image061_clip_image061]

1.  在BizTalk管理控制台的应用程序中将生成的绑定导入到应用程序中，系统将会自动配置接收端口

[![clip\_image063][clip_image063]][clip_image063_clip_image063]

８. 新建发送到File类型的发送端口，订阅Oracle的轮询数据

[![clip\_image065][clip_image065]][clip_image065_clip_image065]

９. 启动轮询接收端口在文件发送文件夹将自动会有相应的文件

[![clip\_image067][clip_image067]][clip_image067_clip_image067]

#### 3.7 Oracle数据库脚本参考 ####

<table> 
 <tbody> 
 <tr> 
 <td> CREATE TABLE CONTACTS ( ID NUMBER(*, 0) NOT NULL , NAME VARCHAR2(20 BYTE) NOT NULL , PHONE VARCHAR2(20 BYTE) , EMAIL VARCHAR2(100 BYTE) , IM VARCHAR2(100 BYTE) , ADDRESS VARCHAR2(200 BYTE) , CONSTRAINT CONTACTS_PK PRIMARY KEY ( ID ) ENABLE ) create or replace PROCEDURE ADDCONTACT ( PARAM0 IN NUMBER , PARAM1 IN VARCHAR2 , PARAM2 IN VARCHAR2 , PARAM3 IN VARCHAR2 , PARAM4 IN VARCHAR2 , PARAM5 IN VARCHAR2 ) AS BEGIN Insert Into CONTACTS(ID,NAME,PHONE,EMAIL,IM,ADDRESS) Values(PARAM0,PARAM1,PARAM2,PARAM3,PARAM4,PARAM5); END ADDCONTACT; </td> 
 </tr> 
 </tbody> 
</table>

转载于:https://www.cnblogs.com/cbcye/archive/2013/02/22/2922130.html

[BizTalk]: http://www.cnblogs.com/cbcye/admin/%20http:/www.cnblogs.com/cbcye/archive/2011/12/19/2293014.html
[BizTalk 1]: http://www.cnblogs.com/cbcye/archive/2008/10/28/1321182.html
[http_www.oracle.com_technetwork_products_express-edition_downloads_index.html]: http://www.oracle.com/technetwork/products/express-edition/downloads/index.html
[http_www.oracle.com_technetwork_developer-tools_sql-developer_downloads_index.html]: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
[http_btsoperationpromote.codeplex.com]: http://btsoperationpromote.codeplex.com
[clip_image001]: https://images0.cnblogs.com/blog/28375/201302/22133507-8dcbe663660643d78bda0e90fcf72a70.png
[clip_image001_clip_image001]: /images/20211113/4055e67ac3cf4aa0afcf853e7a4a1c41.png
[clip_image003]: https://images0.cnblogs.com/blog/28375/201302/22133508-3ed946f977dc4d57a9a87f4669cd1373.png
[clip_image003_clip_image003]: /images/20211113/9b608e1039974d29870840808e85bf8a.png
[clip_image005]: https://images0.cnblogs.com/blog/28375/201302/22133509-118c2ab761b5445a8ccd6a23c894a0b4.png
[clip_image005_clip_image005]: /images/20211113/69bde8799c184e19af917b1ab2cf3a80.png
[clip_image007]: https://images0.cnblogs.com/blog/28375/201302/22133512-4af83a79b5dc4ad3994b5ec45b36dc97.png
[clip_image007_clip_image007]: /images/20211113/2326ed053abe4dfba4e6d110bb00c958.png
[clip_image009]: https://images0.cnblogs.com/blog/28375/201302/22133516-4385f303f3324e63af6934e9c16cfabe.png
[clip_image009_clip_image009]: /images/20211113/2b976b50c4ee4228a3d46ef283c55f40.png
[clip_image011]: https://images0.cnblogs.com/blog/28375/201302/22133517-df6a43559a07434080cd17d142f95023.png
[clip_image011_clip_image011]: /images/20211113/371a19ec33904be4ac2c6db9eb864570.png
[clip_image012_14]: https://images0.cnblogs.com/blog/28375/201302/22133518-b16bf11efb5b499f8cd0d27a02a0aca7.png
[clip_image012_14_clip_image012_14]: /images/20211113/26928da54c264da797b26df0ad272878.png
[clip_image013]: https://images0.cnblogs.com/blog/28375/201302/22133519-c50d7fef1ab54602ae2e4b18d696eeab.png
[clip_image013_clip_image013]: /images/20211113/14b1cf5d5cf344cbb9ff4a8da63ea53f.png
[clip_image015]: https://images0.cnblogs.com/blog/28375/201302/22133523-44ca1eff9d6946b888e22e31017f676c.png
[clip_image015_clip_image015]: /images/20211113/ef61eb1446054ab5bb6c66b3da8bc9c3.png
[clip_image016_14]: https://images0.cnblogs.com/blog/28375/201302/22133524-577e3da50ea74d7dbd37ae09b0ca502f.png
[clip_image016_14_clip_image016_14]: /images/20211113/c898526613144e7c894da470edd39c37.png
[clip_image017]: https://images0.cnblogs.com/blog/28375/201302/22133524-a9e32ae17705498e904fab74fb27c799.png
[clip_image017_clip_image017]: /images/20211113/3b3d0925c0bc496e9338c10540f86a40.png
[clip_image019]: https://images0.cnblogs.com/blog/28375/201302/22133529-a5d01d8417f84e32ac68bd6ec650e68a.png
[clip_image019_clip_image019]: /images/20211113/fee071e2d3d44d74b760ba5e77283c35.png
[clip_image021]: https://images0.cnblogs.com/blog/28375/201302/22133534-567f7af14559438da58b0f72cedf7c3b.png
[clip_image021_clip_image021]: /images/20211113/924e669df1f14a76a5c5d53e09875285.png
[clip_image023]: https://images0.cnblogs.com/blog/28375/201302/22133536-8f89a978546840509e868b0bf1bbf0b1.png
[clip_image023_clip_image023]: /images/20211113/439769c934d24f20b82c3f14e27892d0.png
[clip_image025_50]: https://images0.cnblogs.com/blog/28375/201302/22133546-b5b5382a8eff4788b69a90e7cd055068.png
[clip_image025_50_clip_image025_50]: /images/20211113/9758b50f681449288c0d78c9a81724f8.png
[clip_image027]: https://images0.cnblogs.com/blog/28375/201302/22133554-2a5499be00fc4b36bdf5f7a43cf6d5a2.png
[clip_image027_clip_image027]: /images/20211113/7a0b64724cbe440cbb127c23c6750365.png
[clip_image029]: https://images0.cnblogs.com/blog/28375/201302/22133559-5327588e0acb4f8d9a9bcc06c6aa9d8c.png
[clip_image029_clip_image029]: /images/20211113/ba236ad9d7d64c209edec8b89b0d84bf.png
[clip_image031]: https://images0.cnblogs.com/blog/28375/201302/22133600-1bd6072183b446c9979b4866154900db.png
[clip_image031_clip_image031]: /images/20211113/240842a9385145f08e05edf637607d84.png
[clip_image032]: https://images0.cnblogs.com/blog/28375/201302/22133600-3031c06a689e41518208fbdf3636aac4.png
[clip_image032_clip_image032]: /images/20211113/fe9164f298444c76bf2d97e44adae408.png
[clip_image033]: https://images0.cnblogs.com/blog/28375/201302/22133601-548b1577bf9f4f4e9aa1a0146f9e8dda.png
[clip_image033_clip_image033]: /images/20211113/d8774c9913ae4559963cda3b118bfd5d.png
[clip_image035]: https://images0.cnblogs.com/blog/28375/201302/22133602-8540e43106924ee4aa5b69502df2fe4d.png
[clip_image035_clip_image035]: /images/20211113/c3ab05564ea844c1a23952aa4a05bd21.png
[clip_image037]: https://images0.cnblogs.com/blog/28375/201302/22133607-90839aeda4104a49b6edf5c79ba47a79.png
[clip_image037_clip_image037]: /images/20211113/2176b674792643c08ad4cb3d94c38d11.png
[clip_image039]: https://images0.cnblogs.com/blog/28375/201302/22133611-c1aa506f847e4ea6b7b540f096281f36.png
[clip_image039_clip_image039]: /images/20211113/7c700590f7eb487dabd0925d35f6e668.png
[clip_image041]: https://images0.cnblogs.com/blog/28375/201302/22133615-4b90953bce914295965f9543e8740070.png
[clip_image041_clip_image041]: /images/20211113/489679d4579143788288c755c8bb6a56.png
[clip_image043]: https://images0.cnblogs.com/blog/28375/201302/22133616-706ae107e7634b0ca50784436d5f50d2.png
[clip_image043_clip_image043]: /images/20211113/c9c5ac54bb0c487f8670a067868750dc.png
[clip_image045]: https://images0.cnblogs.com/blog/28375/201302/22133620-ebde47894a784067bbc0b7a3d5d84e21.png
[clip_image045_clip_image045]: /images/20211113/de3844d3b6734195aa84f6e18bf679f9.png
[clip_image047]: https://images0.cnblogs.com/blog/28375/201302/22133621-74425d83c1f447458700a1f6ecb159e2.png
[clip_image047_clip_image047]: /images/20211113/1297270b67a84c568a961d14b41be82d.png
[clip_image049]: https://images0.cnblogs.com/blog/28375/201302/22133624-2d9c153a855649c6a28b888c5429d6b1.png
[clip_image049_clip_image049]: /images/20211113/de22ea43cb1641aeb89e08f359605c8e.png
[clip_image051]: https://images0.cnblogs.com/blog/28375/201302/22133625-82eabf168d1d418295995d94f0ab3c54.png
[clip_image051_clip_image051]: /images/20211113/cf0b54c3fbae4092ab0d186378f859a5.png
[clip_image053]: https://images0.cnblogs.com/blog/28375/201302/22133628-270c752504284540ba22f34496d65b22.png
[clip_image053_clip_image053]: /images/20211113/757c59660464488db5b8e8660b888a7a.png
[clip_image055]: https://images0.cnblogs.com/blog/28375/201302/22133631-fcb6705818c94005904458688feceff8.png
[clip_image055_clip_image055]: /images/20211113/41205b1bd5754f49aa8a6404ec20bb88.png
[clip_image057]: https://images0.cnblogs.com/blog/28375/201302/22133637-458cff514b4649d7bac689f8e0bed691.png
[clip_image057_clip_image057]: /images/20211113/2c62a9e39c09416f980a7a8de0f413f4.png
[clip_image059]: https://images0.cnblogs.com/blog/28375/201302/22133648-baabf1bb3a9f4b97bd8bfd3864b91b68.png
[clip_image059_clip_image059]: /images/20211113/5ab389c5af484aefb4a581c547f2734c.png
[clip_image061]: https://images0.cnblogs.com/blog/28375/201302/22133651-2819afe284ce46b0831afb2d2a331489.png
[clip_image061_clip_image061]: /images/20211113/2add8e14bf5842f290dae5b57dd719be.png
[clip_image063]: https://images0.cnblogs.com/blog/28375/201302/22133653-a27ef20e2b89414dbbc29d0a566e548b.png
[clip_image063_clip_image063]: /images/20211113/bd74f4d584664609828f53ed94a9bb26.png
[clip_image065]: https://images0.cnblogs.com/blog/28375/201302/22133656-79104bd30d59490182a45f51fbd85199.png
[clip_image065_clip_image065]: /images/20211113/9d2a758ae0d14a6eaa79d8c68100c4fc.png
[clip_image067]: https://images0.cnblogs.com/blog/28375/201302/22133700-6a0acdc0b3b04dc38b07296914ca7a7d.png
[clip_image067_clip_image067]: /images/20211113/5004d8e533e44b938a93024d82f5a447.png