Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 58770 invoked from network); 15 Sep 2008 17:11:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 15 Sep 2008 17:11:15 -0000 Received: (qmail 15696 invoked by uid 500); 15 Sep 2008 17:11:09 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 15686 invoked by uid 500); 15 Sep 2008 17:11:09 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 15675 invoked by uid 99); 15 Sep 2008 17:11:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Sep 2008 10:11:09 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of balar4u@gmail.com designates 74.125.46.152 as permitted sender) Received: from [74.125.46.152] (HELO yw-out-1718.google.com) (74.125.46.152) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Sep 2008 17:10:11 +0000 Received: by yw-out-1718.google.com with SMTP id 5so760197ywr.6 for ; Mon, 15 Sep 2008 10:10:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=IW5++Zp6nNTmJ73oGcJ2AM/eli/4o7fM5r+jEu/4bTQ=; b=x0oYjGS7ZRWQ+iIHF4bySVanmkCIIKKh9wkLlfI4za74otlayRmamwkNS0r7/03r2R 91Y4FtD9tSq0pPG85SPbn0fu0hY//ysjm0AHCiYUNfomyWaBNdRgecNARzh9prqyqyy0 py1zBIU180sNOyxd8AMP+5xv1OLfMyd1yWZeE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=nkjLMF2um5XPTp15Iwyb3ci5zAnLcVhLL14urRmT68m967/eYY7eEiCzta3nFAIVPY Zj8GB2MB1NJrzYZ9pBO91ai4/wcIYvHgGwSgg6UJro093btGk8dF9rB7OhgeQjFe/lWx j/RwcuctvXUNWLG0kxhsMOSo+1mY6N4xseKUU= Received: by 10.103.179.17 with SMTP id g17mr3167598mup.71.1221498642316; Mon, 15 Sep 2008 10:10:42 -0700 (PDT) Received: by 10.103.199.3 with HTTP; Mon, 15 Sep 2008 10:10:42 -0700 (PDT) Message-ID: <631123700809151010p74d27d6cqa719428654ef45bb@mail.gmail.com> Date: Mon, 15 Sep 2008 13:10:42 -0400 From: "bala r" To: user-java@ibatis.apache.org Subject: Re: XMLTypeHandlerCallback issue with using DBCP datasource in websphere. In-Reply-To: <631123700809121214j31425d1ap326a7781e40f9ab5@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3699_13440044.1221498642304" References: <631123700809121214j31425d1ap326a7781e40f9ab5@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_3699_13440044.1221498642304 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi All, Update for this issue... I noticed that i have included com.ibm.ws.runtime_6.1.0.jar in my RAD classpath. when i remove this jar from RAD i got the same issue for DelegatingCallableStatement instance. So i included the same jar in my project build and deployed in Websphere. Now it works fine. Thanks Bala. On Fri, Sep 12, 2008 at 3:14 PM, bala r wrote: > Hi All, > I got some weird issue. > I am using Ibatis XMLtypeHandlerCallback to store XML type data into oracle > Database. > Datasource i am using DBCP datasource and configured in Spring Context > file. > > When i run my application in RAD, the setter.getPreparedStatement() in > XMLtypeHandlerCallback ::setParameter(). > method returns an instance of > org.apache.commons.dbcp.DelegatingCallableStatement and my application works > fine. > > But when i deploy my application to Websphere 6.1, the > setter.getPreparedStatement() is returning an instance of Proxy$5 and my > application fail to store xmltype content as OPS is null. > > Any one got this issue and any solution ? > > Thanks in advance. > > Thanks > Bala. > ------=_Part_3699_13440044.1221498642304 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi All,

Update for this issue...

I noticed that i have included com.ibm.ws.runtime_6.1.0.jar in my RAD classpath. when i remove this jar from RAD i got the same issue for DelegatingCallableStatement instance.
So i included the same jar in my project build and deployed in Websphere. Now it works fine. 

Thanks
Bala.


On Fri, Sep 12, 2008 at 3:14 PM, bala r <balar4u@gmail.com> wrote:
Hi All,
I got some weird issue.
I am using Ibatis XMLtypeHandlerCallback to store XML type data into oracle Database.
Datasource i am using DBCP datasource and configured in Spring Context file.

When i run my application in RAD,  the setter.getPreparedStatement() in XMLtypeHandlerCallback ::setParameter().
method returns an instance of org.apache.commons.dbcp.DelegatingCallableStatement and my application works fine.

But when i deploy my application to Websphere 6.1, the setter.getPreparedStatement() is returning an instance of Proxy$5  and my application fail to store xmltype content as OPS is null.

Any one got this issue and any solution ?

Thanks in advance.

Thanks
Bala.

------=_Part_3699_13440044.1221498642304--