Re: Beginner question on transactions...

2008-11-21 Thread Comcast Mail
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

RE: Beginner question on transactions...

2008-11-21 Thread Poitras Christian
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..

Beginner question on transactions...

2008-11-21 Thread Comcast Mail
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

Stored Procedures resultMap

2008-11-21 Thread Tokajac
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

Re: Result Class

2008-11-21 Thread Kai Grabfelder
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

Re: WHERE clause with full parameter condition send

2008-11-21 Thread Betto McRose Gamarra
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, >>

Re: WHERE clause with full parameter condition send

2008-11-21 Thread Larry Meadors
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: > >

WHERE clause with full parameter condition send

2008-11-21 Thread Betto McRose Gamarra
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