Where can I see the generated SQL query?

[Ian Hunter <ih...@hunterweb.net>]

I'm attached to a database I don't have rights to profile -- how can I see
the SQL query that gets called when I execute a search?  I'm using the PB
API getCollectionByQuery call.

---
Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht
oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist
and lsat ltteer be at the rghit pclae. The rset can be a total mses and you
can sitll raed it wouthit porbelm. Tihs is bcuseae the huamn mnid deos not
raed ervey lteter by istlef, but the wrod as a wlohe.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: Where can I see the generated SQL query?

[Jakob Braeuchi <jb...@gmx.ch>]

hi ian,

you can use the p6spy-driver to log the sql.

hth
jakob

Ian Hunter schrieb:
> I'm attached to a database I don't have rights to profile -- how can I see
> the SQL query that gets called when I execute a search?  I'm using the PB
> API getCollectionByQuery call.
> 
> ---
> Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht
> oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist
> and lsat ltteer be at the rghit pclae. The rset can be a total mses and you
> can sitll raed it wouthit porbelm. Tihs is bcuseae the huamn mnid deos not
> raed ervey lteter by istlef, but the wrod as a wlohe.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org