lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Noble Paul നോബിള്‍ नोब्ळ् <noble.p...@corp.aol.com>
Subject Re: Problem with simple use of DIH
Date Mon, 28 Dec 2009 06:27:57 GMT
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.fisher@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.paul@corp.aol.com>
>
>> did you run it w/o the debug?
>>
>> On Sun, Dec 27, 2009 at 6:31 PM, AHMET ARSLAN <iorixxx@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

Mime
View raw message