You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4j-user@logging.apache.org by gokulvsmail <go...@gmail.com> on 2013/07/28 16:44:14 UTC
Error in JDBCAppender when used with tomcat6 and log4j2
hi,
when i am trying to use the jdbcappender..am getting the error as
No suitable driver found in the Tomcat startup
am using log4j2
Tomcat 6.0.37
servlet 2.5,
jre 1.6
db mysql
I put the mysql-connector-bin_5.1.jar at the tomcat/lib
am still getting the same error
Seeking hlep from the group
Gokul
---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org
Re: Error in JDBCAppender when used with tomcat6 and log4j2
Posted by gokulvsmail <go...@gmail.com>.
hi,
here is my log4j2.xml
<?xml version="1.0" encoding="UTF-8"?>
<configuration status="WARN">
<appenders>
<Console name="Console" target="SYSTEM_OUT">
<PatternLayout
pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} -->
%msg%n" />
</Console>
<File name="File" fileName="/home/gokul/base/logs/test.log">
<PatternLayout
pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} -->
%msg%n" />
</File>
<Jdbc name="databaseAppender" tableName="msaq_loggs">
<DriverManager
url="jdbc:mysql://localhost:3306/sam_logging_info"
username="sam" password="sam" />
<Column name="date" isEventTimestamp="true" /> <Column
name="level" pattern="%level"/>
<Column name="logger" pattern="%logger" /> <Column
name="message" pattern="%message"/>
</Jdbc>
</appenders>
<loggers>
<logger name="skull.resp" level="debug" additivity="false">
<appender-ref ref="Console" />
<appender-ref ref="databaseAppender" />
<appender-ref ref="File" />
</logger>
<root level="debug">
<appender-ref ref="Console" />
</root>
</loggers>
</configuration>
On Sunday 28 July 2013 08:17 PM, Nick Williams wrote:
> Please paste your log4j2.xml/json config file. All of the information you have given is helpful, but it's not quite enough.
>
> Nick
>
> On Jul 28, 2013, at 9:44 AM, gokulvsmail wrote:
>
>> hi,
>> when i am trying to use the jdbcappender..am getting the error as
>> No suitable driver found in the Tomcat startup
>>
>> am using log4j2
>> Tomcat 6.0.37
>> servlet 2.5,
>> jre 1.6
>> db mysql
>>
>> I put the mysql-connector-bin_5.1.jar at the tomcat/lib
>>
>> am still getting the same error
>>
>> Seeking hlep from the group
>>
>> Gokul
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
>> For additional commands, e-mail: log4j-user-help@logging.apache.org
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
> For additional commands, e-mail: log4j-user-help@logging.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org
Re: Error in JDBCAppender when used with tomcat6 and log4j2
Posted by Nick Williams <ni...@nicholaswilliams.net>.
Please paste your log4j2.xml/json config file. All of the information you have given is helpful, but it's not quite enough.
Nick
On Jul 28, 2013, at 9:44 AM, gokulvsmail wrote:
> hi,
> when i am trying to use the jdbcappender..am getting the error as
> No suitable driver found in the Tomcat startup
>
> am using log4j2
> Tomcat 6.0.37
> servlet 2.5,
> jre 1.6
> db mysql
>
> I put the mysql-connector-bin_5.1.jar at the tomcat/lib
>
> am still getting the same error
>
> Seeking hlep from the group
>
> Gokul
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
> For additional commands, e-mail: log4j-user-help@logging.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org