Results 1 to 3 of 3
  1. #1
    erakhman is offline Member
    Join Date
    May 2010
    Posts
    14
    Rep Power
    0

    Default Ibatis problem about dao xml

    Hello...

    how to create code for searching process in ibatis dao xml. i have try code like this, but it can't work. i use dbms mysql, thanks for your help.... :)

    Java Code:
    <select id="searchEmployee" parameterClass="varchar" resultMap="EmployeeResult">
    		select * from employee 
    		where first_name = #name:varchar#,  or last_name = #name:varchar#
    	</select>

  2. #2
    travishein's Avatar
    travishein is offline Senior Member
    Join Date
    Sep 2009
    Location
    Canada
    Posts
    684
    Rep Power
    6

    Default

    is it that it is returning no rows, or that it is failing to map the results to the resultMap?

  3. #3
    cmaj135 is offline Member
    Join Date
    Aug 2010
    Location
    China
    Posts
    1
    Rep Power
    0

    Default

    first,you must write the SQL correctly,but i find the extra comma in your ibatis sql,see below
    #name:varchar#, or last_name = #name:varchar#

Similar Threads

  1. insert statement return problem in ibatis
    By dheerajsea123 in forum JDBC
    Replies: 1
    Last Post: 05-20-2010, 10:22 AM
  2. Spring, iBatis and multiple Oracle tablespaces
    By richteri in forum Web Frameworks
    Replies: 1
    Last Post: 01-26-2010, 08:26 AM
  3. innoDB + ibatis
    By vinoopraj in forum Advanced Java
    Replies: 0
    Last Post: 05-19-2009, 09:57 AM
  4. Hibernate vs iBATIS
    By priyanka.dandekar in forum Web Frameworks
    Replies: 3
    Last Post: 11-11-2008, 10:59 AM
  5. Tomcat iBatis log4j
    By Tokajac in forum Web Frameworks
    Replies: 0
    Last Post: 07-17-2008, 03:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •