All that stuff happens in the JDBC driver associated w/ the DataSource so
probably not unless there is something which can be set in the Oracle driver
itself.
One thing that might have helped in this case might have been if
readFieldNames() in the JDBCDataSource dumped its return to debug log for you.
That might be something that can be JIRA(ed).
- Jon
On Apr 29, 2010, at 9:45 AM, safl wrote:
>
> 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.
