Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Development/DBWS/JDBCUseCases"
< EclipseLink | Development | DBWS
(→Supported Use Cases for non-Oracle Platforms) |
|||
| Line 3: | Line 3: | ||
* raw SQL | * raw SQL | ||
| − | :When a DBWS <code>QueryOperation</code> is invoked by a Web service, the selection criteria for the Query can be specified as a SQL <tt>SELECT</tt> statement. This means that DBWS does not know what information will be returned until the statement has been executed and the <code>java.sql.ResultSet</code> returned. In these cases, a simplified XML format is used | + | :When a DBWS <code>QueryOperation</code> is invoked by a Web service, the selection criteria for the Query can be specified as a SQL <tt>SELECT</tt> statement. This means that DBWS does not know what information will be returned until the statement has been executed and the <code>java.sql.ResultSet</code> returned. In these cases, a [[EclipseLink/Development/DBWS/FunctionalSpecification#SXF_.28Simple_XML_Format.29|simplified XML format]] is used. |
| + | |||
* Tables | * Tables | ||
:blah | :blah | ||
* Stored Procedures | * Stored Procedures | ||
:blah | :blah | ||
Revision as of 13:00, 17 December 2009
Supported Use Cases for non-Oracle Platforms
The design-time utility DBWSBuilder uses JDBC meta-data APIs (java.sql.DatabaseMetaData) to extract information about tables (column names and types) and Stored Procedures (argument names and types) which is then translated into information required by DBWS (EclipseLink Project files, XML Schemas, etc) so that at runtime a Web service client can invoke an operation and receive a response.
- raw SQL
- When a DBWS
QueryOperationis invoked by a Web service, the selection criteria for the Query can be specified as a SQL SELECT statement. This means that DBWS does not know what information will be returned until the statement has been executed and thejava.sql.ResultSetreturned. In these cases, a simplified XML format is used.
- Tables
- blah
- Stored Procedures
- blah