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/19 17:43:35 UTC
Modeller - reenginered functions parameters
Hi!
When reengineering a DB, including stored prodcedures,
the first parameter of functions is like this:
No.: R
Name: _return_value
Direction:
Type Other:
Max Length:
Precision:
The thing is, Direction is empty.
When saving, the modeller gives a warning:
ProcedureParameter has no direction.
Looks like a bug?
This is with version 3.0.1, the DB is Oracle.
Regards,
David Balažic
Re: Modeller - reenginered functions parameters
Posted by Andrus Adamchik <an...@objectstyle.org>.
Yeah, I guess we can make an assumption here... Feel free to open a Jira.
Andrus
On Jan 19, 2011, at 8:16 PM, David Balažic wrote:
> Yes, but a function return is always direction OUT, isn't it?
>
> David
>
>
>> -----Original Message-----
>> From: Andrus Adamchik [mailto:andrus@objectstyle.org]
>> Sent: Wednesday, January 19, 2011 6:56 PM
>> To: user@cayenne.apache.org
>> Subject: Re: Modeller - reenginered functions parameters
>> Importance: Low
>>
>> Unfortunately reverse engineering completely depends on the
>> metadata provided by the driver, which means Cayenne often
>> gets incomplete information, that has to be filled by the
>> user manually. I suspect this is what happened here as well.
>>
>> Andrus
>>
>> On Jan 19, 2011, at 6:43 PM, David Balažic wrote:
>>
>>> Hi!
>>>
>>> When reengineering a DB, including stored prodcedures,
>>> the first parameter of functions is like this:
>>> No.: R
>>> Name: _return_value
>>> Direction:
>>> Type Other:
>>> Max Length:
>>> Precision:
>>>
>>> The thing is, Direction is empty.
>>>
>>> When saving, the modeller gives a warning:
>>> ProcedureParameter has no direction.
>>>
>>> Looks like a bug?
>>>
>>> This is with version 3.0.1, the DB is Oracle.
>>>
>>> Regards,
>>> David Balažic
>>>
>>
>
RE: Modeller - reenginered functions parameters
Posted by David Balažic <da...@comtrade.com>.
Yes, but a function return is always direction OUT, isn't it?
David
> -----Original Message-----
> From: Andrus Adamchik [mailto:andrus@objectstyle.org]
> Sent: Wednesday, January 19, 2011 6:56 PM
> To: user@cayenne.apache.org
> Subject: Re: Modeller - reenginered functions parameters
> Importance: Low
>
> Unfortunately reverse engineering completely depends on the
> metadata provided by the driver, which means Cayenne often
> gets incomplete information, that has to be filled by the
> user manually. I suspect this is what happened here as well.
>
> Andrus
>
> On Jan 19, 2011, at 6:43 PM, David Balažic wrote:
>
> > Hi!
> >
> > When reengineering a DB, including stored prodcedures,
> > the first parameter of functions is like this:
> > No.: R
> > Name: _return_value
> > Direction:
> > Type Other:
> > Max Length:
> > Precision:
> >
> > The thing is, Direction is empty.
> >
> > When saving, the modeller gives a warning:
> > ProcedureParameter has no direction.
> >
> > Looks like a bug?
> >
> > This is with version 3.0.1, the DB is Oracle.
> >
> > Regards,
> > David Balažic
> >
>
Re: Modeller - reenginered functions parameters
Posted by Andrus Adamchik <an...@objectstyle.org>.
Unfortunately reverse engineering completely depends on the metadata provided by the driver, which means Cayenne often gets incomplete information, that has to be filled by the user manually. I suspect this is what happened here as well.
Andrus
On Jan 19, 2011, at 6:43 PM, David Balažic wrote:
> Hi!
>
> When reengineering a DB, including stored prodcedures,
> the first parameter of functions is like this:
> No.: R
> Name: _return_value
> Direction:
> Type Other:
> Max Length:
> Precision:
>
> The thing is, Direction is empty.
>
> When saving, the modeller gives a warning:
> ProcedureParameter has no direction.
>
> Looks like a bug?
>
> This is with version 3.0.1, the DB is Oracle.
>
> Regards,
> David Balažic
>