Return-Path: 
 <user-java-return-9385-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 42690 invoked from network); 12 Oct 2006 11:37:00 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 12 Oct 2006 11:37:00 -0000
Received: (qmail 97367 invoked by uid 500); 12 Oct 2006 11:36:59 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 97308 invoked by uid 500); 12 Oct 2006 11:36:58 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 97296 invoked by uid 99); 12 Oct 2006 11:36:58 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Oct 2006 04:36:58 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=DNS_FROM_RFC_ABUSE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 66.249.82.237 as permitted sender)
Received: from [66.249.82.237] (HELO wx-out-0506.google.com) (66.249.82.237)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Oct 2006 04:36:57 -0700
Received: by wx-out-0506.google.com with SMTP id h30so466780wxd
        for <user-java@ibatis.apache.org>;
 Thu, 12 Oct 2006 04:36:36 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=mUvQ8iLChOlU2uyt0h2vPiPQgMcSdWtn+0kI+b0PlAvZ2HuLoq8xRzDWIrKspxHDSHo+es5yKdy/ikrRLD41OtLXLaufTV3Qx2TYNSeNhAZzLj5fdq0fpySoQIpLZBXoCsz5770nNPauq5CbNCs9SP3vL9tJv9+rfM/to9kVAqA=
Received: by 10.90.105.19 with SMTP id d19mr1068721agc;
        Thu, 12 Oct 2006 04:36:36 -0700 (PDT)
Received: by 10.90.87.17 with HTTP; Thu, 12 Oct 2006 04:36:36 -0700 (PDT)
Message-ID: <a10a823c0610120436g633e6036re871fd940cfa5cbc@mail.gmail.com>
Date: Thu, 12 Oct 2006 05:36:36 -0600
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Dynamic packages
In-Reply-To: 
 <OF227152A6.F18F4CF1-ONC1257205.00384A02-C1257205.003A876B@ads.it>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <OF227152A6.F18F4CF1-ONC1257205.00384A02-C1257205.003A876B@ads.it>
X-Google-Sender-Auth: ca733255a5af5cad
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Put the bean in the Map, call it "bean" and refer to it's properties
in the mapped statement (or parameter map) with a "bean." prefix:
"bean.someProperty".

There are not many examples of the Java code because it's pretty much
all the same:

sqlMapClient.almostAnyMethod("namespace.statement", parameterObject);

Larry

On 10/12/06, C.Zecca@ads.it <C.Zecca@ads.it> wrote:
>
>
> Hi all
>
>  I have to pass at runtime the package name to access its get_key_1(),
> get_key_2(), ... methods
>
>  The aim is to get the feneration of the
>
> { ut_Tipo_Dato.get_key_2( ? )  }
>  { ut_Voce.get_key_2( ? )  }
>  to retrieve data for stored package procedures such as
>
>  procedure get_key_2
>  ( p_tipo_dato_ID out number(10)
>  );
>
>
>  Well, where to begin?
>
>  By using the $$ syntax ?
>
> $packageId$.get_key_2( ? )
>  Using both $substitution$ and #parameters# along with <iterate> (Dynamic
> tables thread)?
>
>  Using Dynamic Mapped Statements? (pag. 46, iBATIS-SqlMaps-2_en.pdf)?
>
>  Unfortunately I have not found yet a simple and complete example provided
> with both the XML config specification and the mini Java snippet code that
> exerts it.
>
>  I guess that we have to use any Map to provide parameters, but there is, as
> well, che OUT parameter for the procedure itself.
>  How to combine the parameterMap, the JavaBean class (devoted to the
> procedure parameters) and the $sobstitution$ parameters?
>
>  A complete example would be of great help to start!
>
>
>  Thanks in advance
>
>  Cesare
>
>