[
https://issues.apache.org/jira/browse/CAMEL-12331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16399785#comment-16399785
]
Neo Xu edited comment on CAMEL-12331 at 3/15/18 2:10 AM:
---------------------------------------------------------
Can it compare Unix time? for example
{code:java}
SELECT UNIX_TIMESTAMP(cdate) AS unixDate, * FROM mytable where unixDate <
90089999xxxxxx
{code}
was (Author: neoxu999):
Can it compare Unix time? for example
{{{code}}}
{{SELECT UNIX_TIMESTAMP(cdate) AS unixDate, * FROM mytable where unixDate <
90089999xxxxxx}}
{{{code}}}
> camel-sql - JdbcMessageIdRepository should have a background task to delete
> old entries
> ---------------------------------------------------------------------------------------
>
> Key: CAMEL-12331
> URL: https://issues.apache.org/jira/browse/CAMEL-12331
> Project: Camel
> Issue Type: New Feature
> Components: camel-sql
> Reporter: Claus Ibsen
> Priority: Major
> Fix For: 2.22.0
>
>
> You may want to cleanup the database table automatically by Camel so it does
> not contain old data of previous processed files.
> For example to say that entries that are > 24h can be deleted etc.
> This works under the notion that you only use the idempoten check for
> clustering where they may race for processing the same files, or that files
> tomorrow are okay to process with the same name as yesterday etc.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
