RE: [DIH] Using SqlEntity to get a list of files and read files in XpathEntityProcessor

[jerome . dupont]

Thanks very much, it works, with dataSource (capital S) !!!
Finally, I didn't have to define a "CHEMINRELATIF" field in the
configuration, it's working without it.

This is the definive working configuration:
                <dataSource name="accesPCN"
                                        type="JdbcDataSource"
                                        driver="oracle.jdbc.driver.OracleDriver"
                                        url="jdbc:oracle:thin:@host:port:db"
                                        user="secret"
                                        password="BNF"/>

                <dataSource name="racineNoticeDatasource"
baseUrl="file:///D:/jed/noticesBib" type="URLDataSource" encoding="UTF-8"/>

                                <entity name="noticebib"
                                        dataSource="accesPCN"
                                        processor="SqlEntityProcessor"
                                        rootEntity="false"
                                        query="select DISTINCT
                SUBSTR( to_char(noticebib.numnoticebib, '999999999'), 3, 1) ||
'/' ||
                SUBSTR( to_char(noticebib.numnoticebib, '999999999'), 4, 1) ||
'/' ||
                SUBSTR( to_char(noticebib.numnoticebib, '999999999'), 5, 3) ||
'/' ||
                to_char(noticebib.numnoticebib) || '.xml' as CHEMINRELATIF
                from bnf.noticebib
                where numnoticebib = '30000001'"
                                        >

                                                <entity  
name="processorDocument"
                                                processor="XPathEntityProcessor"
                                                
dataSource="racineNoticeDatasource"
                                                
url="/${noticebib.CHEMINRELATIF}"
                                                xsl="xslt/mnb/IXM_MNb.xsl"
                                                forEach="/record"

transformer="LogTransformer,fr.bnf.solr.BnfDateTransformer"
                                                logTemplate="Notice fichier: $
{noticebib.CHEMINRELATIF}" logLevel="debug"
                                                >

                                                <field column="Ark"
xpath="/record/IDPerenne" />
                                                <field column="NN"
xpath="/record/@Numero" />


Thanks again!

-----------------------------------------------
Jérôme Dupont
Bibliothèque Nationale de France
Département des Systèmes d'Information
Tour T3 - Quai François Mauriac
75706 Paris Cedex 13
téléphone: 33 (0)1 53 79 45 40
e-mail: jerome.dup...@bnf.fr
-----------------------------------------------


Exposition  Guy Debord, un art de la guerre  - du 27 mars au 13 juillet 2013 - 
BnF - François-Mitterrand / Grande Galerie Avant d'imprimer, pensez à 
l'environnement.