[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    RE: Methods of calling stored procedures in OJB
From:       Ron Gallagher <rgallagh () bellsouth ! net>
Date:       2006-08-09 20:43:02
Message-ID: 20060809204302.IEKT11527.ibm56aec.bellsouth.net () mail ! bellsouth ! net
[Download RAW message or body]

Jim --

Your assumptions are absolutely correct.

Ron Gallagher
> 
> From: "Wright, Jim \(NIH/CIT\) [C]" <wrightjr@mail.nih.gov>
> Date: 2006/08/09 Wed AM 11:09:41 EDT
> To: "OJB Users List" <ojb-user@db.apache.org>
> Subject: RE: Methods of calling stored procedures in OJB
> 
> Ron,
> 
> My doubt was how was the stored procedure being called?  I was thinking
> that you had to actually call it in your java code.  However, I think
> what you and the documentation are implicitly saying is that the broker
> is actually calling the stored procedure as you have configured it in
> the repository.  Therefore there is no need to call the stored procedure
> in one's java code.  When I pass an object defined to use a stored
> procedure to the OJB store instruction the s.p. will be executed.  Does
> this sound correct?  
> 
> Thanks,
> 
> Jim Wright 
> 
> 
> -----Original Message-----
> From: Ron Gallagher [mailto:rgallagh@bellsouth.net] 
> Sent: Tuesday, August 08, 2006 8:44 PM
> To: OJB Users List
> Subject: Re: Methods of calling stored procedures in OJB
> 
> Jim --
> 
> OJB supports the use of stored procedures to handle all persistence
> operations (insert, update and delete).  The stored procedures that are
> configured in the repository are used in place of standard insert,
> update and delete SQL commands.  You do not need to use any sort of
> database triggers in order to take advantage of OJB's use of stored
> procedures for persistence operations.
> 
> The example that you refer in the documentation to was culled from an
> application that I was one of the lead architects on.  In the
> environment that that application was to be deployed in, the DBAs
> insisted that all persistence operations be performed by stored
> procedures.  This was accomplished by utilizing OJB's support for stored
> procedures.  In that same environment, the business community insisted
> that we track who created and performed the last update on each record.
> That requirement was accomplished via the insert/update triggers that
> are referenced in the sample.  The final feature was the requirement
> that any updates to the four audit columns be reflected in the java
> objects that were managed by the application.  This requirement was
> accomplished in two steps: (1) the stored procedures that OJB utilized
> returned these values to the caller (i.e. OJB) via the "RETURNING"
> clause and (2) the configuration of the stored procedure in the
> repository file included the attri
>  bute 'return="true"' attribute on any arguments that were returned to
> OJB.
> 
> I hope this helps you out.
> 
> Let me know if I can clarify things any further.
> 
> Ron Gallagher
> 
> > 
> > From: "Wright, Jim \(NIH/CIT\) [C]" <wrightjr@mail.nih.gov>
> > Date: 2006/08/08 Tue PM 04:57:32 EDT
> > To: <ojb-user@db.apache.org>
> > Subject: Methods of calling stored procedures in OJB
> > 
> > Does one have to use database triggers in order to run stored
> procedures
> > in OJB?  The Apache documentation seems to imply that:
> > 
> >  
> > 
> >
> http://db.apache.org/ojb/docu/howtos/howto-work-with-stored-procedures.h
> > tml#A+simple+example
> > 
> >  
> > 
> > I need a way to run them that does not involve triggers.
> > 
> > Jim Wright 
> > 
> >  
> > 
> > 
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]