The field names are case sensitive. But if the <field> tags are
missing they are mapped to corresponding solr fields in a case
insensistive way.apparently all the fields come out of you ALL CAPS
you should put the 'column' values in ALL CAPS too
On Sun, Dec 27, 2009 at 9:03 PM, Jay Fisher <jay.l.fis...@gmail.com> wrote:
> I did run it without debug and the result was that 0 documents were
> processed.
>
> The problem seems to be with the <field> tags that I was using to map from
> the table column names to the schema.xml field names. I switched to using an
> AS clause in the SQL statement instead and it worked.
>
> I think the column names may be case-sensitive, although I haven't proven
> that to be the case. I did discover that references to column names in the
> velocity template are case sensitive; ${dproduc.DPRPRD} works
> and ${dproduc.dprprd} does not.
>
> Thanks, Jay
>
> 2009/12/27 Noble Paul നോബിള് नोब्ळ् <noble.p...@corp.aol.com>
>
>> did you run it w/o the debug?
>>
>> On Sun, Dec 27, 2009 at 6:31 PM, AHMET ARSLAN <iori...@yahoo.com> wrote:
>> >> I'm trying to use DataImportHandler
>> >> to load my index and having some strange
>> >> results. I have two tables in my database. DPRODUC contains
>> >> products and
>> >> FSKUMAS contains the skus related to each product.
>> >>
>> >> This is the data-config I'm using.
>> >>
>> >> <dataConfig>
>> >> <dataSource type="JdbcDataSource"
>> >>
>> >> driver="com.ibm.as400.access.AS400JDBCDriver"
>> >>
>> >> url="jdbc:as400:IWAVE;prompt=false;naming=system"
>> >>
>> >> user="IPGUI"
>> >>
>> >> password="IPGUI"/>
>> >> <document>
>> >> <entity name="dproduc"
>> >> query="select dprprd, dprdes from
>> >> dproduc where dprprd like 'F%'">
>> >> <field column="dprprd" name="id"
>> >> />
>> >> <field column="dprdes" name="name"
>> >> />
>> >> <entity name="fskumas"
>> >> query="select fsksku, fcoclr,
>> >> fszsiz, fskret
>> >> from fskumas where
>> >> dprprd='${dproduc.DPRPRD}'">
>> >> <field
>> >> column="fsksku" name="sku" />
>> >> <field
>> >> column="fcoclr" name="color" />
>> >> <field
>> >> column="fszsiz" name="size" />
>> >> <field
>> >> column="fskret" name="price" />
>> >> </entity>
>> >> </entity>
>> >> </document>
>> >> </dataConfig>
>> >
>> > What is the primary key of dproduc table? If it is dprprd can you try
>> adding pk="dprprd" to <entity name="dproduc"?
>> >
>> > <entity name="dproduc" pk="dprprd" query="select dprprd, dprdes from
>> dproduc where dprprd like 'F%'">
>> >
>> >
>> >
>> >
>>
>>
>>
>> --
>> -----------------------------------------------------
>> Noble Paul | Systems Architect| AOL | http://aol.com
>>
>
--
-----------------------------------------------------
Noble Paul | Systems Architect| AOL | http://aol.com
