Calling Stored Procedure through ofbiz

[gopalbi]

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

             

[anil.soni]

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 <[hidden email]> 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.- [phone]

[BJ Freeman]

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