Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 38713 invoked from network); 25 Jun 2005 07:47:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Jun 2005 07:47:59 -0000 Received: (qmail 36791 invoked by uid 500); 25 Jun 2005 07:47:58 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 36775 invoked by uid 500); 25 Jun 2005 07:47:57 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 36755 invoked by uid 99); 25 Jun 2005 07:47:57 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 25 Jun 2005 00:47:57 -0700 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=HTML_50_60,HTML_MESSAGE,RCVD_BY_IP X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com designates 64.233.184.196 as permitted sender) Received: from [64.233.184.196] (HELO wproxy.gmail.com) (64.233.184.196) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 25 Jun 2005 00:47:57 -0700 Received: by wproxy.gmail.com with SMTP id i22so54971wra for ; Sat, 25 Jun 2005 00:46:10 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=GRqA7ONfqU96lmw/o71RWyuTmGMck25yVeih3+VUYKF05sLtwaTZ9NoiHl0JReUdoEetV+kqExkGuBxbP0Pyoqe5RIb4JmKlleszw63uiBOg4+BMxnM1GQC+7xdFyX/8MhBNgUuP98gGDiEHTi2UaT10E1ag6stJc8d7lwUL/jk= Received: by 10.54.76.12 with SMTP id y12mr2298414wra; Sat, 25 Jun 2005 00:46:10 -0700 (PDT) Received: by 10.54.93.11 with HTTP; Sat, 25 Jun 2005 00:46:10 -0700 (PDT) Message-ID: <16178eb10506250046750b5b32@mail.gmail.com> Date: Sat, 25 Jun 2005 01:46:10 -0600 From: Clinton Begin Reply-To: cbegin@ibatis.com To: user-java@ibatis.apache.org Subject: Re: lock In-Reply-To: <42BC1AC9.7010006@umich.edu> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15764_2363505.1119685570119" References: <093D7E25FD9C2441A13103EFB8CBED3A078B2DBC@nmr001oldmsx04.enterprisenet.org> <42BC1AC9.7010006@umich.edu> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_15764_2363505.1119685570119 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline There is a big difference between what is "supported" and what "works". We don't support DDL because that's not what iBATIS is intended for.=20 However, many users successfully run DDL through iBATIS every day. Overclocking a CPU/GPU isn't supported either, but lots of people do it! Cheers, Clinton On 6/24/05, Henry Lu wrote: >=20 > I don't know if it is funny to talk about this issue. Is it funny to say > that ddl is not supported in the iBATIS but it works in real? Is ddl is > not supported in iBatis, why wast time to try it? If it works, why it is > saied that ddl is not supported? >=20 > -Henry >=20 > Chen, Tim wrote: >=20 > >Funny you took longer to troll the list than to test that out. > > > >-----Original Message----- > >From: Henry Lu [mailto:zhlu@umich.edu] > >Sent: Friday, June 24, 2005 10:17 AM > >To: user-java@ibatis.apache.org > >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 =3D new > >>Resources.getResourceAsReader("sqlMapconfig.xml"); > >>SqlMapClient sqlMap =3D 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: > >> > >> > >> $sql$ > >> > >> > >>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 wrote: > >> > >> > >> > >> > >> > >>>What is the class of > >>> > >>>sqlMapper > >>> > >>>? > >>> > >>>-Henry > >>> > >>> > >>> > >>>Ron Grabowski wrote: > >>> > >>> > >>> > >>> > >>> > >>>>Have you tried Larry's suggestion? > >>>> > >>>>sqlMapper.executeUpdate("lockTable"); > >>>> > >>>> > >>>>lock table x in shared mode > >>>> > >>>> > >>>>--- Henry Lu 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 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 wrote: > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>>>treat as ddl. > >>>>>>>>> > >>>>>>>>>-Henry > >>>>>>>>> > >>>>>>>>>Larry Meadors wrote: > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>>>How would you do it with JDBC? > >>>>>>>>>> > >>>>>>>>>>On 6/23/05, Henry Lu wrote: > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>>>How do i set sqlmap for the following SQL statement: > >>>>>>>>>>> > >>>>>>>>>>>lock table x in shared mode > >>>>>>>>>>> > >>>>>>>>>>>? > >>>>>>>>>>> > >>>>>>>>>>>-Henry > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>> > >>>> > >>>> > >>>> > >>>> > >> > >> > >> > >> > >> > > > > > > > > > > > ------=_Part_15764_2363505.1119685570119 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
There is a big difference between what is "supported" and what &q= uot;works".

