Re: Help needed for Handling Oracle XMLType in Ibatis

2008-08-21 Thread bala r
Hi , I solved the issue XMLType.CreateXML method returns null when i pass ops.getConnection and (Document)parameter. Instead of passwing Document arugment i converted document to StringWriter using Transformer and the passed String object in the XMLType.createXML . Now the storedProcedure succes

Re: Help needed for Handling Oracle XMLType in Ibatis

2008-08-21 Thread bala r
Hi, I am using Apache-Common DBCP datasource with Spring&Ibatis. So i have followed Juans example(Comment section) for getting oraclePreparedStatement in the following URL. http://opensource.atlassian.com/confluence/oss/display/IBATIS/XMLTypeHandlerCallback.java I modified the setParameter as ex

Re: Help needed for Handling Oracle XMLType in Ibatis

2008-08-20 Thread bala r
Jeff, I modifed the setParameter method, But i am getting xmlInput is null and throws Pl/sql Wrong Number or types of arguments in call to Load. Here is the line XMLType xmlInput = XMLType.createXML(ops.getConnection(),(Document)parameter); After this line execute the xmlInput object is null..

Re: Help needed for Handling Oracle XMLType in Ibatis

2008-08-20 Thread Jeff Butler
You will need to make a similar modification to the setParameter method in the type handler. Jeff Butler On Wed, Aug 20, 2008 at 1:42 PM, bala r <[EMAIL PROTECTED]> wrote: > Jeff, > I think the solution is for SELECT not for Insert/Update.. > I am having issue when i execute insert/update statem

Re: Help needed for Handling Oracle XMLType in Ibatis

2008-08-20 Thread bala r
Jeff, I think the solution is for SELECT not for Insert/Update.. I am having issue when i execute insert/update statement inside the Procedure.. Thanks Bala. On Wed, Aug 20, 2008 at 12:12 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > Wow - impatient! > > A simple google query lead me to this: >

Re: Help needed for Handling Oracle XMLType in Ibatis

2008-08-20 Thread bala r
Thanks Jeff. I will try this solution. Thanks Bala. On Wed, Aug 20, 2008 at 12:12 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > Wow - impatient! > > A simple google query lead me to this: > > https://issues.apache.org/jira/browse/IBATIS-397 > > There is a known issue with iBATIS when using proced

Re: Help needed for Handling Oracle XMLType in Ibatis

2008-08-20 Thread Jeff Butler
Wow - impatient! A simple google query lead me to this: https://issues.apache.org/jira/browse/IBATIS-397 There is a known issue with iBATIS when using procedures and type handlers together with Oracle. There is a suggested workaround in this bug report that requires a simple modification to iBA