Re: The error occurred while applying a parameter map.

2008-08-20 Thread Seth Helstrip
You're not the Jeff Butler who I worked with at Oracle in 2000 are you? --- Jeff Butler <[EMAIL PROTECTED]> wrote: > deptNum and year must be properties of a single > parameter object (or a > Map). The method you are calling passes NO > parameter objects to iBATIS - > arg1 and arg2 in this case

Re: Configurable static parameters in SQL

2007-03-30 Thread Seth Helstrip
Hey Ilya, You can insert dynamic portions into your sql with iBatis using the $ syntax. To take your example, below you'd use something like... SELECT count(*) FROM $dbOwner$.students WHERE id = #value# And then supply the String parameter as an object to the query from your

RE: Transaction Control across multiple datasources

2007-03-29 Thread Seth Helstrip
with DB2 I was unable to use 2PC with DB2's type 4 JDBC driver. You should read through the documentation pertaining to the Driver to ensure that it supports 2PC. I know for a fact that DB2's type 2 driver does. ----- From: Seth Helstrip <[EMAIL PRO

Transaction Control across multiple datasources

2007-03-29 Thread Seth Helstrip
I'm relatively new to iBatis and am hoping someone can offer me some form of transaction management advise? I'm using Spring MVC with iBatis, and so far, have been mightily impressed with both technologies. Within my application I have the need to maintain transactions across two datasources and