We don't support DDL because that's not what iBATIS is intended for.  However, many users successfully run DDL through iBATIS every day.

Overclocking a CPU/GPU isn't supported either, but lots of people do it!
Cheers,
Clinton


On 6/24/05, Henry Lu <zhlu@umich.edu> wrote:
I don't know if it is funny to talk about this issue. Is it funny to saythat ddl is not supported in the iBATIS but it works in real? Is ddl isnot supported in iBatis, why wast time to try it? If it works, why it is
saied that ddl is not supported?

-Henry

Chen, Tim wrote:<= br>
>Funny you took longer to troll the list than to test that out.>
>-----Original Message-----
>From: Henry Lu [mailto: zhlu@umich.edu]
>Sent: Friday, = June 24, 2005 10:17 AM
>To: user-java@ibatis.apache.org
>Subject: Re: lock
>
&= gt;It worked. Thanks for your help. Based upon your experience, do you know
>if this works for "create table" and "Create view&qu= ot;?
>
>-Henry
>
>Ron Grabowski wrote:
>
&= gt;
>
>>The code I posted was just an example. I'm more fami= liar 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 sur= e you replace
>>"sqlMapconfig.xml" with the proper path to your confi= g file:
>>
>>// untested - for example purposes only Read= er reader =3D new
>>Resources.getResourceAsReader("sqlMapconf= ig.xml ");
>>SqlMapClient sqlMap =3D SqlMapClientBuilder.buildSqlMap= (reader);
>>sqlMap.update("lockTable", null);
>>= ;
>>Another way to go about solving this issue is to create a gene= ric
>>statement that executes sql statements:
>>
>>= <statement id=3D"executeRawSql">
>> $sql$
>&= gt;</statement>
>>
>>That could be called like this= :
>>
>>// untested - for example purposes only sqlMap.upda= te("executeRawSql",
>>
>>
>
>
&g= t;
>>"lock table x in shared mode");
>>
>>The sqlMap object in my last example is of type SqlMapClient and ca= n be
>>
>>
>
>
>
>>found in th= e com.ibatis.sqlmap.client package.
>>
>>- Ron
>>= ;
>>--- Henry Lu <zhlu@umich.e= du> wrote:
>>
>>
>>
>>
>&g= t;
>>>What is the class of
>>>
>>>sqlMa= pper
>>>
>>>?
>>>
>>>-Henry
= >>>
>>>
>>>
>>>Ron Grabowski w= rote:
>>>
>>>
>>>
>>>
>>>
>>>>Have you tried Larry's suggestion?
>&= gt;>>
>>>>sqlMapper.executeUpdate("lockTable"= ;);
>>>>
>>>><statement id=3D"lockTab= le">
>>>>lock table x in shared mode
>>>></sta= tement>
>>>>
>>>>--- Henry Lu <zhlu@umich.edu> wrote:
>>>>= ;
>>>>
>>>>
>>>>
>>>= ;>
>>>>
>>>>
>>>>>Mr. Ru= th, thank you very much for your info for me to understanding
>>&g= t;>>this group. I thought there is a group of expertise watching the
>>>>>emails and helping people to use the iBATIS. So the= re are no iBATIS
>>>>>board members in the group. Everyon= e is trying and error to figure
>>>>>out how to use
>>>>>
>>>>>
>>>>>iBATIS.= If it works, fine, if it doesn't, trying another way. You
>>>&= gt;>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
>>>
&g= t;>>
>>>
>>>
>>>>>so
>= ;>>>>it will save users times.
>>>>>
>&= gt;>>>Thanks you again for you help.
>>>>>
>>>>>-Henry
>>>>&= gt;
>>>>>
>>>>>
>>>>>= Brice Ruth wrote:
>>>>>
>>>>>
>&g= t;>>>
>>>>>
>>>>>
>>>>>>>>>>
>>>>>>Hi Henry,
>>>&= gt;>>
>>>>>>Please stay civil on this list. Thro= wing veiled insults at regular
>>>>>>contributors on this list is not cool.
>&= gt;>>>>
>>>>>>This is not paid technical s= upport that you're talking to. If
>>>>>>
>>&g= t;>>>
>>>>>>
>>>>>>
>>>tha= t's
>>>
>>>
>>>
>>>
>= >>>>>how you treat them, that's fine. We're all volunteers &= amp; users of
>>>>>>iBATIS, as such, we subscribe to the notion of = trying things out,
>>>>>>seeing if they work. Sometime= s, we're pleasantly surprised.
>>>>>>
>>>&= gt;>>In your particular case, since you haven't posted any errors fro= m
>>>>>>iBATIS, it appears that you haven't tried anyth= ing out. As such,
>>>>>>
>>>>>>>>>>>>
>>>>>>
>>>the
>>>
>>>
>>>
>>>
>>= ;>>>>best we can do is suggest that you do try. If you have par= ticular
>>>>>>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
>>>>>>respons= ibility, as it should be.
>>>>>>
>>>>>>Best,
>>&g= t;>>>Brice
>>>>>>
>>>>>>=
>>>>>>On 6/23/05, Henry Lu < zhlu@umich.edu> wrote:
>>>>>>
>>>&g= t;>>
>>>>>>
>>>>>>
>&= gt;>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Please don't an= swer the question that you don't know because it
>>>>>>= ;>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>= ;>>>>
>>>>>will
>>>>>
&g= t;>>>>
>>>>>
>>>>>
>&= gt;>>>
>>>>>
>>>>>>>wast both side time= .
>>>>>>>
>>>>>>>-Henry
= >>>>>>>
>>>>>>>Larry Meadors w= rote:
>>>>>>>
>>>>>>>
>>= ;>>>>>
>>>>>>>
>>>>&g= t;>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>= ;>>>>>>DDL is not supported, but may work as an update.>>>>>>>>
>>>>>>>>Larry
>>>>>>>>
>>>>>>>>>>>>>>>>On 6/23/05, Henry Lu <zhlu@umich.edu> wrote:
>>>>>>&= gt;>
>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>
&g= t;>>>>>>>
>>>>>>>>
>&= gt;>>>>>>
>>>>>>>>
>>>>>>>>>>>>>>>>>treat as ddl.
>>>>>&= gt;>>>
>>>>>>>>>-Henry
>>&g= t;>>>>>>
>>>>>>>>>Larry Meadors wrote:
>>>= ;>>>>>>
>>>>>>>>>
>&g= t;>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>= ;
>>>>>>>>>
>>>>>>>&g= t;>
>>>>>>>>>
>>>>>>&= gt;>>
>>>>>>>>>
>>>>>>>>= ;>>How would you do it with JDBC?
>>>>>>>>= >>
>>>>>>>>>>On 6/23/05, Henry Lu &l= t; zhlu@umich.edu> wrote:
>>= >>>>>>>>
>>>>>>>>>>= ;
>>>>>>>>>>
>>>>>>&g= t;>>>
>>>>>>>>>>
>>>>>>>= ;>>>
>>>>>>>>>>
>>>&g= t;>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>= ;>>
>>>>>>>>>>
>>>>&g= t;>>>>>>How do i set sqlmap for the following SQL stateme= nt:
>>>>>>>>>>>
>>>>>>= ;>>>>>lock table x in shared mode
>>>>>>= ;>>>>>
>>>>>>>>>>>?
>>>>>>>>>>>
>>>>>>>= ;>>>>-Henry
>>>>>>>>>>>
= >>>>>>>>>>>
>>>>>>>= ;>>>>
>>>>>>>>>>>
>>>>>>= ;>>>>>
>>>>>>>>>>>
&g= t;>>>>>>>>>>
>>>>>>>&= gt;>>>
>>>>>>>>>>>
>>>>>>= ;>>>>>
>>>>>>>>>>>
&g= t;>>>>>>>>>>
>>>>>>>&= gt;>>>
>>>>>>>>>>>
>>>>>>= ;>>>>
>>>>>>>>>>
>>&g= t;>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>= ;>>>
>>>>>>>>>>
>>>&g= t;>>>>>>
>>>>>>>>
>>&= gt;>>>>>
>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>
&g= t;>>>>>>>
>>>>>>>>
>&= gt;>>>>
>>>>>>
>>>>>>
>>>>= ;>>
>>>>>>
>>>>>>
>&g= t;>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>>
>>= ;
>
>
>
>
>

------=_Part_15764_2363505.1119685570119--