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
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
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
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
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)