The tables were created with Engine=InnoDB
mysql 5.0.27
Thx
-- pady
- Original Message -
From: "Poitras Christian" <[EMAIL PROTECTED]>
To:
Sent: Friday, November 21, 2008 1:12 PM
Subject: RE: Beginner question on transactions...
Are your tables in InnoDB or MyISAM?
InnoDB tabl
Are your tables in InnoDB or MyISAM?
InnoDB tables are required in MySQL to support transactions.
Christian
-Original Message-
From: Comcast Mail [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2008 1:04 PM
To: user-java@ibatis.apache.org
Subject: Beginner question on transactions..
Hi.
I have code that does the following:
try {
DaoManager.startTransaction();
// loop and do some inserts
...
DaoManager.commitTransaction();
} catch ( Exception ex ) {
...
} finally {
DaoManager.endTransaction();
}
One of the insert fails but the previous inserts have been committed.
Alth
Hello!
I'm trying to invoke a stored procedure which should give me back List of
entities of class UserRightsResultMap
SP.xml file:
{call DATABASE.USRRGHT(?)}
Java DAO src:
Map parameterMap = new HashMap();
parameterMap.put("USR", "myuser");
List rights = new ArrayLi
I guess it depends on your database if . are allowed in column aliases - i
guess it is not the case with
oracle. Maybe you need to escape them? Alternatively you should switch to
resultMaps instead of resultClass.
Regards
Kai
--- Original Nachricht ---
Absender: Bruno Frascino
Datum: 20.11.200
thanks Larry, it works
On Fri, Nov 21, 2008 at 10:32, Larry Meadors <[EMAIL PROTECTED]> wrote:
> You'll have to use $condition$ instead. Be careful that you protect
> against SQL injection.
>
> Larry
>
>
> On Fri, Nov 21, 2008 at 6:12 AM, Betto McRose Gamarra
> <[EMAIL PROTECTED]> wrote:
>> hi,
>>
You'll have to use $condition$ instead. Be careful that you protect
against SQL injection.
Larry
On Fri, Nov 21, 2008 at 6:12 AM, Betto McRose Gamarra
<[EMAIL PROTECTED]> wrote:
> hi,
>
> well, I have a problem when I send the whole condition for the WHERE clause
>
> this is the xml config:
>
>
hi,
well, I have a problem when I send the whole condition for the WHERE clause
this is the xml config:
#condition#
every property has a value, I could check that
the problem is because I don't have co