yeah JPA is not the way to go for that. Try SqlMaps of iBATIS .. they are quite nice
http://ibatis.apache.org/javadownloads.cgi a simple demo .. it has many nice blogs about that ( db is oracle here ) http://www.it-eye.nl/weblog/2008/07/04/simple-delete-and-insert-statements-with-ibatis/ On Tue, Sep 16, 2008 at 3:45 PM, Mauriff <[EMAIL PROTECTED]> wrote: > > Any ideas? I read about "JavaTM Persistence API: Best Practices and Tips" > from Java One and here they says: > "Stored Procedures > How to invoke them > -Not specified by Java Persistence API > -Three ways to do this > -Can use persistence provider specific support > -Can use the underlying Java DataBase Connectivity > (JDBCTM) Connection object, if provider allows it, and > create a CallableStatement > -Can specify User-Defined Functions (UDF) and wrap > -SQL Procedures in them > You can call UDFs through SQL SELECT statements, and > hence, use native queries in Java Persistence API > -Options 1 and 2 locks into the provider whereas > -Option 3 is a persistence provider agnostic way" > > > How I can integrate Appfuse 2.x with Stored Procedures? > > > > > > > Mauriff wrote: > > > > Hi, I want use stored procedure in PL/SQL in my application. > > How I should embed the DDL for the stored procedure for creation and > > remove? > > How I should mapped the procedures? > > How ? should call the procedures? > > > > Thanks a lot! > > > > Mauri > > > > > > -- > View this message in context: > http://www.nabble.com/Using-Stored-Procedures.-tp19495092s2369p19512184.html > Sent from the AppFuse - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Regards, Youssef
