You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Ajitesh Das <ad...@zona.net> on 2004/09/15 22:20:17 UTC
OJB and debug options
Hi list:
How and what to turn on for ojb debug options, so that I can debug the
SQLs, generated from the OJB queries.
I am using : MSSQL and jtds driver.
Thanks
--
A good friend will come bail you out of jail...but, a true friend will
be sitting next to you saying, "Damn...that was fun."
Re: OJB and debug options
Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi,
the easiest is to use p6spy.
use the p6spy-driver in repository_database.xml :
...
driver="com.p6spy.engine.spy.P6SpyDriver"
protocol="jdbc"
subprotocol="mysql"
dbalias="//localhost:3306/ojb"
...
and define the realdriver spy.properties :
...
# mysql Connector/J driver
realdriver=com.mysql.jdbc.Driver
...
the appender (also in spy.properties) defines where the target for the output:
...
#specifies the appender to use for logging
#appender=com.p6spy.engine.logging.appender.Log4jLogger
appender=com.p6spy.engine.logging.appender.StdoutLogger
#appender=com.p6spy.engine.logging.appender.FileLogger
...
hth
jakob
Ajitesh Das schrieb:
> Hi list:
>
> How and what to turn on for ojb debug options, so that I can debug the
> SQLs, generated from the OJB queries.
>
> I am using : MSSQL and jtds driver.
>
> Thanks
>
>
>
> --
>
> A good friend will come bail you out of jail...but, a true friend will
> be sitting next to you saying, "Damn...that was fun."
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: OJB and debug options
Posted by Pulat Yunusov <pu...@3genius.com>.
Logging levels are set in the OJB.properties files. Find a line that
specifies the logging level for your implementation of SQL generator,
e.g.
org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=WARN,
and put the appropriate value in ("DEBUG").
Around that part of the file, you can find lines setting logging levels
for other OJB components.
Pulat
Ajitesh Das wrote:
> Hi list:
>
> How and what to turn on for ojb debug options, so that I can debug the
> SQLs, generated from the OJB queries.
>
> I am using : MSSQL and jtds driver.
>
> Thanks
>
>
>
> --
>
> A good friend will come bail you out of jail...but, a true friend will
> be sitting next to you saying, "Damn...that was fun."
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org