problem with db-data-config.xml (sqltonosqlimporter with mongodb)

[Dabei]

Hi,

We're using sql to nosql importer in order to import the data in
mongodb and it's working.

Now, we 're trying to join 2 tables in one document by merging the
fileds "matri" (in our exemple), with several entity, like we can see
in the exemple :http://wiki.apache.org/solr/
DataImportHandler#Configuration_in_data-config.xml

But now, we have a problem. We are writing in db-data-config.xml :

<dataConfig onError="continue">

<dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://
localhost/maif" user="icam" password="icam" batch-size="-1"/>

<document>
<entity name="hoprols" query="select matri from hoprols " >
<field column="matri" name="matri" type="string" />
</entity>

<entity name="hophjoun" query="select sectori from hophjoun where
hoprols_matri='${hoprols.matri}' " >
<field column="sectori" name="sectori" type="string" />
</entity>
</document>
</dataConfig>

No problem with the compilation, but in mongodb we don't have the
column sectori in the database.

We're trying to understand the problem, are you thinking the
configuration of solr might be the problem or the folder db-data-
config.xml is not good?