ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: TypeHandlerCallback and stored procedures/functions
Date Fri, 16 Feb 2007 22:05:51 GMT
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 <Jan.Vissers@cumquat.nl> 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 <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