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?
-Henry
Chen, Tim wrote:
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
