how to access Oracle sql Mappings from code

2009-10-28 Thread Bhaarat Sharma
I wont bother you guys by yet another oracle sql mapping question... my question is simple. We are converting our iBatis mappings from sql server compliant to oracle compliant. We only use stored procedures...So since we are moving to Oracle..every result set returned from a procedure will now co

transaction markers

2009-10-28 Thread Ivan Bojer
We need to mark our transaction begin and commit separately. In other words we need to implement this: BEGIN SET_MARK UNSET_MARK COMMIT Is there a way to do this at the global level in IBatis? I understand that we could do this manually for each transaction but there must be a better way to a

Can a ibatis statement create a trigger?

2009-10-28 Thread Alex Sherwin
Using MySQL 5.1.x and iBatis 2.x, We're trying to find a way to create triggers along with the schemas and tables an iBatis function creates. Currently, a stored procedure is creating a new DB and adding tables (works fine), but MySQL stored procedures cannot create triggers, so we're seeing

Re: locking the queries mysql ibatis

2009-10-28 Thread deligeli
so you mean that once i switch to VPS it will be fine? my queries are declared like this: is there any parameter that i can add to it? Clint