yeah, not yet released but going to be released pretty soon On Wed, Sep 16, 2009 at 6:32 PM, KirstyS <kirst...@gmail.com> wrote: > > 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. > >
-- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com