ibatis « Operation « Java Database Q&A





1. Fastest way for doing INSERTS using IBATIS    stackoverflow.com

I need to insert 20,000 rows in a single table (SQL Server 2005) using iBatis. What's the fastest way to do it ? I'm already using batch mode, but it didn't ...

2. Is there a simple way to do Query By Example in iBATIS?    stackoverflow.com

I had hoped this was baked into the most recent release, but if it is, I can't find the docs via a simple Google search. Failing that, I'd prefer ...

3. How to create query at runtime with iBATIS    stackoverflow.com

How can I create a query at runtime using ibatis (Java)? I want the table name to be dynamic. For example I have this xml file:

<resultMap id="result" class="Contact">
    <result property="id" ...

4. Handling many-to-many inserts with Ibatis    stackoverflow.com

I'm new to Ibatis and have a question regarding the mapping of many-to-many relationships. In my application's data model I have a many-to-many relationship between two of the entities, with the tables ...

5. Is there a Query-Mapper like iBATIS.NET but with dirty tracking, lazy-loading and cascading updates?    stackoverflow.com

The problem:

  1. A DBA-controlled database with a Stored Procedure-only mandate.
  2. An expectation that the domain be defined in POCO's.
So I decided that I need an ORM designed for stored procedures and/or legacy databases. Ideally ...

6. IBatis dynamic query help    stackoverflow.com

I have a table called "users" with following columns userid,name,gender,department,managerid.... I wanted to do this query but was having 2 issues
1. <> in line 4 is is causing problem, which is due to ...

7. When does the cachemodel in ibatis re-query the database to get updated records?    stackoverflow.com

I'm using ibatis and its cache model for the first time and i cant seem to figure out at what time will the cache be filled with new results, meaning whne ...

8. When does the cachemodel in ibatis re-query the database to get updated records?    stackoverflow.com

0 down vote favorite hi; I'm using ibatis and its cache model for the first time and i cant seem to figure out at what time will the cache be filled ...

9. ibatis: improve insert performace    stackoverflow.com

I am using ibatis for my sql insert stmt. In my code i am parsing files line by line from a folder. Each line that matches criteria, need to be inserted ...





10. Slow running query    stackoverflow.com

We have a query that's taking 3 hours to finish. This wasn't a problem before. Before, the code that calls this query is deployed on weblogic and uses the latter's own ...

11. iBatis.NET: Querying for object with list of objects    stackoverflow.com

I have a plain .net object that has fields/properties that I am populating using iBatis.NET. A few of the fields within this object are either other plain .net objects or lists ...

12. iBatis Discriminator on Insert    stackoverflow.com

I have an abstract class Example and concrete subclasses to go along with it. I used a discriminator to pull data out of the database, like so:

<resultMap id="ExampleResultMap" class="Example">
   ...

13. iBatis Batch Insert fails with socket write errors    stackoverflow.com

I am faced with a rather frustrating issue for the past couple of days. I am trying to improve performance by batching inserts using iBatis. However I see that the batch ...

14. Is iBatis the right for dynamic queries?    stackoverflow.com

I'm facing following issue: There will be several prepared SQL statements where the WHERE-clause contains defined contraints in which the values will be dynamic based on user input. In addition there will ...

15. Update with iBatis    stackoverflow.com

I need to update the following table: TOPICS = where WORD_ID is a foreign key and both of them are the key of TOPICS. I would like to query with iBatis:

UPDATE TOPICS ...

16. create dynamic query Ibatis    stackoverflow.com

Is there any way to pass dynamic column names ? we can pass values ussing ##

value#

Where #columnName# = #value# not work for me





17. ibatis 1.6.2 for .Net query timeout    stackoverflow.com

Is there a way to set the query timeout for ibatis 1.6 on the .net platform? Unfortunately, upgrading is not an option for me in this case. Cheers Shane

18. Detecting when inserting duplicate rows in Java/MyBATIS    stackoverflow.com

I am currently using MyBATIS in my project. I sometimes need to run an INSERT query but ignore if the row I'm trying to insert is already present on DB, but instead ...

19. Partially filled entity objects and keeping data coherent during updates    stackoverflow.com

I have a query that only fetches part of a table's values into an entity-style object. These values are being manipulated in a graphical interface. The issue is that an update could ...

20. ibatis like api to generate dynamic sql query    forums.oracle.com

I use hibernate for persistance.Most of my queries are hibernate criteria queries , but some of them are sql queries, I have to generate dynamic queries which are very long , I have been using java to generate queries using lot of if else blocks , this makes debugging query very hard. I am looking something like ibatis where I can ...