Web Service Data Source: Port to the Database
Processing:
- getConnection()‏
- parseRequest()‏
- validateRequest()‏
- executeJDBC()‏
- [commit / rollback]
- format response
- close connection
WsDataSource
- executes requested operations making JDBC calls to local database
- requests are authenticated by database
- HTTPS is used for secure communication
- stateless, document-literal style
- converts data presentation between SOAP and JDBC
- returns metadata of the fetched rowset
OC4J servlet
Operation-methods:
- executeQuery()‏
- executeDML()‏
Web Service Data Source: Port to the Database


The purpose is to perform requested operations in the local database on behalf of specified user.

User name and password are placed in every request. The web service starts any operation by getting JDBC connection to the database, assuming that the user is registered and his rights are defined.

To protect transmitted content during its movement across Internet, secure HTTPS protocol is used.

The web service is implemented as stateless document-literal style service.

Being a data source for ADF, the web service has two operations: ExecuteQuery and ExecuteDML. Request to each operation includes SQL statement, its parameters together with type-indicators, and other properties for making JDBC call to the database.

The web service converts data between SOAP and JDBC types using accompanied type-indicators.

ExecuteQuery operation returns fetched rowset together with its metadata including column names and types.

ExecuteDML operation returns optional result – primary key of inserted row.