Hello Paul,
thank you for your reply.
The UPDATE in fact works fine: I only had to update the CREATION_TIME on the
DB :-)
Regarding the deletedPkQuery, I understand it has to return the primary keys
that should be removed from the index (because they have been removed from
the DB) but I don't have any "deleted" flag on the DB.
Basically the deletedPkQuery should be something like "select URI *
from_the_current_index* where URI is not in (select URI from TEST)"
That is returning a subset of primary keys currently in the index and that
are not in the DB anymore. Is this possible?
I am no DB expert...so ANY tip is very welcome!
Thanks,
Giovanni
On 3/18/09, Noble Paul നോബിള് नोब्ळ् <noble.p...@gmail.com> wrote:
>
> are you sure your schema.xml has a <uniqueKey> field to UPDATE docs.
>
> to remove deleted docs you must have deletedPkQuery attribute in the root
> entity
>
> On Tue, Mar 17, 2009 at 8:48 PM, Giovanni De Stefano
> <giovanni.destef...@gmail.com> wrote:
> > Hello all,
> >
> > I have a table TEST in an Oracle DB with the following columns: URI
> > (varchar), CONTENT (varchar), CREATION_TIME (date).
> >
> > The primary key both in the DB and Solr is URI.
> >
> > Here is my data-config.xml:
> >
> > <dataConfig>
> > <dataSource
> > driver="oracle.jdbc.driver.OracleDriver"
> > url="jdbc:oracle:thin:@localhost:1521/XE"
> > user="username"
> > password="password"
> > />
> > <document name="Test">
> > <entity
> > name="test_item"
> > pk="URI"
> > query="select URI,CONTENT from TEST"
> > * deltaQuery="select URI,CONTENT from TEST where
> > TO_CHAR(CREATION_TIME,'YYYY-MM-DD HH:MI:SS') >
> > '${dataimporter.last_index_time}'" *
> > >
> > <field column="URI" name="uri"/>
> > <field column="CONTENT" name="content"/>
> > </entity>
> > </document>
> > </dataConfig>
> >
> > The problem is that anytime I perform a delta-import, the index keeps
> being
> > populated as if new documents were added. In other words, I am not able
> to
> > UPDATE an existing document or REMOVE a document that is not anymore in
> the
> > DB.
> >
> > What am I missing? How should I specify my deltaQuery?
> >
> > Thanks a lot in advance!
> >
> > Giovanni
> >
>
>
>
> --
> --Noble Paul
>
