Figured out. I have to specify the column name incident_id in uppercase:
Looks like it is case sensitive for the transformer, even though to Oracle,
the column name is not case sensitive.
Thanks,
RTI QA
On Fri, May 4, 2012 at 1:44 PM, RTI QA wrote:
> I specified template in a field
>
> template="inc-${incident.incident_id}" />
>
> When doing full import, for each row retrieved from oracle, there is this
> output in the console:
>
> May 03, 2012 3:47:08 PM
> org.apache.solr.handler.dataimport.TemplateTransformer transformRow
>
> WARNING: Unable to resolve variable: incident.incident_id while parsing
> expression: inc-${incident.incident_id}
>
>
> Below is the data-config.xml file where the template is defined:
>
>
>
>
>
>
> url="jdbc:oracle:thin:@//dbtest:1521/ORCL" user="user" password="xxx"/>
>
>
>
>
>
>
>
>
> transformer="TemplateTransformer"
>
> query="select incident_id, ('inc-' || incident_id ) unique_id,
> long_desc from incident"
>
> deltaQuery="select incident_id from incident where last_update
> > TO_DATE('${dataimporter.last_index_time}','-MM-DD HH24:MI:SS') "
>
> >
>
>
>
>
>
> template="inc-${incident.incident_id}" />
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Have tried to change the template to
>
>
> template="inc-${incident_id}"
>
>
> Still no luck, similar error.
>
>
> Don't know what the TemplateTransformer is looking for to match the
> variable.
>
>
> Thanks,
>
> RTI QA
>
