ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrey (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-309) Cannot insert into Database Blob using IBATIS DAO
Date Sat, 19 Aug 2006 06:37:14 GMT
    [ http://issues.apache.org/jira/browse/IBATIS-309?page=comments#action_12429184 ] 
Andrey commented on IBATIS-309:


Note, with this approach, you may need to use the Oracle JDBC thin driver regardless
to get around a problem related to the blob size greater than 2K bytes (even if you are running
the Oracle 9.2.0.x database). Apparently it's related to a bug in the 9.2.0.x JDBC driver.

> Cannot insert into Database Blob using IBATIS DAO
> -------------------------------------------------
>                 Key: IBATIS-309
>                 URL: http://issues.apache.org/jira/browse/IBATIS-309
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps, DAO
>    Affects Versions: 2.1.7
>         Environment: Windows 2000, Oracle Application Server and latest version of IBATIS
>            Reporter: sunil kumar
> I am using Oracle Application Server 10g( with latest version of IBatis. I
am uploading a file and inserting file data as byte[] in the database field which is a Blob.
I keep on getting SQLException:Data size bigger than max size for this type when i try to
insert. If i take out the file data from my insert statement , a record is inserted into the
> My xml mapping file is:
> code:
> --------------------------------------------------------------------------------
> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="testblob"> 	<typeAlias alias="testForm" type="gov.usaid.testblob.domain.TestForm"
/> 	<resultMap id="testFileResult" class="testForm">	 	<result property="fileId"
    column="FILE_ID" />	    <result property="fileType" column="FILE_TYPE" /> 	 
<result property="fileName"   column="FILE_NAME" />	 	<result property="fileData"
  column="FILE_DATA"  jdbcType="BLOB"/>		<result property="fileSize"   column="FILE_SIZE"/>
						</resultMap>	<!--  <select id="downloadFile" resultMap="testFileResult"
parameterClass="string">		select * from test_file where file_id=#value#	</select>-->
<insert id="saveFile" parameterClass="testForm">	  <selectKey resultClass="int" keyProperty="fileId">
		select SQ_REF_FILE_ID.nextval as FILE_ID from dual	  </selectKey>		insert into TEST_FILE
(FILE_ID,FILE_TYPE,FILE_NAME,FILE_SIZE,FILE_DATA)		values (#fileId#, #fileType:VARCHAR#, #fileName#,
#fileSize#,#fileData#)	</insert>			</sqlMap>    

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message