Sure..!
bpamarti wrote:
>
> Perfect!!
>
> Thanks a bunch!
>
> mfs <[EMAIL PROTECTED]> wrote:
>
> Actually i dont work on the List of beans (and i thought thats what u
> meant
> earlier)..i dont work on the resultset type at all, thats what i would
> expect the ibatis framework to take care of transform the resultset
> entries into a list of bean as i configured in sql-map config file..
>
> Here is my test client..
>
> String resource;
> Reader reader;
> SqlMapClient sqlMap;
> resource = "company/xyz/core/persistence/sql-map-config.xml";
> reader = Resources.getResourceAsReader(resource);
> sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
> MyCertificate myCertificate = null;
>
> HashMap params = new HashMap();
> // input criteria of type mode="IN"
> params.put("criteriaParam", new String("Int"));
>
> sqlMap.queryForObject(
> "getMyCertificateByName", params);
> // mode="out" cursorparam part of the parameterMap, in which i ex
> List list = (List) params.get("outputCursorParam");
>
> Iterator iterator = list.iterator();
> /* END */
>
> while (iterator.hasNext())
> {
> myCertificate = (MyCertificate) iterator.next();
> System.out.println("--------------------");
> System.out.println(myCertificate.getName());
> System.out.println(myCertificate.getDate());
> System.out.println("--------------------");
> }
>
> ----
> mapping file.xml
>
>
>
>
> javaType="java.lang.String" mode="IN"/>
>
> jdbcType="ORACLECURSOR" mode="OUT" resultMap="resultMap[which is
> MyCertificate bean mapping]"/>
>
>
>
>
>
> { call
> vcert.concept_test_clerk_ui_api.get_certs_by_business_name(?, ?) }
>
>
>
>
> Let me know if it helps..
>
>
>
> bpamarti wrote:
>>
>> I was just concerned when you said "Its working now" and your code says
>> you are getting the List (of beans) directly.
>>
>> If anyone can show me the code for getting the "List of beans" directly
>> instead of "ResultSet" while using oracle stored procedures with REF
>> CURSOR as OUT parameter I would appreciate. :)
>>
>> Cheers!
>>
>>
>> "Peace is found not in what surrounds us, but in what we hold within."
>>
>>
>>
>> ---------------------------------
>> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
>> now.
>>
>
> --
> View this message in context:
> http://www.nabble.com/Protocol-Error---SimpleDataSource.pushConnection%28%29-when-using-oraclecursors-tp17093837p17111540.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
>
>
> "Peace is found not in what surrounds us, but in what we hold within."
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
> now.
>
--
View this message in context:
http://www.nabble.com/Protocol-Error---SimpleDataSource.pushConnection%28%29-when-using-oraclecursors-tp17093837p17115481.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
