On 10/12/08, Stewart Smith <[EMAIL PROTECTED]> wrote: > > On Sat, Oct 11, 2008 at 11:06:12AM -0400, Jim Starkey wrote: > > On the more mundane side of things, JDBC supports multiple SQL > > statements per string. Banning the feature from the server would > > require a JDBC driver to parse, slice, and dice statement strings. > > > Seems reasonable - JDBC = stupidly broken there. > --
Am I missing something? I thought many languages, including PHP, have allowances for multiple ; delimited SQL statements in their syntax (ie, http://us.php.net/mysqli_multi_query). Banning wouldn't require parsing, slicing or dicing, it would require that the connector does not try to do stuff it's not allowed to do.....again, I might be dense, but it seems to me that JDBC and others would only break when someone tries to use the "multiple SQL statements per string" feature. Which is what *should* happen, because Drizzle doesn't allow that feature.....would it actually break on single queries too? (why?) -Sheeri Stewart Smith > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
