Calling Stored Procedure through ofbiz

[gopalbi <go...@hytechpro.com>]

Hi Friends i need your help, 
     
         I am using mysql database. i have to call a Stored Procedure
through ofbiz using a submit button event or any other event. So anyone of
you know how to achieve this, kindly help me.

Thanks in advance.

Thanks & Regards
Gopal Bisht

              
-- 
View this message in context: http://www.nabble.com/Calling-Stored-Procedure-through-ofbiz-tp18503859p18503859.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Calling Stored Procedure through ofbiz

[to...@gmail.com]

Gopal,

Stored procedures will be database and application specific. If you want to
implement this then you need to write some JDBC code in a Java service and
call your stored procedures directly.



On 7/17/08, gopalbi <go...@hytechpro.com> wrote:
>
>
> Hi Friends i need your help,
>
>         I am using mysql database. i have to call a Stored Procedure
> through ofbiz using a submit button event or any other event. So anyone of
> you know how to achieve this, kindly help me.
>
> Thanks in advance.
>
> Thanks & Regards
> Gopal Bisht
>
>
> --
> View this message in context:
> http://www.nabble.com/Calling-Stored-Procedure-through-ofbiz-tp18503859p18503859.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>


-- 
Anil Soni
Software Engineer
Amicon Technologies Private Limited
6th Floor - Unique Tower, Behind Patel Patrol Pump,
Goregaon (W), Mumbai MH
Contact no.- +91-9892271357

Re: Calling Stored Procedure through ofbiz

[BJ Freeman <bj...@free-man.net>]

ofbiz, depending on the db will convert the SQL statements to temp
Stored procedures.
you can use the direct SQL statement.
However  I suggest you understand ofbiz and ECA
you may be duplicating what ofbiz does.
http://docs.ofbiz.org/pages/listpages-dirview.action?key=OFBTECH

particularly
Framework Introduction Videos and Diagrams

gopalbi sent the following on 7/17/2008 1:26 AM:
> Hi Friends i need your help, 
>      
>          I am using mysql database. i have to call a Stored Procedure
> through ofbiz using a submit button event or any other event. So anyone of
> you know how to achieve this, kindly help me.
> 
> Thanks in advance.
> 
> Thanks & Regards
> Gopal Bisht
> 
>