Thank for your response.
I have 7 files *.xml. I already worked with SOlr but i have an only file. My
question is why in this project there's 7 files describing an entity.
Here my files:
<dataConfig>
<dataSource name="" driver="org.postgresql.Driver"
url="" user=""
password="" readOnly="true" autoCommit="false"
batchSize="100000"
transactionIsolation="TRANSACTION_READ_COMMITTED"
holdability="CLOSE_CURSORS_AT_COMMIT" />
<document>
<entity rootEntity="true" name="tiers" dataSource=""
query="select * from bi_solr_tiers"
transformer="RegexTransformer">
<field name="ID" column="tiers_id" />
<field name="DOC_TYPE" column="tiers_doc_type" />
<field name="ID_CLIENT" column="tiers_id_client" />
<field name="NOM_CLIENT" column="tiers_nom_client" />
<field name="ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="ID_SEGMENT" column="tiers_id_segment" />
<field name="ID_SALE" column="tiers_id_sale" />
<field name="NOM_SALE" column="tiers_nom_sale" />
<field name="U_ID_CLIENT" column="tiers_id_client" />
<field name="U_NOM_CLIENT" column="tiers_nom_client" />
<field name="U_ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="U_ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="U_ID_SEGMENT" column="tiers_id_segment" />
<field name="U_ID_SALE" column="tiers_id_sale" />
<field name="U_NOM_SALE" column="tiers_nom_sale" />
<entity name="tiers_contrat" dataSource=""
query="select * from bi_solr_contrat">
<field name="ID_PARTENAIRE"
column="contrat_id_partenaire" />
<field name="NOM_PARTENAIRE"
column="contrat_nom_partenaire" />
<field name="TYPE_PARTENAIRE"
column="contrat_type_partenaire" />
<field name="ID_TYPE_SERVICE"
column="contrat_id_type_service" />
<field name="ID_FILIALE"
column="contrat_id_filiale" />
<field name="NOM_FILIALE"
column="contrat_nom_filiale" />
<field name="COMPTE_WEB_POSSIBLE"
column="contrat_compte_web_possible"
/>
<field name="ID_CONTRAT"
column="contrat_id_contrat" />
<field name="ID_STATUT_CONTRAT"
column="contrat_id_statut_contrat" />
<field name="NOM_PRODUIT"
column="contrat_nom_produit" />
<field name="ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="ID_BENEFICIAIRE_HONO"
column="contrat_id_beneficiaire_hono"
/>
<field name="ID_PAYEUR_CONSO"
column="contrat_id_payeur_conso" />
<field name="ID_PAYEUR_HONO"
column="contrat_id_payeur_hono" />
<field name="REF_CONTRAT_TVA"
column="contrat_ref_contrat_tva" />
<field name="PAYS_DEPOT_TVA"
column="contrat_pays_depot_tva" />
</entity>
<entity name="tiers_carte" dataSource=""
query="select
carte_id_client,
carte_id_carte,
carte_num_carte,
carte_carte_active,
carte_immatriculation,
carte_nom_flotte
from bi_solr_carte"
cacheKey="carte_id_client"
cacheLookup="tiers.tiers_id_client"
>
<field name="ID_CARTE" column="carte_id_carte"
/>
<field name="NUM_CARTE"
column="carte_num_carte" />
<field name="CARTE_ACTIVE"
column="carte_carte_active" />
<field name="IMMATRICULATION"
column="carte_immatriculation" />
<field name="NOM_FLOTTE"
column="carte_nom_flotte" />
</entity>
<entity name="tiers_invoice" dataSource=""
query="select
distinct bi_solr_invoice.*,
bi_solr_contrat.contrat_id_client
from bi_solr_invoice
inner join bi_solr_invoice_cnt
on
bi_solr_invoice.invoice_numero_facture=bi_solr_invoice_cnt.numero_facture
inner join bi_solr_contrat on
bi_solr_contrat.contrat_id_contrat=bi_solr_invoice_cnt.id_contrat">
<field name="NUMERO_FACTURE"
column="invoice_numero_facture" />
<field name="ID_BENEFICIAIRE"
column="invoice_id_beneficiaire" />
<field name="ID_PAYEUR"
column="invoice_id_payeur" />
<field name="DATE_EMISSION"
column="invoice_date_emission" />
<field name="DATE_EMISSION_DD_MM_YYYY"
column="invoice_date_emission_dd_mm_yyyy" />
<field name="DATE_EMISSION_MM_YYYY"
column="invoice_date_emission_mm_yyyy" />
<field name="DATE_EMISSION_YYYY"
column="invoice_date_emission_yyyy" />
<field name="DEVISE" column="invoice_devise" />
<field name="INVOICE_TOTAL_HT"
column="invoice_total_ht" />
<field name="INVOICE_TOTAL_TVA"
column="invoice_total_tva" />
<field name="INVOICE_TOTAL_TTC"
column="invoice_total_ttc" />
</entity>
<entity name="tiers_conso" dataSource=""
query="select
conso_id_client,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where
conso_id_client is not null
and (conso_type_transaction is
null or conso_type_transaction !=
'1')">
<field name="NUM_CARTE"
column="conso_numero_carte" />
<field name="IMMATRICULATION"
column="conso_immatriculation" />
<field name="NOM_FLOTTE"
column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso"
/>
<field name="NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE"
column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE"
column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE"
column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE"
column="conso_sca_sortie" />
<field name="STATUT_CONSO"
column="conso_statut" />
</entity>
<entity name="tiers_conso_remise" dataSource=""
query="select
conso_id_client,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where
conso_id_client is not null
and conso_type_transaction !=
'3'">
<field name="NUM_CARTE"
column="conso_numero_carte" />
<field name="IMMATRICULATION"
column="conso_immatriculation" />
<field name="NOM_FLOTTE"
column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso"
/>
<field name="NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE"
column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE"
column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE"
column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE"
column="conso_sca_sortie" />
<field name="STATUT_CONSO"
column="conso_statut" />
</entity>
<entity name="tiers_remise" dataSource=""
query="select
remise_id_client,
remise_numero_carte,
remise_immatriculation,
remise_nom_flotte,
remise_id_remise,
remise_sca_entree
from bi_solr_remise where
remise_id_client is not null">
<field name="NUM_CARTE"
column="remise_numero_carte" />
<field name="IMMATRICULATION"
column="remise_immatriculation" />
<field name="NOM_FLOTTE"
column="remise_nom_flotte" />
<field name="ID_REMISE"
column="remise_id_remise" />
<field name="NOM_SCA_ORIGINE"
column="remise_sca_entree" />
</entity>
</entity>
</document>
</dataConfig>
<dataConfig>
<dataSource name="" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/" user=""
password="" readOnly="true" autoCommit="false"
batchSize="100000"
transactionIsolation="TRANSACTION_READ_COMMITTED"
holdability="CLOSE_CURSORS_AT_COMMIT" />
<document>
<entity rootEntity="true" name="carte" dataSource=""
transformer="RegexTransformer"
query="select * from bi_solr_carte
inner join bi_solr_contrat on
bi_solr_carte.carte_id_contrat=bi_solr_contrat.contrat_id_contrat
inner join bi_solr_tiers on
bi_solr_contrat.contrat_id_client=bi_solr_tiers.tiers_id_client">
<field name="ID" column="carte_id" />
<field name="DOC_TYPE" column="carte_doc_type" />
<field name="ID_TYPE_SERVICE"
column="contrat_id_type_service" />
<field name="ID_CONTRAT" column="contrat_id_contrat" />
<field name="ID_CONTRAT_CADRE"
column="contrat_id_contrat_cadre" />
<field name="ID_STATUT_CONTRAT"
column="contrat_id_statut_contrat" />
<field name="ID_PRODUIT" column="contrat_id_produit" />
<field name="NOM_PRODUIT" column="contrat_nom_produit"
/>
<field name="ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="ID_BENEFICIAIRE_HONO"
column="contrat_id_beneficiaire_hono"
/>
<field name="ID_PAYEUR_CONSO"
column="contrat_id_payeur_conso" />
<field name="ID_PAYEUR_HONO"
column="contrat_id_payeur_hono" />
<field name="ID_PARTENAIRE"
column="contrat_id_partenaire" />
<field name="NOM_PARTENAIRE"
column="contrat_nom_partenaire" />
<field name="TYPE_PARTENAIRE"
column="contrat_type_partenaire" />
<field name="ID_FILIALE" column="contrat_id_filiale" />
<field name="NOM_FILIALE" column="contrat_nom_filiale"
/>
<field name="COMPTE_WEB_POSSIBLE"
column="contrat_compte_web_possible" />
<field name="REF_CONTRAT_TVA"
column="contrat_ref_contrat_tva" />
<field name="PAYS_DEPOT_TVA"
column="contrat_pays_depot_tva" />
<field name="ID_CLIENT" column="tiers_id_client" />
<field name="NOM_CLIENT" column="tiers_nom_client" />
<field name="ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="ID_SEGMENT" column="tiers_id_segment" />
<field name="ID_SALE" column="tiers_id_sale" />
<field name="NOM_SALE" column="tiers_nom_sale" />
<field name="ID_CARTE" column="carte_id_carte" />
<field name="ID_COMMANDE" column="carte_id_commande" />
<field name="NUM_CARTE" column="carte_num_carte" />
<field name="DATE_DEB_CARTE"
column="carte_date_deb_carte" />
<field name="DATE_FIN_CARTE"
column="carte_date_fin_carte" />
<field name="CODE_OP_CARTE"
column="carte_code_op_carte" />
<field name="NOM_OP_CARTE" column="carte_nom_op_carte"
/>
<field name="CARTE_ACTIVE" column="carte_carte_active"
/>
<field name="ID_VEHICULE" column="carte_id_vehicule" />
<field name="ID_FLOTTE" column="carte_id_flotte" />
<field name="IMMATRICULATION"
column="carte_immatriculation" />
<field name="NORME_VEHICULE"
column="carte_norme_vehicule" />
<field name="TYPE_VEHICULE"
column="carte_type_vehicule" />
<field name="CLASSE_VEHICULE"
column="carte_classe_vehicule" />
<field name="MEP_VEHICULE" column="carte_mep_vehicule"
/>
<field name="MARQUE_VEHICULE"
column="carte_marque_vehicule" />
<field name="PAYS_VEHICULE"
column="carte_pays_vehicule" />
<field name="NB_ESSIEUX_VEHICULE"
column="carte_nb_essieux_vehicule" />
<field name="PTCA_VEHICULE"
column="carte_ptca_vehicule" />
<field name="CHASSIS_VEHICULE"
column="carte_chassis_vehicule" />
<field name="HAUTEUR_VEHICULE"
column="carte_hauteur_vehicule" />
<field name="LONGUEUR_VEHICULE"
column="carte_longueur_vehicule" />
<field name="LARGEUR_VEHICULE"
column="carte_largeur_vehicule" />
<field name="PTRA_VEHICULE"
column="carte_ptra_vehicule" />
<field name="NOM_FLOTTE" column="carte_nom_flotte" />
<field name="U_ID_TYPE_SERVICE"
column="contrat_id_type_service" />
<field name="U_ID_CONTRAT" column="contrat_id_contrat"
/>
<field name="U_ID_CONTRAT_CADRE"
column="contrat_id_contrat_cadre" />
<field name="U_ID_STATUT_CONTRAT"
column="contrat_id_statut_contrat" />
<field name="U_ID_PRODUIT" column="contrat_id_produit"
/>
<field name="U_NOM_PRODUIT"
column="contrat_nom_produit" />
<field name="U_ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="U_ID_BENEFICIAIRE_HONO"
column="contrat_id_beneficiaire_hono" />
<field name="U_ID_PAYEUR_CONSO"
column="contrat_id_payeur_conso" />
<field name="U_ID_PAYEUR_HONO"
column="contrat_id_payeur_hono" />
<field name="U_ID_PARTENAIRE"
column="contrat_id_partenaire" />
<field name="U_NOM_PARTENAIRE"
column="contrat_nom_partenaire" />
<field name="U_TYPE_PARTENAIRE"
column="contrat_type_partenaire" />
<field name="U_ID_FILIALE" column="contrat_id_filiale"
/>
<field name="U_NOM_FILIALE"
column="contrat_nom_filiale" />
<field name="U_COMPTE_WEB_POSSIBLE"
column="contrat_compte_web_possible"
/>
<field name="U_REF_CONTRAT_TVA"
column="contrat_ref_contrat_tva" />
<field name="U_PAYS_DEPOT_TVA"
column="contrat_pays_depot_tva" />
<field name="U_ID_CLIENT" column="tiers_id_client" />
<field name="U_NOM_CLIENT" column="tiers_nom_client" />
<field name="U_ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="U_ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="U_ID_SEGMENT" column="tiers_id_segment" />
<field name="U_ID_SALE" column="tiers_id_sale" />
<field name="U_NOM_SALE" column="tiers_nom_sale" />
<field name="U_ID_CARTE" column="carte_id_carte" />
<field name="U_ID_COMMANDE" column="carte_id_commande"
/>
<field name="U_NUM_CARTE" column="carte_num_carte" />
<field name="U_DATE_DEB_CARTE"
column="carte_date_deb_carte" />
<field name="U_DATE_FIN_CARTE"
column="carte_date_fin_carte" />
<field name="U_CODE_OP_CARTE"
column="carte_code_op_carte" />
<field name="U_NOM_OP_CARTE"
column="carte_nom_op_carte" />
<field name="U_CARTE_ACTIVE"
column="carte_carte_active" />
<field name="U_ID_VEHICULE" column="carte_id_vehicule"
/>
<field name="U_ID_FLOTTE" column="carte_id_flotte" />
<field name="U_IMMATRICULATION"
column="carte_immatriculation" />
<field name="U_NORME_VEHICULE"
column="carte_norme_vehicule" />
<field name="U_TYPE_VEHICULE"
column="carte_type_vehicule" />
<field name="U_CLASSE_VEHICULE"
column="carte_classe_vehicule" />
<field name="U_MEP_VEHICULE"
column="carte_mep_vehicule" />
<field name="U_MARQUE_VEHICULE"
column="carte_marque_vehicule" />
<field name="U_PAYS_VEHICULE"
column="carte_pays_vehicule" />
<field name="U_NB_ESSIEUX_VEHICULE"
column="carte_nb_essieux_vehicule" />
<field name="U_PTCA_VEHICULE"
column="carte_ptca_vehicule" />
<field name="U_CHASSIS_VEHICULE"
column="carte_chassis_vehicule" />
<field name="U_HAUTEUR_VEHICULE"
column="carte_hauteur_vehicule" />
<field name="U_LONGUEUR_VEHICULE"
column="carte_longueur_vehicule" />
<field name="U_LARGEUR_VEHICULE"
column="carte_largeur_vehicule" />
<field name="U_PTRA_VEHICULE"
column="carte_ptra_vehicule" />
<field name="U_NOM_FLOTTE" column="carte_nom_flotte" />
<entity name="carte_conso" dataSource=""
processor="CachedSqlEntityProcessor"
cacheKey="conso_id_carte"
cacheLookup="carte.carte_id_carte"
query="select
conso_id_carte,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where
conso_id_carte is not null
and (conso_type_transaction is
null or conso_type_transaction !=
'1')">
<field name="NUM_CARTE"
column="conso_numero_carte" />
<field name="IMMATRICULATION"
column="conso_immatriculation" />
<field name="NOM_FLOTTE"
column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso"
/>
<field name="NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE"
column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE"
column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE"
column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE"
column="conso_sca_sortie" />
<field name="STATUT_CONSO"
column="conso_statut" />
</entity>
<entity name="carte_conso_remise" dataSource=""
processor="CachedSqlEntityProcessor"
cacheKey="conso_id_carte"
cacheLookup="carte.carte_id_carte"
query="select
conso_id_carte,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where
conso_id_carte is not null
and conso_type_transaction !=
'3'">
<field name="NUM_CARTE"
column="conso_numero_carte" />
<field name="IMMATRICULATION"
column="conso_immatriculation" />
<field name="NOM_FLOTTE"
column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso"
/>
<field name="NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE"
column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE"
column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE"
column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE"
column="conso_sca_sortie" />
<field name="STATUT_CONSO"
column="conso_statut" />
</entity>
<entity name="carte_invoice" dataSource=""
processor="CachedSqlEntityProcessor"
cacheKey="conso_id_carte"
cacheLookup="carte.carte_id_carte"
query="select
invoice_numero_facture,
invoice_id_beneficiaire,
invoice_id_payeur,
invoice_date_emission,
invoice_date_emission_dd_mm_yyyy,
invoice_date_emission_mm_yyyy,
invoice_date_emission_yyyy,
invoice_devise,
invoice_total_ht,
invoice_total_tva,
invoice_total_ttc,
conso_id_carte
from bi_solr_invoice
inner join bi_solr_transaction
on
invoice_numero_facture=conso_numero_facture
where conso_numero_facture is
not null and conso_id_carte is not
null">
<field name="NUMERO_FACTURE"
column="invoice_numero_facture" />
<field name="ID_BENEFICIAIRE"
column="invoice_id_beneficiaire" />
<field name="ID_PAYEUR"
column="invoice_id_payeur" />
<field name="DATE_EMISSION"
column="invoice_date_emission" />
<field name="DATE_EMISSION_DD_MM_YYYY"
column="invoice_date_emission_dd_mm_yyyy" />
<field name="DATE_EMISSION_MM_YYYY"
column="invoice_date_emission_mm_yyyy" />
<field name="DATE_EMISSION_YYYY"
column="invoice_date_emission_yyyy" />
<field name="DEVISE" column="invoice_devise" />
<field name="INVOICE_TOTAL_HT"
column="invoice_total_ht" />
<field name="INVOICE_TOTAL_TVA"
column="invoice_total_tva" />
<field name="INVOICE_TOTAL_TTC"
column="invoice_total_ttc" />
</entity>
<entity name="carte_remise" dataSource=""
cacheKey="remise_id_carte"
cacheLookup="carte.carte_id_carte"
processor="CachedSqlEntityProcessor"
query="select
remise_id_carte,
remise_numero_carte,
remise_immatriculation,
remise_nom_flotte,
remise_id_remise,
remise_sca_entree
from bi_solr_remise where
remise_id_carte is not null">
<field name="NUM_CARTE"
column="remise_numero_carte" />
<field name="IMMATRICULATION"
column="remise_immatriculation" />
<field name="NOM_FLOTTE"
column="remise_nom_flotte" />
<field name="ID_REMISE"
column="remise_id_remise" />
<field name="NOM_SCA_ORIGINE"
column="remise_sca_entree" />
</entity>
</entity>
</document>
</dataConfig>
--
View this message in context:
http://lucene.472066.n3.nabble.com/Many-mapping-files-tp4236658p4236951.html
Sent from the Solr - User mailing list archive at Nabble.com.
