hi, we have a problem, we are trying to do this to obtain a cursor from oracle calling a stored procedure...
| I have modified the framework to allow all oracle cursors to be mapped by a statement's resultMap so you can call the queryForList() method and have the oracle cursor results returned in the list. I also added the ability to specifiy a resultMap to use with each of the oracle cursor parameters to support the queryForObject() call. I have tested this code with IBATIS 2.1.6.598
here are my sample sqlMap:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap>
<typeAlias alias="Employee" type="test.Employee" />
<resultMap id="employee-map" class="Employee">
<result property="name" column="ENAME" />
<result property="employeeNumber" column="EMPNO" />
<result property="departmentNumber" column="DEPTNO" />
</resultMap>
<parameterMap id="single-rs" class="map" >
<parameter property="in1" jdbcType="int" javaType="java.lang.Integer" mode="IN"/>
<parameter property="output1" jdbcType="ORACLECURSOR" mode="OUT"/>
</parameterMap>
<procedure id="GetSingleEmpRs" parameterMap="single-rs" resultMap="employee-map">
{ call scott.example.GetSingleEmpRS(?, ?) }
</procedure>
<parameterMap id="double-rs" class="map" >
<parameter property="in1" jdbcType="int" javaType="java.lang.Integer" mode="IN"/>
<parameter property="output1" jdbcType="ORACLECURSOR" mode="OUT" resultMap="employee-map" />
<parameter property="output2" jdbcType="ORACLECURSOR" mode="OUT" resultMap="employee-map" />
</parameterMap>
<procedure id="GetDoubleEmpRs" parameterMap="double-rs" >
{ call scott.example.GetDoubleEmpRS(?, ?, ?) }
</procedure>
</sqlMap>
Here is my sample code that makes use of the maps:
Main.java
package test;
import java.io.Reader;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class Main {
public static void main(String arg[]) throws Exception {
String resource;
Reader reader;
List list;
SqlMapClient sqlMap;
resource = "test/SqlMapConfig.xml";
reader = Resources.getResourceAsReader (resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
Map map = new HashMap();
map.put("in1", new Integer(10));
// use queryForList because the procedure map defines a resultmap
// for the statement
list = sqlMap.queryForList("GetSingleEmpRs", map);
System.out.println("--------------------");
System.out.println( list );
System.out.println("--------------------");
map = new HashMap();
map.put("in1", new Integer(10));
// use queryForObject because the procedure map does not define a
// result map for the statement
sqlMap.queryForObject("GetDoubleEmpRs", map);
System.out.println("--------------------");
System.out.println( map.get("output1"));
System.out.println( map.get("output2"));
System.out.println("--------------------");
}
} |
|
but we obtain an error about the xml and the dtd, we have the version of ibatis
2.1.6.589 so we have seen that in 2.1.6.598 the dtd is correct?? please, some help....
how can we have the version 2.1.6.598? in the ibatis web we downloaded the 2.1.6.589 ... but this doesn´t allow to put a resultMap inside the parameter in parameterMap. Please, help!!!
thanks in advance!!! |
|
| Esperanza Echeverría de Miguel
Steria España http://www.steria.es
C/Menéndez y Pelayo,3 bis 46010 Valencia
Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
[EMAIL PROTECTED] |
- i have a question, please, some help Esperanza . Echeverria
-
