Questions tagged [ibatis.net]

iBATIS is a simple but complete framework that makes it easy to map objects to SQL statements or stored procedures.

iBATIS DataMapper couples objects with stored procedures or SQL statements using a XML descriptor. Simplicity is the biggest advantage of the iBATIS DataMapper over object relational mapping tools. To use iBATIS DataMapper you rely on your own objects, XML, and SQL.

54 questions
1
vote
1 answer

ibatis initmapper EXTREMELY slow

We have chosen ibatis as our o/rm at my company (many years ago) and are generally happy with performance compared to other options. However, we have identified one service where the initmapper stage consistently takes 4 - 6 seconds. The mapper is…
RockyMountainHigh
  • 2,871
  • 5
  • 34
  • 68
0
votes
1 answer

WCF App Needs to be "Kick-started" by Cohabiting Web App

I'm dealing with a rather bizarre problem here and looking to see if anyone could offer a tip. The Problem: When I try to consume the service from my local C# app, it fails when accessing the database. The DataMapper throws an exception saying it…
Patrick
  • 971
  • 9
  • 17
0
votes
1 answer

In iBatis with C#, how to check for if a lazy loaded property is null

I have an object (Cart) which have a one-to-one relation to a Case. This relation is allowed to be null and is lazyloaded. So sometimes a Cart has a case, sometimes it doesn't. And if it does have a case it not loaded until it is needed. If it…
Torben Junker Kjær
  • 4,042
  • 4
  • 34
  • 33
0
votes
2 answers

create dynamic query Ibatis

Is there any way to pass dynamic column names ? we can pass values ussing ## value# Where #columnName# = #value# not work for me
user978103
  • 21
  • 5
0
votes
2 answers

Cannot get logging output from iBATIS.NET

My application is using the iBATIS.NET Data Mapper version 1.6.3. A recent modification is causing a SqlException and I would like to see the query that it is trying to execute, so I added the following to the app.config:
Jeremy
  • 3,484
  • 3
  • 22
  • 25
0
votes
1 answer

Problem passing a huge string to an stored function via IBatis.Net

I have the following type and function: CREATE OR REPLACE TYPE SERIAL_NUMBER_TABLE AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION F_DEVICE_SERIAL_TABLE( SN_LIST IN CLOB, SN_DELIMITER IN VARCHAR2 DEFAULT ';') RETURN…
gender_madness
  • 1,080
  • 11
  • 13
0
votes
1 answer

How to determine if insertions have been completed in ibatis?

@Insert("insert into TABLE(c1, c2, c3) " + "values ( #{col1}, #{col2}, #{col3})") Boolean save(Integer x, Integer y); The returning Boolean would be True or False, determining if everything has been inserted properly
user
  • 854
  • 2
  • 12
  • 28
0
votes
1 answer

Unable to Create Temporary table in IBatis

I am unable to use temporary tables in my ibatis SQL Query (#table). This query is executed on SQL Server. DECLARE @file_id int SET @file_id = 38--#FileID# SELECT * INTO #NotFinishedRecords FROM TABLE
Ishan Adarsh
  • 151
  • 1
  • 7
0
votes
1 answer

iBatis.NET to insert record with Oracle stored procedure, return record ID

I am attempting to insert a record in an Oracle table with a Function, which would be called through iBatis.NET. Function works as expected in Oracle when called directly. I have tried using and SqlMap but I can't get iBatis.NET…
Leon
  • 3,311
  • 23
  • 20
0
votes
1 answer

Ibatis checking property in array form

I use Ibatis version 1.6 I know that ibatis can read value from array parameter. This is my code SELECT count(1) FROM TB_R_SW103_TAM r WHERE AND convert(DATE,r.TAM_APPROVED_DATE) between convert(DATE, #[0]#) AND convert(DATE,…
HadidM
  • 65
  • 6
0
votes
1 answer

iBatis schemas not working in Visual Studio 2010

iBatis comes with three schema files that provide intellisense to VS.Net. According to the iBatis help docs, the location should be this: C:\Program Files\Microsoft Visual Studio 10.0\Common7\Packages\schemas\xml or this if you have x64…
sohtimsso1970
  • 3,216
  • 4
  • 28
  • 38
0
votes
1 answer

ibatis - cannot set cacheModel

I want to set cacheModel on an insert and i do it like this:
ion
  • 1,141
  • 3
  • 9
  • 9
0
votes
4 answers

Return result from query even if WHERE clause not met

I am creating a query that ensures some constraints are met. Here's a semi-working version right now: SELECT CASE WHEN TaskId IS NULL THEN 0 ELSE 1 END AS TaskExists, CASE WHEN IsDownTask = 0…
Killnine
  • 5,728
  • 8
  • 39
  • 66
0
votes
2 answers

iBATIS.NET WebSessionStore throwing an exception

I have a web app that uses the iBATIS.NET library. The DAO is configured by using an XmlDocument, so the code is very similar to what they show in the documentation: XmlDocument anXmlDoc =…
Brandon
  • 68,708
  • 30
  • 194
  • 223
0
votes
1 answer

IBatis.net converting project from VS2003 to VS2008 crashes on load

The project has been working fine in 2003 but when opening it in 2008 we now get the below error. I've tried ripping all of the code out of the 'Accessory' result map and then it just goes onto the next result map and tells me the same error with…
Dilbert789
  • 864
  • 2
  • 14
  • 29