I thought 1.4 was not released yet?
Noble Paul നോബിള് नोब्ळ्-2 wrote:
>
> I vaguely remember there was an issue with delta-import in 1.3. could
> you try it out with Solr1.4
>
> On Wed, Sep 16, 2009 at 6:14 PM, KirstyS <kirst...@gmail.com> wrote:
>>
>> I hope this is the correct place to post this issue and if so, that
>> someone
>> can help.
>> I am using the DIH with Solr 1.3
>> My data-config.xml file looks like this:
>> <dataSource
>> driver="net.sourceforge.jtds.jdbc.Driver"
>> url="jdbc:jtds:sqlserver:{taken out for posting}
>> user={taken out for posting}
>> password={taken out for posting} />
>>
>> <entity name="article" pk="CmsArticleId"
>> query="Select a.CmsArticleId, a.CreatorId , LastUpdatedBy,
>> LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
>> ArticleTypeId,
>> a.StrapHead, ShortHeading, HomePageBlurb,
>> ByLine,
>> ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
>> c.CategoryId, AncestralName, CategoryName,
>> CategoryDisplayName, ParentCategoryId, c.SiteId
>> from Category c (nolock)
>> inner join CmsArticleCollection ac (nolock) on
>> c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
>> inner join CmsArticleArticleCollection aac
>> (nolock)
>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
>> inner join CmsArticle a (nolock) on
>> aac.CmsArticleId
>> = a.CmsArticleId
>> where (a.LiveEdit is null or a.LiveEdit = 0)
>> and aac.SourceCmsArticleArticleCollectionId is
>> null"
>> deltaQuery="Select a.CmsArticleId, a.CreatorId ,
>> LastUpdatedBy,
>> LastUpdateDate, Title, Synopsis, Author, Source, IsPublished,
>> ArticleTypeId,
>> a.StrapHead, ShortHeading, HomePageBlurb,
>> ByLine,
>> ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank,
>> c.CategoryId, AncestralName, CategoryName,
>> CategoryDisplayName, ParentCategoryId, c.SiteId
>> from Category c (nolock)
>> inner join CmsArticleCollection ac (nolock) on
>> c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId
>> inner join CmsArticleArticleCollection aac
>> (nolock)
>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId
>> inner join CmsArticle a (nolock) on
>> aac.CmsArticleId
>> = a.CmsArticleId
>> where (a.LiveEdit is null or a.LiveEdit = 0)
>> and aac.SourceCmsArticleArticleCollectionId is
>> null
>> and (LastUpdateDate >
>> '${dataimporter.last_index_time}'
>> OR a.CreationDate > '${dataimporter.last_index_time}')" >
>>
>> Have tried casting the dataimporter.last_index_time and the other date
>> fields. To no avail. My Full Import works perfectly but I cannot get the
>> command=delta-import to pick up the updated records. The LastUpdateDate
>> is
>> being updated. When I run this in the debug interface with delta-import
>> it
>> just never calls the delta import.
>> Please, if anyone knows what I am doing wrong???
>> Many thanks
>> Kirsty
>> --
>> View this message in context:
>> http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
>
--
View this message in context:
http://www.nabble.com/DeltaImport-problem-tp25471596p25471927.html
Sent from the Solr - User mailing list archive at Nabble.com.
