Hi Good Morning everybody

In my hibernate.cfg.xml file I wrote like

<property name="hibernate.show_sql">true</property>
<property name="format_sql">true</property>
<property name="hibernate.use_sql_comments">true</property>


in console I am able to get sql query,sql format & comments like


/* insert com.abc.xyz.MyClass
*/ insert
into
my_table
(np_pk, ct_pk, title_uni, action, layout, view_order, title_Font, icon_url, image_url, link, sub_key, created_on, last_modified_on, created_by, published_by, state, breakingnews_id, pk)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

but I would like to see the parameters ,plz help me how can display the parameters in console



Thanks a lot in advance
Shaik Vali.

You will have to configure log4j for tht. Add the following categories to log4j.xml

Hi littypreethkr many thanks for your reply , instead of log4j.xml I need

in log4j.properties . Could you please help me out.


Thanks a lot
Shaik Vali

Well, I am not a log4J expert. Still try adding the following to ur log4j.properties:

Plz lemme know if it works.

Hi , I was trying to write the logs in to sepate file like


log4j.appender.STDOUT=org.apache.log4j.RollingFileAppender
log4j.appender.STDOUT.Threshold = WARN
log4j.appender.STDOUT.File=C:\\Logs\\Licence.log
log4j.appender.STDOUT.MaxFileSize=10MB
log4j.appender.STDOUT.MaxBackupIndex=5
log4j.appender.STDOUT.layout=org.apache.log4j.PatternLayout
log4j.appender.STDOUT.layout.ConversionPattern=%d{ISO8601} %-5p [%F:%L] : %m%n

log4j.category.org.hibernate.SQL=TRACE, STDOUT
log4j.category.org.hibernate.type=TRACE, STDOUT

It's not writing to log file.
could you please helpme how can I write ..
please correct me.

Thanks a lot.

Put
log4j.appender.STDOUT.Threshold = TRACE

You have put it as WARN

Hi littypreethkr ,

it's working fine .... thanks a lot.

I would like to see the parameters ,plz help me how can display the parameters in console. I am using log4j.properties

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5p %c %x - %m%n
### direct log message to eligibility.log file ###
log4j.appender.eligibility=org.apache.log4j.RollingFileAppender
log4j.appender.eligibility.file=svcs/logs/server.log
log4j.appender.eligibility.MaxFileSize=100KB
log4j.appender.eligibility.MaxBackupIndex=5
log4j.appender.eligibility.layout=org.apache.log4j.PatternLayout
log4j.appender.eligibility.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5p %c %x - %m%n
### root logger option ###
log4j.rootLogger=error, stdout
### Hibernate logging options ###
log4j.logger.net.sf.hibernate=error
### log JDBC bind parameters ###
log4j.logger.net.sf.hibernate.type=error
### log PreparedStatement cache activity ###
log4j.logger.net.sf.hibernate.ps.PreparedStatementCache=error
## added by me to get the values instead of ('?'?'?') these parameters
log4j.appender.STDOUT.Threshold=TRACE
log4j.category.org.hibernate.SQL=TRACE, STDOUT
log4j.category.org.hibernate.type=TRACE, STDOUT

Thanks