You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Dean Murray <de...@hc-sc.gc.ca> on 2009/04/22 13:32:37 UTC
cannot retrieve a blob using a callable statement.
Note: If this is the second time this email appears, I sent this before I
registered so I am not sure if the first one got through.
Hi
I am using IBATIS 2.3 in a Spring Framework and the stored procedure is in
a Oracle 10g database. The error I get is Retrieving LOBs from a
CallableStatement is not supported; . Is there a way to retrieve BLOBS
using a callable statement. I was able to do it using a select but now I
need to make this stored procedure call.
<parameterMap class="BatchReport" id="batchReportMap">
<parameter property="reportId" jdbcType="INTEGER" javaType
="java.math.BigDecimal" mode="INOUT"/>
<parameter property="creationDate" jdbcType="DATE"
javaType="java.util.Date" mode="OUT" />
<parameter property="reportType" jdbcType="VARCHAR"
javaType="java.lang.String" mode="OUT"/>
<parameter property="reportNm" jdbcType="VARCHAR" javaType
="java.lang.String" mode="OUT"/>
<parameter property="report" jdbcType="BLOB" javaType="[B"
mode="OUT"/>
<parameter property="sendInd" jdbcType="VARCHAR" javaType=
"java.lang.String" mode="OUT"/>
<parameter property="batchIdCd" jdbcType="INTEGER"
javaType="java.math.BigDecimal" mode="OUT"/>
<parameter property="processorId" jdbcType="VARCHAR"
javaType="java.lang.String" mode="OUT"/>
<parameter property="modifiedBy" jdbcType="VARCHAR"
javaType="java.lang.String" mode="OUT"/>
<parameter property="modifiedTime" jdbcType="DATE"
javaType="java.util.Date" mode="OUT"/>
</parameterMap>
<procedure id="getBatchReport" parameterMap="batchReportMap"
resultClass="BatchReport" >
{call dose.crypto_pkg.get_Batch_Report(?,?,?,?,?,?,?,?,?,?)}
</procedure>
Dean Murray
RE: cannot retrieve a blob using a callable statement.
Posted by "Givler, Eric" <eg...@state.pa.us>.
See: http://www.mail-archive.com/dev@ibatis.apache.org/msg02854.html
-----Original Message-----
From: M V Chetan [mailto:chetan.minajagi@tcs.com]
Sent: Friday, October 02, 2009 6:00 AM
To: user-java@ibatis.apache.org
Subject: Re: cannot retrieve a blob using a callable statement.
I have been looking around for examples for using CLOB/BLOB through a stored proc.Can anyone share a working example.Btw,I'm using Ibatis 2.3
Regards,
Chetan
--
View this message in context: http://www.nabble.com/cannot-retrieve-a-blob-using-a-callable-statement.-tp23174503p25713249.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
RE: cannot retrieve a blob using a callable statement.
Posted by "Givler, Eric" <eg...@state.pa.us>.
This is something we've struggled with on our team. AFAIK, Oracle's JDBC drivers do not support the passing of BLOB data in excess of 32K through a stored procedure, at least with the drivers that are included with Oracle A/S 10.1.2. You might try downloading a newer version of the drivers first and see if that works, provided you even have the option of changing the driver in your runtime environment (you won't with Oracle A/S).
In the meantime, I'll try and look for an example that attempted to do this. I don't see why it would be an issue to READ the blob with a simple SELECT?
Later,
Eric
-----Original Message-----
From: M V Chetan [mailto:chetan.minajagi@tcs.com]
Sent: Friday, October 02, 2009 6:00 AM
To: user-java@ibatis.apache.org
Subject: Re: cannot retrieve a blob using a callable statement.
I have been looking around for examples for using CLOB/BLOB through a stored proc.Can anyone share a working example.Btw,I'm using Ibatis 2.3
Regards,
Chetan
--
View this message in context: http://www.nabble.com/cannot-retrieve-a-blob-using-a-callable-statement.-tp23174503p25713249.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: cannot retrieve a blob using a callable statement.
Posted by M V Chetan <ch...@tcs.com>.
I have been looking around for examples for using CLOB/BLOB through a stored
proc.Can anyone share a working example.Btw,I'm using Ibatis 2.3
Regards,
Chetan
--
View this message in context: http://www.nabble.com/cannot-retrieve-a-blob-using-a-callable-statement.-tp23174503p25713249.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org