fetching query text

roman · **Posted:** Fri Dec 02, 2005 2:36 pm

hello

another question. is there a way to fetch a text
of command that result in exception ?
normally i get adoexception ora hibernateexception.
im in this kind of situation that i should have text of the query
when something fails :/

regards
lukasz

k-dub · **Joined:** Thu May 12, 2005 8:45 am **Posts:** 226

Have you enabled the log4net logging support? http://wiki.nhibernate.org/display/NH/Configuring+log4net+Logging

roman · **Posted:** Sat Dec 03, 2005 6:21 am

i configured App.config according to example, but when i fire
log4net.Config.XmlConfigurator.Configure(); i get
log4net:ERROR XmlConfigurator: Failed to find configuration section 'log4net' in the application's .config file. Check your .config file for the <log4net> and <configSections> elements. The configuration section should look like: <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
at the output console.

my second question is: will log help me to obtain sql query text?
should it be used with show_sql set to true ?

can you explain it to me ? : )
regards
roman

k-dub · **Joined:** Thu May 12, 2005 8:45 am **Posts:** 226

Yes, the SQL should be in the log. I believe this will show the SQL without cluttering up the log file:

Code:

<logger name="NHibernate">
   <level value="ERROR" />
</logger>
<logger name="NHibernate.Loader.Loader">
   <level value="INFO" />
</logger>

roman · **Posted:** Sun Dec 04, 2005 1:59 pm

but the problem is that i need this query inside my program.
during execution i should be able to fetch sql text in case
of exception, and pass it somewhere.

roman · **Posted:** Sun Dec 04, 2005 4:02 pm

i could possibly write my own appender and use it for NHibernate.SQL
logs. then i will get queries but without parameter values.
is there any more simple way to get query text ?
regards
lukasz

KPixel · **Posted:** Mon Dec 05, 2005 10:35 am

You may give a look at how NHibernate Query Analyzer works...