You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by "Rares Ispas (JIRA)" <de...@cayenne.apache.org> on 2008/03/03 13:15:16 UTC

[jira] Created: (CAY-995) Generating stored procedures access code

Generating stored procedures access code
----------------------------------------

                 Key: CAY-995
                 URL: https://issues.apache.org/cayenne/browse/CAY-995
             Project: Cayenne
          Issue Type: New Feature
          Components: CayenneModeler GUI
    Affects Versions: 3.0
            Reporter: Rares Ispas
            Assignee: Andrus Adamchik


For us the greatest benefit of Cayenne is that it generates Java code which can be verified by the compiler whenever the schema changes. However, that only happens for entity objects. It would be great if it would also work for stored procedures, so that the code that accesses the SP is automatically generated by Cayenne.

Example:
create procedure createOrFindUser(
    @userName varchar(100) )
returns bigint
as
.... code

should generate a function
Long createOrFindUser( String userName )

I think the advantages are obvious and the implementation should be straightforward enough.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Closed: (CAY-995) Generating stored procedures access code

Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
     [ https://issues.apache.org/cayenne/browse/CAY-995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-995.
-------------------------------

    Resolution: Duplicate

this is superseded by CAY-1070 and CAY-1089 

> Generating stored procedures access code
> ----------------------------------------
>
>                 Key: CAY-995
>                 URL: https://issues.apache.org/cayenne/browse/CAY-995
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: CayenneModeler GUI
>    Affects Versions: 3.0
>            Reporter: Rares Ispas
>            Assignee: Andrus Adamchik
>
> For us the greatest benefit of Cayenne is that it generates Java code which can be verified by the compiler whenever the schema changes. However, that only happens for entity objects. It would be great if it would also work for stored procedures, so that the code that accesses the SP is automatically generated by Cayenne.
> Example:
> create procedure createOrFindUser(
>     @userName varchar(100) )
> returns bigint
> as
> .... code
> should generate a function
> Long createOrFindUser( String userName )
> I think the advantages are obvious and the implementation should be straightforward enough.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Re: [jira] Commented: (CAY-995) Generating stored procedures access code

Posted by Andrus Adamchik <an...@objectstyle.org>.
On Mar 3, 2008, at 3:07 PM, Kevin Menard (JIRA) wrote:

>
> I suppose these should be separate JIRAs, however.

Yeah, this is unrelated to the code generation tasks.

Andrus

[jira] Commented: (CAY-995) Generating stored procedures access code

Posted by "Kevin Menard (JIRA)" <de...@cayenne.apache.org>.
    [ https://issues.apache.org/cayenne/browse/CAY-995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762#action_12762 ] 

Kevin Menard commented on CAY-995:
----------------------------------

+1 on the named queries, too.

Taking it a step further, it'd be nice if prefetches and orderings could be modeled even for regular relationships.  E.g., I have some relationships that I always want returned in a sorted order.  As of now, I have to go well out of my way to achieve that.  Control of prefetches over flattened relationships would be nice as well.

I suppose these should be separate JIRAs, however.

> Generating stored procedures access code
> ----------------------------------------
>
>                 Key: CAY-995
>                 URL: https://issues.apache.org/cayenne/browse/CAY-995
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: CayenneModeler GUI
>    Affects Versions: 3.0
>            Reporter: Rares Ispas
>            Assignee: Andrus Adamchik
>
> For us the greatest benefit of Cayenne is that it generates Java code which can be verified by the compiler whenever the schema changes. However, that only happens for entity objects. It would be great if it would also work for stored procedures, so that the code that accesses the SP is automatically generated by Cayenne.
> Example:
> create procedure createOrFindUser(
>     @userName varchar(100) )
> returns bigint
> as
> .... code
> should generate a function
> Long createOrFindUser( String userName )
> I think the advantages are obvious and the implementation should be straightforward enough.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (CAY-995) Generating stored procedures access code

Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
    [ https://issues.apache.org/cayenne/browse/CAY-995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12759#action_12759 ] 

Andrus Adamchik commented on CAY-995:
-------------------------------------

+1

I was thinking about something like that recently... Same thing for named queries ....

> Generating stored procedures access code
> ----------------------------------------
>
>                 Key: CAY-995
>                 URL: https://issues.apache.org/cayenne/browse/CAY-995
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: CayenneModeler GUI
>    Affects Versions: 3.0
>            Reporter: Rares Ispas
>            Assignee: Andrus Adamchik
>
> For us the greatest benefit of Cayenne is that it generates Java code which can be verified by the compiler whenever the schema changes. However, that only happens for entity objects. It would be great if it would also work for stored procedures, so that the code that accesses the SP is automatically generated by Cayenne.
> Example:
> create procedure createOrFindUser(
>     @userName varchar(100) )
> returns bigint
> as
> .... code
> should generate a function
> Long createOrFindUser( String userName )
> I think the advantages are obvious and the implementation should be straightforward enough.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.