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
