I think the answer to your first question is "yes". But you should use the advanced inline parameter syntax shown in the user's guide on about page 29. Then you can specify the type handler directly for the parameter and you don't have to worry about what the JDBC type might be.
Jeff Butler On 2/16/07, Jan Vissers <[EMAIL PROTECTED]> wrote:
> True/False - You have a procedure that you are calling False - it's a stored function (Oracle) > True/False - You have an OUT/INOUT Parameter that is returning as an > ORACLECURSOR False - it's an Oracle XMLType (Oracle specific datatype) > True/False - You want to convert this returned ORACLECURSOR to xml False - See above _j > Help get this straight in my noggin :) > > True/False - You have a procedure that you are calling > True/False - You have an OUT/INOUT Parameter that is returning as an > ORACLECURSOR > True/False - You want to convert this returned ORACLECURSOR to xml > > If i'm all false here then please explain to me what you want to > accomplish > and leave out any ibatis terms. For example, "I have a procedure that > returns a resulset/cursor. I want to convert it to xml. How do i do that?" > > Brandon > > On 2/16/07, Jan Vissers <[EMAIL PROTECTED]> wrote: >> >> Guess so... or maybe I'm stupid. >> >> Given the XmlTypeHandler which is in the wiki what should I set the >> JDBCType to in the inline parameter map, >> when clearly there is no fitting type in the JdbcRegistry. For Oracle >> REF CURSORs we've got ORACLECURSOR >> but do we have for Oracle's XMLTYPE ??? Tried OTHER and OBJECT... >> >> Hope this clears things up a bit. >> -J. >> >> >> Brandon Goodin wrote: >> > I guess i don't understand what you are asking. A TypeHandler handles >> > *a* type from/to the database. It seems to me like you are >> > misunderstanding the purpose of a type handler. I would recommend you >> > to the iBATIS SQLMap Guide ( >> > http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf ). >> > Either that or you need to give me a more precise understanding of >> > what you are wanting to accomplish. >> > >> > Regards, >> > Brandon >> > >> > On 2/16/07, *Jan Vissers* <[EMAIL PROTECTED] >> > <mailto:[EMAIL PROTECTED]>> wrote: >> > >> > Any idea...? >> > >> > Brandon Goodin wrote: >> > > TypeHandlers work the same for procedure results as they do for >> > > anything else. Are you having a specific problem? >> > > >> > > Brandon >> > > >> > > On 2/15/07, *Jan Vissers* < [EMAIL PROTECTED] >> > <mailto:[EMAIL PROTECTED]> >> > > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] >>> >> > wrote: >> > > >> > > This might be a stupid question, >> > > >> > > Is it possible to have something similar to what you can do >> with >> > > TypeHandlerCallbacks and select statements/resultsets >> > > with stored functions and or procedures? >> > > >> > > Thx, >> > > -J. >> > > >> > > >> > >> > -- >> > Cumquat Information Technology >> > De Dreef 19 >> > 3706 BR Zeist >> > T +31 (0)30 - 6940490 >> > F +31 (0)30 - 6940499 >> > W http://www.cumquat.nl >> > >> > E [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> > M +31 6 51 169 556 >> > B http://www.cumquat.nl/technology_atom10.xml >> > >> > >> > >> >> -- >> Cumquat Information Technology >> De Dreef 19 >> 3706 BR Zeist >> T +31 (0)30 - 6940490 >> F +31 (0)30 - 6940499 >> W http://www.cumquat.nl >> >> E [EMAIL PROTECTED] >> M +31 6 51 169 556 >> B http://www.cumquat.nl/technology_atom10.xml >> >> >> >
