About jdbc channel

["Yanzhi.liu" <40...@qq.com>]

Hello:
     I am using the mongodb database.My flume source is custom directory source.
     I am configuration with jdbc channel,but the flume.log was :
 2012-09-28 20:56:49,468 INFO lifecycle.LifecycleSupervisor: Stopping component: org.apache.flume.channel.jdbc.JdbcChannel@1690ab
2012-09-28 20:56:49,612 INFO impl.JdbcChannelProviderImpl: Embedded Derby shutdown raised SQL STATE 45000 as expected.
2012-09-28 20:56:49,613 INFO properties.PropertiesFileConfigurationProvider: Creating channels
2012-09-28 20:56:49,613 WARN impl.JdbcChannelProviderImpl: No connection URL specified. Using embedded derby database instance.
2012-09-28 20:56:49,613 WARN impl.JdbcChannelProviderImpl: Overriding values for - driver: org.apache.derby.jdbc.EmbeddedDriver, user: saconnectUrl: jdbc:derby:/home/flume/.flume/jdbc-channel/db;create=true, jdbc properties file: null, dbtype: DERBY
I want to know how to configuration that the jdbc channel will be run.
 Thanks very much!
 My Name:
 Yanzhi Liu

Re: About jdbc channel

[Hari Shreedharan <hs...@cloudera.com>]

Is there any specific reason that you are using jdbc channel? I would recommend using the FileChannel. The File Channel is what we would currently recommend for use as a durable channel. We have improved the channel a lot in the recent weeks. To take advantage of the latest features added to the channel, you can build it and drop in the new jars, or wait for the next release, which should happen soon. 

Thanks,
Hari

-- 
Hari Shreedharan


On Friday, September 28, 2012 at 9:04 PM, Yanzhi.liu wrote:

> Hello:
>     I am using the mongodb database.My flume source is custom directory source.
>     I am configuration with jdbc channel,but the flume.log was :
> 2012-09-28 20:56:49,468 INFO lifecycle.LifecycleSupervisor: Stopping component: org.apache.flume.channel.jdbc.JdbcChannel@1690ab (mailto:org.apache.flume.channel.jdbc.JdbcChannel@1690ab)
> 2012-09-28 20:56:49,612 INFO impl.JdbcChannelProviderImpl: Embedded Derby shutdown raised SQL STATE 45000 as expected.
> 2012-09-28 20:56:49,613 INFO properties.PropertiesFileConfigurationProvider: Creating channels
> 2012-09-28 20:56:49,613 WARN impl.JdbcChannelProviderImpl: No connection URL specified. Using embedded derby database instance.
> 2012-09-28 20:56:49,613 WARN impl.JdbcChannelProviderImpl: Overriding values for - driver: org.apache.derby.jdbc.EmbeddedDriver, user: saconnectUrl: jdbc:derby:/home/flume/.flume/jdbc-channel/db;create=true, jdbc properties file: null, dbtype: DERBY
> I want to know how to configuration that the jdbc channel will be run. 
> Thanks very much!
> My Name:
> Yanzhi Liu
> 
> 
> 
> 
> 
> 
> 
>