Re: Becoming a FAQ: Executing multiple sql statements in a single network round trip

[Paul DuBois]

At 9:56 -0700 10/2/03, Matthew T. Adams wrote:
>Yes, they are mostly queries.  Yes, I know I can
>cache, as long as the data underneath doesn't change.
>These happen to be for reporting purposes, and the
>nature of the reports require (so far) the creation of
>a temporary table and a subsequent select from it.
>
>It's not that I don't appreciate the suggestions, but,
>please, can someone tell me if there is a way to batch
>statements using MySQL via Connector/J?

Mark Matthews has already answered your question.
He *wrote* Connector/J, so his answer is authoritative.
Why is it that you appear not to believe his answer?


>
>--- Christopher Taylor <cstaylor@stripped> wrote:
>>  Are you mostly making queries?  Why not cache that
>>  information instead of
>>  going to the database everytime?
>>
>  > -Chris


-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/