Funny you took longer to troll the list than to test that out.
-----Original Message-----
From: Henry Lu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 24, 2005 10:17 AM
To: [email protected]
Subject: Re: lock
It worked. Thanks for your help. Based upon your experience, do you know
if this works for "create table" and "Create view"?
-Henry
Ron Grabowski wrote:
>The code I posted was just an example. I'm more familiar with the .Net
>version of iBATIS. I've attached a more complete example below.
>
>I have not tested the code so if you copy and paste it into your
>application it will most likley not work. Make sure you replace
>"sqlMapconfig.xml" with the proper path to your config file:
>
>// untested - for example purposes only Reader reader = new
>Resources.getResourceAsReader("sqlMapconfig.xml");
>SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMap(reader);
>sqlMap.update("lockTable", null);
>
>Another way to go about solving this issue is to create a generic
>statement that executes sql statements:
>
> <statement id="executeRawSql">
> $sql$
> </statement>
>
>That could be called like this:
>
> // untested - for example purposes only sqlMap.update("executeRawSql",
> "lock table x in shared mode");
>
>The sqlMap object in my last example is of type SqlMapClient and can be
>found in the com.ibatis.sqlmap.client package.
>
>- Ron
>
>--- Henry Lu <[EMAIL PROTECTED]> wrote:
>
>
>
>>What is the class of
>>
>>sqlMapper
>>
>>?
>>
>>-Henry
>>
>>
>>
>>Ron Grabowski wrote:
>>
>>
>>
>>>Have you tried Larry's suggestion?
>>>
>>>sqlMapper.executeUpdate("lockTable");
>>>
>>><statement id="lockTable">
>>> lock table x in shared mode
>>></statement>
>>>
>>>--- Henry Lu <[EMAIL PROTECTED]> wrote:
>>>
>>>
>>>
>>>
>>>
>>>>Mr. Ruth, thank you very much for your info for me to understanding
>>>>this group. I thought there is a group of expertise watching the
>>>>emails and helping people to use the iBATIS. So there are no iBATIS
>>>>board members in the group. Everyone is trying and error to figure
>>>>out how to use
>>>>
>>>>
>>>>iBATIS. If it works, fine, if it doesn't, trying another way. You
>>>>never know what the best/right way to do it. One suggestion I'd like
>>>>to make to the board of iBATIS if I could is to write a better
>>>>
>>>>
>>documentation
>>
>>
>>>>so
>>>>it will save users times.
>>>>
>>>>Thanks you again for you help.
>>>>
>>>>-Henry
>>>>
>>>>
>>>>
>>>>Brice Ruth wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Hi Henry,
>>>>>
>>>>>Please stay civil on this list. Throwing veiled insults at regular
>>>>>contributors on this list is not cool.
>>>>>
>>>>>This is not paid technical support that you're talking to. If
>>>>>
>>>>>
>>that's
>>
>>
>>>>>how you treat them, that's fine. We're all volunteers & users of
>>>>>iBATIS, as such, we subscribe to the notion of trying things out,
>>>>>seeing if they work. Sometimes, we're pleasantly surprised.
>>>>>
>>>>>In your particular case, since you haven't posted any errors from
>>>>>iBATIS, it appears that you haven't tried anything out. As such,
>>>>>
>>>>>
>>the
>>
>>
>>>>>best we can do is suggest that you do try. If you have particular
>>>>>problems, as a group, we can try to help straighten them out, or
>>>>>suggest addl. features for future releases.
>>>>>
>>>>>Nobody is going to try things out for you, though - that's your
>>>>>responsibility, as it should be.
>>>>>
>>>>>Best,
>>>>>Brice
>>>>>
>>>>>
>>>>>On 6/23/05, Henry Lu <[EMAIL PROTECTED]> wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Please don't answer the question that you don't know because it
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>will
>>>>
>>>>
>>>>
>>>>
>>>>>>wast both side time.
>>>>>>
>>>>>>-Henry
>>>>>>
>>>>>>Larry Meadors wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>DDL is not supported, but may work as an update.
>>>>>>>
>>>>>>>Larry
>>>>>>>
>>>>>>>
>>>>>>>On 6/23/05, Henry Lu <[EMAIL PROTECTED]> wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>treat as ddl.
>>>>>>>>
>>>>>>>>-Henry
>>>>>>>>
>>>>>>>>Larry Meadors wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>How would you do it with JDBC?
>>>>>>>>>
>>>>>>>>>On 6/23/05, Henry Lu <[EMAIL PROTECTED]> wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>How do i set sqlmap for the following SQL statement:
>>>>>>>>>>
>>>>>>>>>>lock table x in shared mode
>>>>>>>>>>
>>>>>>>>>>?
>>>>>>>>>>
>>>>>>>>>>-Henry
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>
>>>
>>>
>
>
>
>
>
