ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jan Vissers" <Jan.Viss...@cumquat.nl>
Subject Re: TypeHandlerCallback and stored procedures/functions
Date Fri, 16 Feb 2007 20:36:17 GMT
> 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 <Jan.Vissers@cumquat.nl> 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* <Jan.Vissers@cumquat.nl
>> > <mailto:Jan.Vissers@cumquat.nl>> 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* < Jan.Vissers@cumquat.nl
>> >     <mailto:Jan.Vissers@cumquat.nl>
>> >     > <mailto:Jan.Vissers@cumquat.nl <mailto:Jan.Vissers@cumquat.nl>>>
>> >     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 Jan.Vissers@cumquat.nl <mailto:Jan.Vissers@cumquat.nl>
>> >     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 Jan.Vissers@cumquat.nl
>> M +31 6 51 169 556
>> B http://www.cumquat.nl/technology_atom10.xml
>>
>>
>>
>



Mime
View raw message