Ok, that would be a good option.
--Gordon
Rainer Kwesi Schweigkoffer wrote:
> Hi Gordon, all,
>
> Gordon Yorke, am 8 Apr 2011 hast Du um 11:57 zum Thema "[jsr338-experts] Re: stored procedures" geschrieben :
>
>
>> We should also support optional parameters in a stored procedure.
>> StoredProcedures can have defaults defined for the parameters within the
>> definition of the StoredProcedure. Having a parameter be optional would
>> prevent the provider from supplying that parameter and allow the user to
>> leverage the DB defined defaults.
>>
>> @Target(value={})
>> @Retention(value=RUNTIME)
>> public @interface StoredProcedureParameter {
>> String name default "";
>> ParameterMode mode default ParameterMode.IN;
>> Class type;
>> boolean optional default false;
>> }
>>
>
> What if the provider only supplied the parameters the user actually set
> and let the database decide whether the missing ones were mandatory or
> optional ?
>
> Kind regards
> Rainer
>
>
>
> ---
> Rainer Schweigkoffer SAP AG Walldorf
> Business Solution & Technology TD Core JS&I
> Technology Development Dietmar-Hopp-Allee 16
> Java Server Core D-69190 Walldorf
> JEE Implementation Group phone: +49 6227 7 45305
> Building 3, I.3.14 fax: +49 6227 7 821177
> rainer.schweigkoffer_at_sap.com
>
> Sitz der Gesellschaft/Registered Office: Walldorf, Germany
> Vorstand/SAP Executive Board: Werner Brandt, Angelika Dammann,
> Bill McDermott (Co-CEO), Gerhard Oswald, Vishal Sikka,
> Jim Hagemann Snabe (Co-CEO)
> Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory
> Board: Hasso Plattner
> Registergericht/Commercial Register Mannheim No HRB 350269
>
> Diese E-Mail kann Betriebs- oder Geschaeftsgeheimnisse oder sonstige
> vertrauliche Informationen enthalten. Sollten Sie diese E-Mail
> irrtuemlich erhalten haben, ist Ihnen eine Verwertung des Inhalts,
> eine Vervielfaeltigung oder Weitergabe der E-Mail ausdruecklich
> untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die
> empfangene E-Mail. Vielen Dank.
>
> This e-mail may contain trade secrets or privileged, undisclosed, or
> otherwise confidential information. If you have received this e-mail
> in error, you are hereby notified that any review, copying, or
> distribution of it is strictly prohibited. Please inform us
> immediately and destroy the original transmittal. Thank you for your
> cooperation.
>
>
>