Hi Noel,
Unfortunately queries are written by clients and I cannot control them. My
intention is intercept the users' queries at the server (this is fully
controlled by me) and intercept the queries, build the execution plan for
each one and abort some of them under some circumstances which I guess I
can manage properly if I was able to get the plan.
Thanks,
Pablo.
2015-06-11 17:08 GMT+02:00 Noel Grandin <noelgran...@gmail.com>:
> Just call executeQuery with EXPLAIN PLAN SELECT.......
> On Thu, 11 Jun 2015 at 16:09, Pablo Beltran <pbeltr...@gmail.com> wrote:
>
>> Hi,
>>
>> i would like to get the same text jist like the H2 Web Console when a
>> plan is explained (Pls, see the attached picture), but I did not get it yet
>> unfortunately.
>>
>>
>>
>> Connection conn = ....
>>
>>
>> Statment st = con.createStatment("SELECT * FROM TABLE"),
>> st.executeQuery();
>>
>> ....
>>
>>
>> JdbcConnection jdbcConnection = (JdbcConnection) conn;
>> Session session = (Session) jdbcConnection.getSession();
>> Command current = session.getCurrentCommand(); //this method has been
>> added to the Session class.
>> Parser parser = new Parser(session);
>> Prepared prepared = parser.prepare(current.toString()); //SELECT * FROM
>> TABLE
>> Explain exp = new Explain(session);
>> exp.setCommand(prepared);
>>
>> and next??
>>
>> I've tried several things from here but without too much success.
>>
>> Any idea?
>>
>> Thanks in advance!
>> Pablo.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to h2-database+unsubscr...@googlegroups.com.
>> To post to this group, send email to h2-database@googlegroups.com.
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "H2 Database" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/h2-database/QQpyLqXHHtU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
