How to set up logging in SQL using log4j in jboss 6.0.0?

There is a jboss 6.0.0 Final and a java site. Logging is enabled, currently output as files and duplication to the console. It is necessary to duplicate in SQL base. There are no log4j.xml files or property. The project is not mine, you need to understand. The maximum that I found .... / deploy / jboss-logging.xml. He added:

<log4j-appender name="DB" class="org.apache.log4j.jdbc.JDBCAppender"> <error-manager> <only-once /> </error-manager> <level name="DEBUG" /> <properties> <property name="URL">jdbc:sqlserver://localhost:1433;databaseName=myDB </property> <property name="driver">com.microsoft.sqlserver.jdbc.SQLServerDriver </property> <property name="user">User</property> <property name="password">UserPass</property> <property name="sql">exec [dbo].[usp_insert_log_table] 'MyTestJBOSS','clientIP','serverIP','%p','%m'</property> </properties> </log4j-appender> <root-logger> <!-- Set the root logger priority via a system property, with a default value. --> <level name="${jboss.server.log.threshold:DEBUG}" /> <handlers> <handler-ref name="CONSOLE" /> <handler-ref name="FILE" /> <handler-ref name="DB" /> </handlers> </root-logger>` 

If instead of properties, make param:

  <log4j-appender name="DB" class="org.apache.log4j.jdbc.JDBCAppender"> <param name="URL" value="jdbc:sqlserver://localhost:1433;databaseName=myDB"/> <param name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/> <param name="user" value="User"/> <param name="password" value="UserPass"/> <param name="sql" value="exec [dbo].[usp_insert_log_table] 'MyTestJBOSS','clientIP','serverIP','%p','%m'"/> </log4j-appender> 

Gives an error message:

DEPLOYMENTS IN ERROR: Deployment "vfs: /// D: /jboss-6.0.0.Final/server/all/deploy/jboss-logging.xml" org.jboss. xb.binding.JBossXBRuntimeException: {urn: jboss: logging: 6.0} param not found as a child of {urn: jboss: logging: 6.0} log4j-appender in all: {urn: jboss: logging: 6.0} level? {urn: jboss: logging: 6.0} sub-handlers * {urn: jboss: logging: 6.0} formatter? {urn: jboss: logging: 6.0} loggers * {urn: jboss: logging: 6.0} error-manager? {urn: jboss: logging: 6.0} properties * {urn: jboss: logging: 6.0} filter?

I tried to delete the jboss-logger.xml file. All the same, it displays the old format in the console and the file, if you change something, for example, the console output pattern - everything works. On the local example, records in SQL are added (ie, the login, password, base, host, query settings are correct).