[OFBiz] Dev - Help with implementing Stored Procedures

[Michael Irving]

We have an HRMS Application that resides in an Oracle database.  For each
entity, there are packages (stored procedures/functions) in the database
that create, update, delete and fetch.  For example:

 

Pkg_timesheet.create_enttry(p_date IN DATE, p_emp_no IN NUMBER, p_project_id
IN NUMBER, p_hours IN NUMBER, p_success_flag IN OUT NUMBER)

 

We would like to use these APIs from within OFBIZ.  From what I've learned
thus far, here are the things we'll need to do.can someone verify that we
are on the right track?:

 

1)     Helper Class

a.      Create a new helper class that uses our stored procedures.

b.      Use GenericDAO as a "template" and modify the methods accordingly to
create OracleDAO

c.      Use GenericHelperDAO as a "template" and modify the methods
accordingly to create OracleHelperDAO

 

2)     entityengine.xml

a.      Create a new delegator that connects to the Oracle DB Instance

b.      Assign our own Helper Class to the datasource (e.g.
org.ofbiz.entity.datasource.OracleHelperDAO)

 

3)
<ofbiz_home>/applications/<application_name>/entitydef/entitymodel.xml

a.      Create the XML for each of our entities

 

4)
<ofbiz_home>/applications/<application_name>/entitydef/entitygroup.xml

a.      Create the XML that groups our entities

 

 

 

-----------------------------------------

Michael Irving

Keynetx, Inc. - Building Solutions for Success

Mobile: (267)474.3564

Fax: (425) 871-2838

email: mirving at keynetx.com

 

* * * Visit Our Web Site:  <http://www.keynetx.net/> http://www.keynetx.net
* * *

 

----------------------------------------------------------------------------
----

NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ofbiz.org/pipermail/dev/attachments/20050820/f880b71d/attachment-0001.htm