using mySql LOCK TABLES

[javaDeveloper]

We're using myBatis with mySql. There is a case where we need to call
the mySql-specific LOCK TABLES syntax in a query. Since myBatis only
offers insert, select, update, and delete statement in the mapper.xml
file, as I see it, what option would I use?

Thanks

[Bogdan Tanase]

There's also <sql>...

On Apr 12, 2012 9:23 PM, "javaDeveloper" <[hidden email]> wrote:

We're using myBatis with mySql. There is a case where we need to call
the mySql-specific LOCK TABLES syntax in a query. Since myBatis only
offers insert, select, update, and delete statement in the mapper.xml
file, as I see it, what option would I use?

Thanks

[Jeff Butler]

I would use update.  It is the most generic way to execute SQL that
doesn't return a result set.

Jeff Butler

On Thu, Apr 12, 2012 at 2:26 PM, Bogdan Tanase <[hidden email]> wrote:

> There's also <sql>...
>
> On Apr 12, 2012 9:23 PM, "javaDeveloper" <[hidden email]> wrote:
>>
>> We're using myBatis with mySql. There is a case where we need to call
>> the mySql-specific LOCK TABLES syntax in a query. Since myBatis only
>> offers insert, select, update, and delete statement in the mapper.xml
>> file, as I see it, what option would I use?
>>
>> Thanks