Oracle Schema Discovery
This is a modification provided by a few of the Service Factory community members that allows the Data Access Guidance Package to work with an Oracle database.
- Data Access Guidance Package.zip - This contains the data access guidance project and the updated templates and source code for generation of data repositories from
business entities. The enhancements only cover the "Get" operations. The same enhancements have not yet been made for the Update operation.
- SchemaDiscovery.zip - There was a small issue that surfaced when the same stored procedure name was used for a standalone stored procedure and a stored procedure
within a package at the same time (in the same schema). That issue has been corrected.
- "Get One Complex" in addition to "Get One" and "Get Many" have been added. This new operation is suited for retrieval of one object that contains sub-objects in a List<>.
- This code has been used with the July release of the WSSF. It has not been used with the December release yet, but no issues are suspected since the Data Access Guidance Package was not changed much (only a few bug fixes) between July and December.
Philippe worked with Yogz on this project. Yogz did all the Oracle schema discovery stuff, and Philippe worked on the templates and code generation for the "Create data repository classes from business entities" recipe.
Note to the other contributors: If you want recognition of this great work, just leave a comment on the page. I'll update the page and delete your comments. If there is anything else you want said on this page, let me know.