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
