Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread mfs
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

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread BalaKishore Pamarti
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 l

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread BalaKishore Pamarti
Yup works perfectly. sqlMap.queryForObject("getRefs", map); System.out.println(map.get("o")); The above system.out statement prints "ResultSet". I was wanting a collection of java beans. queryForList() doesnt work, it returns am empty List Larry Meadors <[EMAIL PROTECTED]> wrote:

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread mfs
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 t

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread Larry Meadors
http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=5653 Works perfectly. Larry On Wed, May 7, 2008 at 12:12 PM, BalaKishore Pamarti <[EMAIL PROTECTED]> wrote: > I was just concerned when you said "Its working now" and your code says you > are getting the List (of beans)

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread BalaKishore Pamarti
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

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread mfs
You are right..i had to iterate through the list to get the results, didnt put that properly too, but i didnt know this problem earlier, since i was stuck in a totally another issue which never let the control reach here.. Let me know if u want me to paste the code.. bpamarti wrote: > > Hi, >

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-07 Thread bpamarti
Hi, Are you able to get the data in the "List"? My understanding is that Oracle Cursor returns a resultset and we need to iterate through the resultset and populate a List with the beans. String resource; Reader reader; SqlMapClient sqlMap; resource = "compa

Re: Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-06 Thread mfs
So turns out it was jdbc driver version issue, though initially i was using the jdbc driver version as my database version but i had to upgrade to the next rather the latest version in the 10 series i.e. 10.2.0.4.0 to get the problem fixed.. Thanks anyways.. mfs wrote: > > Guys, > > I just

Protocol Error - SimpleDataSource.pushConnection() when using oraclecursors

2008-05-06 Thread mfs
Guys, I just started using iBatis, and i think its a great framework, and would want to employ the same in our company for the persistance layer...Also "iBatis in Action" is a very well written book, great job Clinton, Larry and Brandon... Anyways coming to the problem...So am facing this "proto