You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by ib...@incubator.apache.org on 2005/03/10 17:46:24 UTC

[Apache iBATIS Wiki] Updated: 3rd Party Contributions

   Date: 2005-03-10T08:46:24
   Editor: KrisSchneider
   Wiki: Apache iBATIS Wiki
   Page: 3rd Party Contributions
   URL: http://wiki.apache.org/ibatis/3rd Party Contributions

   no comment

Change Log:

------------------------------------------------------------------------------
@@ -2,7 +2,9 @@
 
 Alex has created some handy scripts to generate all of your SQL Maps and configuration.  If you're looking to jumpstart your development with iBATIS, this is a good tool to try.  The website is a bit slow, but it's a lot faster than coding by hand. ;)
 
-[^http://alxeg.narod.ru/ibatis/index.html]
+''Attempting to save changes to this page resulted in an error: `Not saving page 3rd Party Contributions because content matches blacklist: nar0d.ru`. So, I changed the link to use TinyURL.''
+
+[^http://tinyurl.com/4fks8]
 
 = Jasmine IDE IBatis GUI =
 
@@ -41,16 +43,33 @@
 Here's a simple config (it's also an example of using an Oracle cursor as an OUT parameter for a stored procedure):
 
 {{{
+<sqlMapConfig>
+
+    <typeAlias alias="result"
+               type="javax.servlet.jsp.jstl.sql.Result"/>
+
+    <typeAlias alias="resultSetHandler"
+               type="com.dotech.ibatis.ResultSetToResultHandler"/>
+
+    <typeHandler javaType="result"
+                 jdbcType="ORACLECURSOR"
+                 callback="resultSetHandler"/>
+</sqlMapConfig>
+}}}
+
+{{{
 <sqlMap>
 
     <parameterMap id="noInputsSingleResult" class="map">
         <parameter property="resultCode"
+                   javaType="int"
                    jdbcType="NUMERIC"
+                   nullValue="-1"
                    mode="OUT"/>
         <parameter property="result"
+                   javaType="result"
                    jdbcType="ORACLECURSOR"
-                   mode="OUT"
-                   typeHandler="com.dotech.ibatis.ResultSetToResultHandler"/>
+                   mode="OUT"/>
     </parameterMap>
 
     <procedure id="getFunds" parameterMap="noInputsSingleResult">