Databases
StackOverflow2013
Postsdbo
POStored procedure output parameter set back to POJO by iBATIS
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POStored procedure output parameter set back to POJO by iBATIS
    primarykey
    data
    text
    <p>I'm using iBATIS to call a Stored Procedure on MSSQL Server, the input parameters are properties on a POJO that is put to the map:</p> <pre><code>Map&lt;String, Object&gt; saveMap = new HashMap&lt;String, Object&gt;(); saveMap.put("obj", myArticle); update("save", saveMap); </code></pre> <p>All parameters are set correctly as input to the procedure so nothing wrong there. But one of the parameters is a output-parameter and and I was expecting it to be set back to the POJO but instead one extra mapping <code>"obj.new"=false</code> is put the map by iBATIS. Here's a simplified version of the mapping showing the basic idea:</p> <pre><code> &lt;procedure id="save"&gt; {&lt;include refid="Core.returned_value" /&gt; CALL SPRC_ARTICLE_NAME_SAVE ( &lt;include refid = "Core.common_fields" /&gt; @pArticle_id = #obj.art_id# , @pArtname = #obj.artname# , @pNewArticleName_flg = #obj.new,mode=INOUT# )} &lt;/procedure&gt; </code></pre> <p>After calling the procedure I have two mappings in Map passed to iBATIS:</p> <ul> <li><code>"obj"=POJO</code></li> <li><code>"obj.new"=False</code></li> </ul> <p>Now I see that <a href="http://svn.apache.org/repos/asf/ibatis/java/ibatis-2/trunk/ibatis-2-docs/en/iBATIS-SqlMaps-2_en.pdf" rel="nofollow noreferrer">iBatis documentation</a> saids <em>"When executing stored procedures – iBATIS will create objects for OUTPUT parameters"</em> so it makes sense. But my question is if there a way to instruct iBATIS put back the boolean value to the POJO after the procedure is called? I rather don't do the extra work of getting the value out of the map and set it to the POJO my self.</p> <p>// Uhlén</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBrimstedt
    1. USUhlen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POStored procedure output parameter set back to POJO by iBATIS
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POStored procedure output parameter set back to POJO by iBATIS
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POStored procedure output parameter set back to POJO by iBATIS
      1. USJames P.
      1. VTFavorite
    1. COI found Jeff Butler's answer to this Jeff Butler's answer to this http://groups.google.com/group/mybatis-user/browse_thread/thread/14826bc31c9f143d post to be very helpful when I faced a similar problem (although with a select statement rather than a update)
      singulars
      1. POStored procedure output parameter set back to POJO by iBATIS
      1. USLars Tackmann
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload