You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Henry Lu <zh...@umich.edu> on 2005/06/23 19:33:03 UTC
lock
How do i set sqlmap for the following SQL statement:
lock table x in shared mode
?
-Henry
Re: lock
Posted by Larry Meadors <la...@gmail.com>.
OK, fair enough:
I KNOW it is not supported.
I KNOW I have done it in the past, but depending on your database
(which I DO NOT KNOW) it may or may not work.
If it doesn't that is a bummer, because I KNOW it is not supported.
Larry
On 6/23/05, Henry Lu <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >
> >
> >>treat as ddl.
> >>
> >>-Henry
> >>
> >>Larry Meadors wrote:
> >>
> >>
> >>
> >>>How would you do it with JDBC?
> >>>
> >>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>How do i set sqlmap for the following SQL statement:
> >>>>
> >>>>lock table x in shared mode
> >>>>
> >>>>?
> >>>>
> >>>>-Henry
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >
> >
>
Re: lock
Posted by Brice Ruth <bd...@gmail.com>.
Hi Henry,
Experts in iBATIS do read and answer questions on this board. The original
creator of iBATIS frequents the list daily, in my experience.
However, that doesn't change the fact that this is an open source project.
You are expected to try things out and report back with errors.
You are also expected to read the exhaustive documentation that is created
for the project. As is the case in most instances, if your situation is not
covered in the documentation, it is fair to assume that it is not supported.
I assume you've ready all the 2.0 documentation, and have exhaustively
inspected the Wiki that the staff and contributors for this project
maintain?
This is by far one of the most well documented open source projects I have
come across. Take a look at the Castor documentation for a fresh look.
You'll come back thoroughly impressed, I assure you. (No offense to the
Castor guys)
Brice
On 6/23/05, Henry Lu <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>treat as ddl.
> >>>>
> >>>>-Henry
> >>>>
> >>>>Larry Meadors wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>How would you do it with JDBC?
> >>>>>
> >>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>How do i set sqlmap for the following SQL statement:
> >>>>>>
> >>>>>>lock table x in shared mode
> >>>>>>
> >>>>>>?
> >>>>>>
> >>>>>>-Henry
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >
> >
>
--
Brice Ruth
Software Engineer, Madison WI
Re: lock
Posted by Larry Meadors <la...@gmail.com>.
OK, this will be my last comment on this thread. Trolls irritate me.
On 6/23/05, Henry Lu <zh...@umich.edu> 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
Actually, every commiter on the project is on this list.
Unfortunately, we all have regular day jobs, and are unable to drop
everything to provide you with free support when you feel that you do
not have the time to try things yourself.
Those same pesky jobs also prevent us from trying every conceivable
use of the tool with every conceivable driver in every conceivable
environment.
> 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.
You are more than welcome to contribute to the documentation in *your*
spare time.
:-D
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Home
Larry
Re: lock
Posted by Henry Lu <zh...@umich.edu>.
Mr. Skavish,,
1. I didn't ask you to reply. You don't need answer if you don't wnat to.
2. I asked Mr. Grabowski's experience
3. I didn't ask anyone to try for me
4. Is this group for sharing experience too?
-Henry
Dmitry Skavish wrote:
>excuse me, but it takes no more than 30 seconds to test it yourself.
>
>On 6/24/05, Henry Lu <zh...@umich.edu> wrote:
>
>
>>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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>treat as ddl.
>>>>>>>>>>
>>>>>>>>>>-Henry
>>>>>>>>>>
>>>>>>>>>>Larry Meadors wrote:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>>How would you do it with JDBC?
>>>>>>>>>>>
>>>>>>>>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>>How do i set sqlmap for the following SQL statement:
>>>>>>>>>>>>
>>>>>>>>>>>>lock table x in shared mode
>>>>>>>>>>>>
>>>>>>>>>>>>?
>>>>>>>>>>>>
>>>>>>>>>>>>-Henry
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>
>>>
>>>
>
>
>
>
Re: lock
Posted by Dmitry Skavish <sk...@gmail.com>.
excuse me, but it takes no more than 30 seconds to test it yourself.
On 6/24/05, Henry Lu <zh...@umich.edu> wrote:
> 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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>>treat as ddl.
> >>>>>>>>
> >>>>>>>>-Henry
> >>>>>>>>
> >>>>>>>>Larry Meadors wrote:
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>>How would you do it with JDBC?
> >>>>>>>>>
> >>>>>>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>>How do i set sqlmap for the following SQL statement:
> >>>>>>>>>>
> >>>>>>>>>>lock table x in shared mode
> >>>>>>>>>>
> >>>>>>>>>>?
> >>>>>>>>>>
> >>>>>>>>>>-Henry
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >
> >
> >
>
--
Dmitry Skavish
Re: lock
Posted by Ron Grabowski <ro...@yahoo.com>.
I've never tried creating tables and views using that syntax but it
should work.
--- Henry Lu <zh...@umich.edu> wrote:
> 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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 doesnt, trying another way. You
> >>>>never
> >>>>know what the best/right way to do it. One suggestion Id 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>>treat as ddl.
> >>>>>>>>
> >>>>>>>>-Henry
> >>>>>>>>
> >>>>>>>>Larry Meadors wrote:
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
>
=== message truncated ===
Re: lock
Posted by Henry Lu <zh...@umich.edu>.
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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>treat as ddl.
>>>>>>>>
>>>>>>>>-Henry
>>>>>>>>
>>>>>>>>Larry Meadors wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>How would you do it with JDBC?
>>>>>>>>>
>>>>>>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>How do i set sqlmap for the following SQL statement:
>>>>>>>>>>
>>>>>>>>>>lock table x in shared mode
>>>>>>>>>>
>>>>>>>>>>?
>>>>>>>>>>
>>>>>>>>>>-Henry
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>
>>>
>>>
>
>
>
>
>
Re: lock
Posted by Ron Grabowski <ro...@yahoo.com>.
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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 doesnt, trying another way. You
> >>never
> >>know what the best/right way to do it. One suggestion Id 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>treat as ddl.
> >>>>>>
> >>>>>>-Henry
> >>>>>>
> >>>>>>Larry Meadors wrote:
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>How would you do it with JDBC?
> >>>>>>>
> >>>>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>>How do i set sqlmap for the following SQL statement:
> >>>>>>>>
> >>>>>>>>lock table x in shared mode
> >>>>>>>>
> >>>>>>>>?
> >>>>>>>>
> >>>>>>>>-Henry
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >
> >
> >
>
Re: lock
Posted by Henry Lu <zh...@umich.edu>.
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 <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>treat as ddl.
>>>>>>
>>>>>>-Henry
>>>>>>
>>>>>>Larry Meadors wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>How would you do it with JDBC?
>>>>>>>
>>>>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>How do i set sqlmap for the following SQL statement:
>>>>>>>>
>>>>>>>>lock table x in shared mode
>>>>>>>>
>>>>>>>>?
>>>>>>>>
>>>>>>>>-Henry
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>
>>>
>
>
>
>
>
Re: lock
Posted by Ron Grabowski <ro...@yahoo.com>.
Have you tried Larry's suggestion?
sqlMapper.executeUpdate("lockTable");
<statement id="lockTable">
lock table x in shared mode
</statement>
--- Henry Lu <zh...@umich.edu> 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 doesnt, trying another way. You
> never
> know what the best/right way to do it. One suggestion Id 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>treat as ddl.
> >>>>
> >>>>-Henry
> >>>>
> >>>>Larry Meadors wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>How would you do it with JDBC?
> >>>>>
> >>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>How do i set sqlmap for the following SQL statement:
> >>>>>>
> >>>>>>lock table x in shared mode
> >>>>>>
> >>>>>>?
> >>>>>>
> >>>>>>-Henry
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >
> >
>
Re: lock
Posted by Clinton Begin <cl...@gmail.com>.
>> 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 for offering Henry!
We look forward to your first contributions to the documentation of the
project. Here's a list of some of the items that need better documentation.
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Not+Yet+Documented
The community appreciates your efforts.
Thanks much,
Clinton Begin
On 6/23/05, Henry Lu <zh...@umich.edu> 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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>treat as ddl.
> >>>>
> >>>>-Henry
> >>>>
> >>>>Larry Meadors wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>How would you do it with JDBC?
> >>>>>
> >>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>How do i set sqlmap for the following SQL statement:
> >>>>>>
> >>>>>>lock table x in shared mode
> >>>>>>
> >>>>>>?
> >>>>>>
> >>>>>>-Henry
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >
> >
>
Re: lock
Posted by Henry Lu <zh...@umich.edu>.
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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
>>>
>>>
>>>
>>>
>>>>treat as ddl.
>>>>
>>>>-Henry
>>>>
>>>>Larry Meadors wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>How would you do it with JDBC?
>>>>>
>>>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>How do i set sqlmap for the following SQL statement:
>>>>>>
>>>>>>lock table x in shared mode
>>>>>>
>>>>>>?
>>>>>>
>>>>>>-Henry
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>
>>>
>
>
>
>
Re: lock
Posted by Brice Ruth <bd...@gmail.com>.
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 <zh...@umich.edu> 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 <zh...@umich.edu> wrote:
> >
> >
> >>treat as ddl.
> >>
> >>-Henry
> >>
> >>Larry Meadors wrote:
> >>
> >>
> >>
> >>>How would you do it with JDBC?
> >>>
> >>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>How do i set sqlmap for the following SQL statement:
> >>>>
> >>>>lock table x in shared mode
> >>>>
> >>>>?
> >>>>
> >>>>-Henry
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >
> >
>
--
Brice Ruth
Software Engineer, Madison WI
Re: lock
Posted by Henry Lu <zh...@umich.edu>.
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 <zh...@umich.edu> wrote:
>
>
>>treat as ddl.
>>
>>-Henry
>>
>>Larry Meadors wrote:
>>
>>
>>
>>>How would you do it with JDBC?
>>>
>>>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
>>>
>>>
>>>
>>>
>>>>How do i set sqlmap for the following SQL statement:
>>>>
>>>>lock table x in shared mode
>>>>
>>>>?
>>>>
>>>>-Henry
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>
>
>
>
Re: lock
Posted by Larry Meadors <la...@gmail.com>.
DDL is not supported, but may work as an update.
Larry
On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> treat as ddl.
>
> -Henry
>
> Larry Meadors wrote:
>
> >How would you do it with JDBC?
> >
> >On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> >
> >
> >>How do i set sqlmap for the following SQL statement:
> >>
> >>lock table x in shared mode
> >>
> >>?
> >>
> >>-Henry
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>
Re: lock
Posted by Henry Lu <zh...@umich.edu>.
treat as ddl.
-Henry
Larry Meadors wrote:
>How would you do it with JDBC?
>
>On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
>
>
>>How do i set sqlmap for the following SQL statement:
>>
>>lock table x in shared mode
>>
>>?
>>
>>-Henry
>>
>>
>>
>>
>
>
>
>
Re: lock
Posted by Larry Meadors <la...@gmail.com>.
How would you do it with JDBC?
On 6/23/05, Henry Lu <zh...@umich.edu> wrote:
> How do i set sqlmap for the following SQL statement:
>
> lock table x in shared mode
>
> ?
>
> -Henry
>
>