What's wrong with my log4j2.xml configuration ?

[tangara goh]

Hi expert,

I suspect that there is something wrong with my log4j2.xml configuration.

Hope someone can point me the error.

Tks.

<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
	<Appenders>

		<!-- Console Appender -->
		<Console name="Console" target="SYSTEM_OUT">
			<PatternLayout
				pattern="%d{yyyy-MMM-dd HH:mm:ss a} [%t] %-5level %logger{36} - %msg%n" />
		</Console>


	</Appenders>
	<appenders>
		<Jdbc name="databaseAppender" tableName="hi5.tutor">
			<Column name="level" pattern="%level" />
			<Column name="logger" pattern="%logger" />
			<Column name="message" pattern="%message" />
		</Jdbc>
	</appenders>
	<appenders>
		<Jdbc name="databaseAppender" tableName="hi5.subject">
			<Column name="level" pattern="%level" />
			<Column name="logger" pattern="%logger" />
			<Column name="message" pattern="%message" />
		</Jdbc>
	</appenders>
	<appenders>
		<Jdbc name="databaseAppender" tableName="hi5.subject_tutor">
			<Column name="level" pattern="%level" />
			<Column name="logger" pattern="%logger" />
			<Column name="message" pattern="%message" />
		</Jdbc>
	</appenders>

	<Configuration status="WARN">
		<Appenders>
			<Console name="Console" target="SYSTEM_OUT">
				<PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
			</Console>
		</Appenders>
	</Configuration>
	<!-- Log SQL statements -->
	<Logger name="org.hibernate.SQL" level="debug" additivity="false">
		<AppenderRef ref="Console" />
		<AppenderRef ref="File" />
	</Logger>

	<Loggers>
		<Root level="warn">
			<AppenderRef ref="databaseAppender" />
		</Root>
	</Loggers>

	<!-- Log JDBC bind parameters -->
	<Logger name="org.hibernate.type.descriptor.sql" level="trace"
		additivity="false">
		<AppenderRef ref="Console" />
		<AppenderRef ref="File" />
	</Logger>
	<logger name="org.hibernate.type" level="ALL" />
	<logger name="org.hibernate" level="DEBUG" />

	<Root level="error">
		<AppenderRef ref="Console" />
	</Root>
</Configuration>

Basically, the priority is checking what's wrong with my jdbc datasource conneciton error.

Tks.

[Dana Ucaed]

Did you add the try catch in your code?

[Tim Cooke]

Can you describe the error you're getting? Perhaps you're expecting something to happen that isn't?

Your question isn't far off "it doesn't work" which is not helpful. Please provide more details of your problem.