You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by David Balažic <da...@comtrade.com> on 2011/01/11 19:42:57 UTC

Operating only with stored procedures?

Hi!

Can Cayenne be configured to use only stored procedure calls,
so no SELECT/INSERT/UPDATE/DELETE ?

(with Oracle DB, if it matters)

The reason is a complex environment, where the application
will have only the right to call stored procedures and not
access any tables directly.

Many thanks,
David Balažic

Re: Operating only with stored procedures?

Posted by Andrus Adamchik <an...@objectstyle.org>.

You can sure call stored procedures from Cayenne and map simple objects, etc., but I don't think there's a practical way to use relationships, or to implement full object lifecycle. In other words if your DB interaction is limited to stored procedures, Cayenne may work as a persistence utility framework, but not as a full-featured ORM.

Andrus

On Jan 11, 2011, at 8:42 PM, David Balažic wrote:
> Hi!
> 
> Can Cayenne be configured to use only stored procedure calls,
> so no SELECT/INSERT/UPDATE/DELETE ?
> 
> (with Oracle DB, if it matters)
> 
> The reason is a complex environment, where the application
> will have only the right to call stored procedures and not
> access any tables directly.
> 
> Many thanks,
> David Balažic
>