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
Attachments: db-ojb-selectbypk.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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
