Oracle XMLType support

[Jan Vissers <Ja...@cumquat.nl>]

Hi,

I'm trying to figure out what we need to do in order to make use of 
Oracle's XMLType database object - as part of a sqlMap. I've been 
briefly thinking about a way to implement the TypeHandlerCallback 
interface, but it seems to me that this will not work. Using straight 
JDBC, we're able to query and manipulate XMLType using Oracle JDBC 
things like OraclePreparedStatement/OracleCallableStatement, 
OracleResultset, OPAQUE and XMLType (available in xdb.jar).

I would love to hear from you guys, whether such a thing is at all possible.

Thx,
Jan.

-- 
Cumquat Information Technology
De Dreef 19
3706 BR Zeist
T +31 (0)30 - 6940490
F +31 (0)10 - 6940499
http://www.cumquat.nl

Jan.Vissers-at-cumquat.nl
M +31 6 5 11 169 556

Re: Oracle XMLType support

[Brandon Goodin <br...@gmail.com>]

If you can pass the XML Type into a non-oracle specific Java
Type/Class then you should have no problem creating a custom type
handler. If the XML Type requires a database connection then you will
need to stick to straight JDBC. iBatis is JDBC compliant. We provide
CustomType Handlers for cases when you need to handle a non-standard
type.

Brandon

On 6/2/05, Jan Vissers <Ja...@cumquat.nl> wrote:
> Hi,
> 
> I'm trying to figure out what we need to do in order to make use of
> Oracle's XMLType database object - as part of a sqlMap. I've been
> briefly thinking about a way to implement the TypeHandlerCallback
> interface, but it seems to me that this will not work. Using straight
> JDBC, we're able to query and manipulate XMLType using Oracle JDBC
> things like OraclePreparedStatement/OracleCallableStatement,
> OracleResultset, OPAQUE and XMLType (available in xdb.jar).
> 
> I would love to hear from you guys, whether such a thing is at all possible.
> 
> Thx,
> Jan.
> 
> --
> Cumquat Information Technology
> De Dreef 19
> 3706 BR Zeist
> T +31 (0)30 - 6940490
> F +31 (0)10 - 6940499
> http://www.cumquat.nl
> 
> Jan.Vissers-at-cumquat.nl
> M +31 6 5 11 169 556
> 
> 
>