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.
