Re: declarative - db schema

2006-03-12 Thread John Hurst
I've seen this discussed a couple of times here.   We have a scenario, or usage pattern, with Oracle that would benefit from iBATIS somehow being able to specify a schema name as a parameter/property.   If we have an application XXX, we commonly use several schemas/users:     XXXOWNER creates and o

Re: Urgent help required

2006-03-12 Thread netsql
Most likely for "muti-insert" you want to use prepared statement (inside a transaction), and I do so in Groovy (instead of iBatis, I use ibatis for OLTP, Groovy for batch. Q: I wonder if people know why prepared statement exists even. A: It's 1,000 times faster). .V Sven Boden wrote: So inse

Re: Urgent help required

2006-03-12 Thread Larry Meadors
Am I missing something here...do people frequently insert multiple rows? Because I would guess that 99.999% of the time I insert one and only one row. Getting a 0 or 1 back is no more useful than an exception being thrown (or not being thrown). This is not going to be changed because of that and

Re: Re: Urgent help required

2006-03-12 Thread Sven Boden
In the meantime the open office document is changed to be in sync with the actual iBATIS implementation. So insert does not return the number of inserted rows. From the javadocs: Executes a mapped SQL INSERT statement. Insert is a bit different from other update methods, as it provides facil

Re: Urgent help required

2006-03-12 Thread Cornel Antohi
Hi,   We experienced the same "strange" problem and we decided, until IBatis team will implement the insert as in documentation, to use "update" option from xml files with an INSERT sql query.   Thank you, Cornel - Original Message - From: Krishnamoorthi, Sruthi (Raytheon)