Description
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.