On 10/21/06, Sameeh Harfoush <[EMAIL PROTECTED]
> wrote:
I had the same problem using ibatis on Spring framework
check your Oracle driver.On 10/20/06, John Chien < [EMAIL PROTECTED]> wrote:Dear Sir:
I defined a Oracle tale INSP_RULE with following columns:
*****************************************
rule_id number
rule_number varchar2(20)
rule_description BLOB
rule_file_ext varchar2(5)
*****************************************
I defined a Java Class
******************************************
public class Rule {
private String id,
private String rule_number,
private byte[] descriptionData,
private String extension
..........................................
}
******************************************
I defined a resultMap
*********************************************
<resultMap id="downloadBeanMap" class="downloadBean">
<result property="id" column="RULE_ID" />
<result property="rule_number" column="RULE_NUMBER" />
<result property="extension" column="RULE_FILE_EXT" />
<result property="descriptionData" column="RULE_DESCRIPTION"
jdbcType="BLOB" />
</resultMap>
*********************************************************************
The downloadBean corresponds to the "Rule" class.
I used the follwoing IBATIS statement to reterieve data
***************************************************
<statement id="getRuleTextByRuleNumber"
parameterClass="java.lang.String" resultMap="downloadBeanMap">
SELECT RULE_ID,
RULE_NUMBER,
RULE_FILE_EXT,
RULE_DESCRIPTION
FROM INSP_RULE
WHERE IRULE_NUMBER = #value#
</statement>
**********************************************************
The description file was in PDF format. It was stored into database
correctly. It has been verified.
However, when I retrieve the data,
The descriptionData has always 86 bytes. The data retrieved is not
satisfactory.
What is the reason ??
Thanks,
John Chien
