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
>
