Stack Overflow
Stack Overflow

Questions tagged [ibatis]

iBatis is an object-relational mapping framework for Java. It uses XML descriptors to bridge SQL queries and Java objects. An official port was created for the Microsoft .NET framework.

Apache retired iBatis in June 2010 and it is now developed under the 'MyBatis' name.

Useful links

1073 questions
87
votes
6 answers

Hibernate Vs iBATIS

For our new product re-engineering, we are in the process of selecting the best framework from Java. As the consideration is to go for database agnostic approach for model, we are working on options between Struts + Spring with iBATIS or Hibernate.…
user241394
67
votes
12 answers

Hibernate, iBatis, Java EE or other Java ORM tool

We're in the process of planning a large, enterprise application. We're focusing our efforts on evaluating hibernate after experiencing the pains of J2EE. It looks like the new Java EE API is simpler. I've also read some good things about Hibernate…
Kevin Williams
  • 2,588
  • 3
  • 24
  • 25
40
votes
2 answers

Difference between ibatis and mybatis

What is the difference between iBatis and myBatis? Where can i find a perfect example of those ? Please suggest. I went through Google and could not find any links for this question.
abhay sachu
  • 433
  • 2
  • 5
  • 6
33
votes
9 answers

How to use Annotations with iBatis (myBatis) for an IN query?

We'd like to use only annotations with MyBatis; we're really trying to avoid xml. We're trying to use an "IN" clause: @Select("SELECT * FROM blog WHERE id IN (#{ids})") List selectBlogs(int[] ids); MyBatis doesn't seem able to pick out the…
dirtyvagabond
  • 1,881
  • 2
  • 19
  • 23
32
votes
8 answers

How to convert List into comma separated String
I am getting list of Address objects from the DB call. ArrayList
addresses = new ArrayList<>(); Each Address has an int addressId property. I am writing an update query where in the IN clause I am sending this whole list of Address…
user9193174
  • 363
  • 1
  • 4
  • 12
31
votes
1 answer

Return HashMap in mybatis and use it as ModelAttribute in spring MVC

I want to display list of categories in my Jsp page using spring mvc @modelAttribute. In my mapper.xml file is In my Mapper.java class I have…
Harry
  • 4,705
  • 17
  • 73
  • 101
29
votes
3 answers

When to use $ vs #?

I am confused about using $ vs #. I didn't found any guides for this. I used them as name = #{name}, name like '%${word}%', order by name ${orderAs},where name = #{word} Sometimes , these are work fine but at the sometimes , parameters aren't…
Cataclysm
  • 7,592
  • 21
  • 74
  • 123
26
votes
10 answers

Unable to convert MySQL date/time value to System.DateTime

I am using ibatis and C#. i get a result from a select query that has CreatedDate as one of the field. The Datatype of CreatedDate in Mysql is Date. I assign the result set of the select query to a Ilist< DeliveryClass>. Here the DeliveryClass…
Gopi
  • 5,656
  • 22
  • 80
  • 146
25
votes
2 answers

How to implement the greater than or equal SQL statement in iBatis?

Let's say in my sql statement I want to do: WHERE numberOfCookies >= 10 How do I do this in iBatis?
Stephane Grenier
  • 15,527
  • 38
  • 117
  • 192
23
votes
3 answers

How can I pass multiple parameters and use them?

Hi I'm new to myBatis. I'm using MyBatis and Spring with mybatis-spring. How can I pass two different types of objects as parameters, and how can I use their properties in query? UPDATE SOME…
Jin Kwon
  • 20,295
  • 14
  • 115
  • 184
22
votes
3 answers

MyBatis/iBatis - reusable sql fragments in a separate SQL Map file?

I would like to put sql fragments used by several of my SQL Map XML files in a separate file. At the moment, the elements with these fragments are in one of the mappers together with other elements like SELECT username, …
qaxi
  • 472
  • 1
  • 4
  • 13
1
2 3
…
71 72