[ http://issues.apache.org/jira/browse/OJB-16?page=all ]
Vadim Gritsenko updated OJB-16:
-------------------------------
Attachment: stored-procedures-patch.zip
Attaching refactored patch, in stored-procedures-patch.zip, with following
changes: removed QueryByCriteriaBase, and QueryByFKCriteria renamed to
QueryByExample and now extends from QueryByCriteria.
These changes are aligned more with changes in OJB 1.1 (trunk), so it will be
much easier to refactor it for applying to trunk. This patch is against
OJB_1_0_RELEASE.
> Support stored procedures in select by pk statement
> ---------------------------------------------------
>
> Key: OJB-16
> URL: http://issues.apache.org/jira/browse/OJB-16
> Project: OJB
> Type: New Feature
> Components: PB-API
> Versions: 1.0.x CVS
> Reporter: Vadim Gritsenko
> Assignee: Thomas Dudziak
> Attachments: QueryByCriteriaBase.java, QueryByFKCriteria.java,
> SelectByFKProcedureDescriptor.java, SelectByPKProcedureDescriptor.java,
> SqlProcedureFKStatement.java, db-ojb-patch.diff, db-ojb-selectbypk.diff,
> stored-procedures-patch.zip, xdoclet.diff
>
> This patch adds support for retrieving objects by primary keys through call
> to stored procedure instead of using select statement.
> To activate the feature, add xdoclet tag to the class:
> /**
> * @ojb.class table="MYBEAN"
> * @ojb.selectbypk-procedure name="FIND_MYBEAN_BYID"
> */
> public class MyBean {
> /**
> * @ojb.field primarykey="true"
> */
> Integer id;
> }
> And then, create stored procedure:
> CREATE OR REPLACE PACKAGE TYPES AS
> TYPE CURSORTYPE IS REF CURSOR;
> END TYPES;
> /
> CREATE OR REPLACE FUNCTION FIND_MYBEAN_BYID (ANID IN MYBEAN.ID%TYPE)
> RETURN TYPES.CURSORTYPE AS
> RESULT TYPES.CURSORTYPE;
> BEGIN
> OPEN RESULT FOR SELECT * FROM MYBEAN WHERE ID = ANID;
> RETURN RESULT;
> END;
> /
> Patch is made against OJB_1_0_RELEASE branch.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
