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:
-------------------------------

http://hansonchar.blogspot.com/2005/06/oracle-blob-mapped-to-byte-in.html

Note, with this approach, you may need to use the Oracle 10.1.0.4+ 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(9.0.4.0.0) 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
table. 
> 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

       

Mime
View raw message