Re: [OT] Execute multiple statements in MySQL

[j-lists]

I guess this is a bit of a digression but since we are on the topic... IMHO finding multiple statements using semicolons would be less than ideal, allowing the nesting of insert/update/delete/select tags would be a more structured way to implement it and would remove the SQL parsing burden from iBatis (eliminates the need for an escape sequence as well). Nesting/chaining tags to execute a sequence of SQL, if the semamantics are carefully designed, could be a very powerful feature.

-J

On 9/12/05, Clinton Begin <[EMAIL PROTECTED]> wrote:

Such a feature wouldn't even have to be vendor specific. It could simply be a flag like EnableMultipleStatements="true", which would tell iBATIS to look for semicolons and execute mutiple statements.

I don't think the nature of iBATIS is such that it will never have "vendor specific" features so to speak.  No moreso than JDBC does anyway...

Cheers,
Clinton

On 9/11/05, Patrick Lightbody <[EMAIL PROTECTED] > wrote:

I too disagree. Maybe after iBatis has official support for recognizing the vendor (and is able to execute statements that are vendor-specific), we could also add support for multiple statements, even under MySQL. It'd be a hack, but it could just break up the statement and execute it serially.

 

_________________
Patrick Lightbody
Professional Services
Jive Software
[EMAIL PROTECTED]
www.jivesoftware.com
317 SW Alder, Ste 500
Portland, OR 97204
ph (503) 295-6552
fx (503) 961-1047

 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Clinton Begin
Sent: Sunday, September 11, 2005 11:35 AM
To: user-java@ibatis.apache.org
Subject: Re: [OT] Execute multiple statements in MySQL

I think MySQL considers it a security issue (SQL injection), so I don't believe there is a way.

FWIW, I disagree with them on that....

Clinton

On 9/11/05, Barnett, Brian W. <[EMAIL PROTECTED]> wrote:

Anybody here know how to configure a MySQL JDBC datasource to allow multiple
statements, separated by semi-colons, to execute?

TIA,
Brian Barnett

****************************************************************************
This email may contain confidential material.
If you were not an intended recipient,
Please notify the sender and delete all copies.
We may monitor email to and from our network.
****************************************************************************