to set property show_sql can show hql but how to save it to log?
can use log config like log4j?

Look at the log4j properties file in the Hibernate distribution.

I use a jdbc append and this sql string for insert.
this appender can work with other class.

<param name="ConversionPattern" value="INSERT INTO LOG4J (log_level,log_time,location,message) VALUES ('%-5p','%d{yyyy-MM-dd hh:mm:ss.SSS}','%l','%m')"/>


now, I configed in the log4j.xml

<category name="net.sf.hibernate.SQL">
<level value="debug"/>
<appender-ref ref="jdbc"/>
<appender-ref ref="stdout"/>
</category>


it can print in stdout, but can't insert into database.

could you tell me what's happend?

and, the outputted sql string does not with param replaced

it has only " param= ? ".

how do I?