Skip to main content

Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "EclipseLink/Development/DBWS/RoadMap"

(2.2)
(2.2)
Line 17: Line 17:
  
 
==== 2.2 ====
 
==== 2.2 ====
<i>{divide items into 'above the line' and 'below the line' - items above the line require new DBWS development; items below the line are either i) done or ii) being worked on in parallel}</i>
+
<i>{divide items into 'above the line' and 'below the line' - items above the line require new DBWS development; items below the line are either i) done or ii) being investigated in parallel}</i>
 
* DBWS Sparse Merge
 
* DBWS Sparse Merge
 
** build on-top-of newly-added support for Sparse Merge for Dynamic Persistence
 
** build on-top-of newly-added support for Sparse Merge for Dynamic Persistence
 
** add usecase to DBWS section of User Guide
 
** add usecase to DBWS section of User Guide
 
** nightly JUnit testing
 
** nightly JUnit testing
* Return query result as rowset
+
* For [[EclipseLink/Examples/DBWS/DBWSBasicSQL|DBWS Custom SQL usecases]], get resultSet metadata at design-time to build <tt>eclipselink-dbws-schema.xsd</tt>
** JPub acquires the result set metadata using OracleResultSetMetaData.  
+
** add additional term (1=0) to <tt>WHERE</tt> clause
** Expectation is that DBWS provides similar level of support.
+
*** need either a GUI so that a user can indicate the correct place to add term, or a reliable parser that can handle arbitrarily complex <tt>WHERE</tt> clauses
 +
** result set metadata using OracleResultSetMetaData?  
 
* AQ Web Services
 
* AQ Web Services
 
** Investigate how to support
 
** Investigate how to support

Revision as of 11:23, 17 August 2010

DBWS Road Map

Backlog of work items

Future Bugs

  • Support 'sparse' merge (bug280667)
  • 275156 Support complex PL/SQL arguments for Stored Functions (requires core Foundation work)
    • Currently, complex schemas are generated for the arguments to named Stored Procedures that are PL/SQL collection/records or JDBC Object/Varrays; Need to extend this capability to Stored Functions
  • Align DBWS internal metadata with JPA/JAXB metadata (requires JPA/JAXB work)
  • Support optional arguments for Stored Procedures (requires core Foundation work)
  • 290156 Validate SOAP message arguments (must be very efficient!)
    • Currently perform no validation on objects passed via SOAPMessage. While complete validation is likely to be prohibitively expensive, some validation could result in errors better than "java.lang.reflect.InvocationTargetException"
  • 303333 Handle overloaded Stored Procedure/Functions as WSDL operations
  • 305522 Dynamic Entities do not work with JPA 2.0 Criteria Queries

2.2

{divide items into 'above the line' and 'below the line' - items above the line require new DBWS development; items below the line are either i) done or ii) being investigated in parallel}

  • DBWS Sparse Merge
    • build on-top-of newly-added support for Sparse Merge for Dynamic Persistence
    • add usecase to DBWS section of User Guide
    • nightly JUnit testing
  • For DBWS Custom SQL usecases, get resultSet metadata at design-time to build eclipselink-dbws-schema.xsd
    • add additional term (1=0) to WHERE clause
      • need either a GUI so that a user can indicate the correct place to add term, or a reliable parser that can handle arbitrarily complex WHERE clauses
    • result set metadata using OracleResultSetMetaData?
  • AQ Web Services
    • Investigate how to support
    • add used to DBWS section of User Guide

  • Jetty/Equinox support (mostly done)
    • DBWS deployed as OSGi bundle
    • Environment: Equinox + Jetty server
    • Documented here
    • TBD: Glassfish's Felix and HK2
  • DBWS Server tests
    • expand existing DBWS-running-on-WLS-server tests to run against WAS, JBoss and Glassfish
    • TBD: expand test coverage
  • Distributed transactional support via WS-AT
    • Investigation/test to confirm current level of support
    • Usecase and set-up criteria documented in user guide
  • DBRS
    • Look at role of DBWS in RESTful web applications
  • JPub -> EclipseLink DBWS migration strategy
    • Need to document a path explaining steps a user needs to take to switch from JAX-RPC based technologies to DBWS (JAX-WS) solution

2.1

  • accommodate internal changes for AttributeChangeTracking
  • support DBWSBuilder-generated JAX-WS Provider on JRockit
  • stop DBWSBuilder from truncating GROUP BY/ORDER BY clauses
  • DBWSBuilder supports Eclipse WTP Dynamic Web Project structure

2.0.1

  • align DBWS internal implementation with new Dynamic Persistence features
  • DBWSBuilder utility auto-detect Optimistic Lock field
  • fix issue with JDBC metadata and overloaded Stored Functions
  • Support MTOM attachments
  • fix Web service faults: contain better server-side root cause information

1.2

  • For OraclePlatform, support advanced PL/SQL datatypes (records, collections, mixture of the two) as arguments to Stored Procedures
    • need compatible JDBC 'shadow' types to align with PL/SQL types
  • For OraclePlatform, support complex JDBC datatypes (objects, varrays, mixture of the two) as arguments to Stored Procedures
  • Fix WSDL inline-schema to support above complex args
  • Add support for SOAP 1.2
  • Fix Delete operation (part of table-based CRUD): use only PK fields, not whole instance
  • Use nillable="true" to represent database null
  • DBWSBuilder utility to produce DDL for the compatible JDBC shadow types

1.1

  • Deploy to JAX-WS 2.n complaint server (WebLogic 10)
  • For OraclePlatform, support simple PL/SQL datatypes (PLSINTEGER, BOOLEAN, etc) as arguments to Stored Procedures
  • Improve server-side exception handling

1.0

The focus is on providing capabilities based upon the 3 types of database artifacts:

  1. table: CRUD lifecycle
  2. Stored Procedure: specialized queries
  3. Result set: returned from SQL SELECT queries

Back to the top