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 >
