Hi,
I did a debugger session and found that the column names are case sensitive
(at least with Oracle).
The column names are retreived from the JDBC metadatas and I found that my
objectid is in fact OBJECTID.
So now, I'm able to do an update with the following config (pay attention to
the OBJECTID):
<entity name="test" pk="OBJECTID"
query="select * from table"
deltaImportQuery="select * from table where
objectid='${dataimporter.delta.OBJECTID}'"
deltaQuery="select objectid from table where lastupdate >
'${dataimporter.last_index_time}'">
</entity>
Is there a way to be "case insensitive" ?
Anyway, it works now and that's the most important thing!
:-)
Thanks to all,
Florian
cbennett wrote:
>
> Hi,
>
> It looks like the deltaImportQuery needs to be changed you are using
> dataimporter.delta.id which is not correct, you are selecting objected in
> the deltaQuery, so the deltaImportQuery should be using
> dataimporter.delta.objectid
>
> So try this:
>
> <entity name="test" pk="objectid"
> query="select * from table"
> deltaImportQuery="select * from table where
> objectid='${dataimporter.delta.objectid}'"
> deltaQuery="select objectid from table where lastupdate >
> '${dataimporter.last_index_time}'">
> </entity>
>
> Colin.
>
--
View this message in context:
http://lucene.472066.n3.nabble.com/Problem-with-DIH-delta-import-on-JDBC-tp763469p765262.html
Sent from the Solr - User mailing list archive at Nabble.com.
