JDeveloper使用Toplink DB Provider发布Webservice
来源:互联网 发布:php curl 参数详解 编辑:程序博客网 时间:2024/05/18 02:35
With JDeveloper 11gR2 you can now create database based web services using JAX-WS Provider. The key differences between this and the already existing PL/SQL Web Services support is:
This is present as a new option in the New Gallery under 'Web Services'
When you invoke the New Gallery option, it present you with three options to choose from:
In this entry I will explain the options of creating service based on SQL queries and Table CRUD operations.
SQL Query based Service
When you select this option, on 'Next' page it asks you for the DB Conn details. You can also choose if you wantSOAP 1.1 or 1.2 format. For this example, I will proceed with SOAP 1.1, the default option.
On the Next page, you can give the SQL query. The wizard support Bind Variables, so you can parametrize your queries. Give "?" as a input parameter you want to give at runtime, and the "Bind Variables" button will get enabled. Here you can specify the name and type of the variable.
Finish the wizard. Now you can test your service in Analyzer:
See that the bind variable specified comes as a input parameter in the Analyzer Input Form:
CRUD Operations
For this, At Step 2 of Wizard, select the radio button "Generate Table CRUD Service Provider"
At the next step, select the DB Connection and the table for which you want to generate the default set of operations:
Finish the Wizard. Now, run the service in Analyzer for a quick check.
See that all the basic operations are exposed:
- Based on JAX-WS Provider
- Supports SQL Queries for creating Web Services
- Supports Table CRUD Operations
This is present as a new option in the New Gallery under 'Web Services'
When you invoke the New Gallery option, it present you with three options to choose from:
In this entry I will explain the options of creating service based on SQL queries and Table CRUD operations.
SQL Query based Service
When you select this option, on 'Next' page it asks you for the DB Conn details. You can also choose if you wantSOAP 1.1 or 1.2 format. For this example, I will proceed with SOAP 1.1, the default option.
On the Next page, you can give the SQL query. The wizard support Bind Variables, so you can parametrize your queries. Give "?" as a input parameter you want to give at runtime, and the "Bind Variables" button will get enabled. Here you can specify the name and type of the variable.
Finish the wizard. Now you can test your service in Analyzer:
See that the bind variable specified comes as a input parameter in the Analyzer Input Form:
CRUD Operations
For this, At Step 2 of Wizard, select the radio button "Generate Table CRUD Service Provider"
At the next step, select the DB Connection and the table for which you want to generate the default set of operations:
Finish the Wizard. Now, run the service in Analyzer for a quick check.
See that all the basic operations are exposed:
1 0
- JDeveloper使用Toplink DB Provider发布Webservice
- 使用JDeveloper 11g 发布WebService
- 使用JDeveloper 11g 发布EJB3.0
- 使用xfire发布WebService
- 发布和使用WebService
- 使用CXF发布webService
- 使用CXF发布WebService
- TopLink
- TopLink
- 一、使用 Microsoft OLE DB Provider For ODBC 链接MySQL
- 让Excel Xp使用旧版本的Ole Db Provider
- 使用jdk自带webservice发布webservice
- WebService学习笔记-使用CXF发布Webservice
- 使用 xfire 快速发布 WebService
- 使用services.xml发布webservice
- 使用CXF框架发布webservice
- 使用XFire发布webservice配置
- 使用cxf发布webservice总结
- Hexo+Github pages折腾记
- bzoj3576 [Hnoi2014]江南乐
- 第三方库头文件找不到
- Python开发环境快速搭建
- MyEclipse10破解时出现:integrity check error
- JDeveloper使用Toplink DB Provider发布Webservice
- Oracle transfer parent child tree to json
- 怎样测试服务器压力
- Ajax获取服务器数据乱码
- 高效学习--思维导图
- PHP的数据类型
- Android亮屏、暗屏、解锁、关闭系统对话的监听事件
- shared_ptr
- Android布局-FlexboxLayout