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]
