hbwf / mybatis

Automatically exported from code.google.com/p/mybatis
0 stars 0 forks source link

mybatis column blob search return empty #474

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What version of the MyBatis are you using?
mybatis3.0.6(with mybatis spring 1.0.3 snapshot)

Please describe the problem.  Unit tests are best!
I want to select some special record from my table(which include the blob 
column),

I use the query condition like like : 
select * from table b where b.state in(?,?) and b.types in(?,?,?,?)

What is the expected output? What do you see instead?
The record should be listed according to my query condition.

Please provide any additional information below.
1.I use mybatis-generator 1.3.2 snaphsot to build the mapper'file with the blob.
default is selectByExampleWithBLOBs
1.1 resultMap
<resultMap id = "BaseResultMap">
   <!--egnore -->
</resultMap>

<resultMap extends="BaseResultMap" id="ResultMapWithBLOBs" type="Bean">
    <result column="REQ_MSG" jdbcType="BLOB" property="reqMsg" />
</resultMap>

1.2 <select id="selectByExampleWithBLOBs" 
parameterType="com.ylink.card.ws.basic.entity.CardTradeMsgExample" 
resultMap="ResultMapWithBLOBs">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from b
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
  </select>

1.3 when I use the timer thread which I will call the mapper to fetch the code
(just call the method of 'selectByExampleWithBLOBs') I could not fetch any 
record from the table but once I use PL/SQL or other DB Browser(like in eclipse)
the records returned as my will.

1.4 my jdbc driver is ojdbc14_g.jar 

so I hope mybatis team could help me to point out the reason why I could not 
fetch any record for I checked any detail of my mapper.

Original issue reported on code.google.com by jerrysco...@gmail.com on 22 Dec 2011 at 6:23

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Please post at least a debug log.

Original comment by eduardo.macarron on 6 Feb 2012 at 5:41

GoogleCodeExporter commented 9 years ago
No response.

Original comment by eduardo.macarron on 12 Feb 2012 at 7:12

GoogleCodeExporter commented 9 years ago
No response.

Original comment by eduardo.macarron on 12 Feb 2012 at 7:12