Hello everybody,
I am trying to import from an Oracle DB 11g2 via DIH using SOLR 5.3.1.
In my relational DB there are company addresses (table tb_firmen_adressen) and
branches (table tb_branchen). They have an n:m relationship using the join
table tb_firmen_branchen.
Now I would like to find c
Hi Matthias,
you should use . in your expressions. So for
example, here
WHERE fb.EBI_NR='${firma.firma_ebi_nr}'
should be
WHERE fb.EBI_NR='${firma.EBI_NR}'
Best,
Andrea
2015-10-16 13:40 GMT+02:00 Matthias Fischer :
> Hello everybody,
>
> I am trying to import from an Oracle DB 11g2 via DIH us
on: Andrea Gazzarini [mailto:a.gazzar...@gmail.com]
Gesendet: Freitag, 16. Oktober 2015 13:59
An: solr-user@lucene.apache.org
Betreff: Re: Nested entities not imported / do not show up in search?
Hi Matthias,
you should use . in your expressions. So for example,
here
WHERE fb.EBI_NR='${fir
r.doFullImport(DataImporter.java:416)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
> at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:461)
>
> Kind regards,
> Matthias
>
> -Ursprüngliche N
mport(DataImporter.java:416)
> at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
> at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:461)
>
> Kind regards,
> Matthias
>
> -Ursprüngliche Nachri
24
An: solr-user@lucene.apache.org
Betreff: Re: Nested entities not imported / do not show up in search?
Hi Matthias,
I guess the company.id field is not unique so you need a "compound"
uniqueKey on Solr, which is not strctly possible. As consequence of that
(company) UUID is probably created be
ociated branches. Any suggestions?
>
> Kind regards,
> Matthias
>
> -----Ursprüngliche Nachricht-
> Von: Andrea Gazzarini [mailto:a.gazzar...@gmail.com]
> Gesendet: Freitag, 16. Oktober 2015 17:24
> An: solr-user@lucene.apache.org
> Betreff: Re: Nested entities not impo
ttern and gets a list of matching
> companies including the associated branches. Any suggestions?
>
> Kind regards,
> Matthias
>
> -Ursprüngliche Nachricht-
> Von: Andrea Gazzarini [mailto:a.gazzar...@gmail.com]
> Gesendet: Freitag, 16. Oktober 2015 17:24
> An: sol
: solr-user@lucene.apache.org
Betreff: Re: AW: Nested entities not imported / do not show up in search?
Most probably my answer makes no sense because I don't know the overall
context, but why don't you import flat branches and companies with a "type"
attribute ("company&q