<dataConfig>
<dataSource name="caffdubya" driver="org.postgresql.Driver"
url="jdbc:postgresql://db1/cathdb_v3_3_0" user="USER" password="PASS"
/>
<dataSource name="sinatra" driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@db2:1521:biomapwh" user="USER" password="PASS"
/>
<!-- The following path is on bsmcmp11's local disk for speed. -->
<!-- The master copy (compressed) lives at
/cath/data/current/pdb-XML-noatom -->
<!-- For convenience, there's a script at
bsmcmp11:/export/local/refresh_pdb to copy and unpack it. -->
<dataSource name="filesystem" type="FileDataSource"
basePath="/export/local/pdb-XML-noatom/" encoding="UTF-8"
connectionTimeout="5000" readTimeout="10000"/>
<document>
<entity name="domain" dataSource="caffdubya" query="select *
from domain_text">
<!-- Subquery for related PubMed IDs (we could pull the
actual text in later...) ... NOT WORKING! :-( -->
<entity
name="domain_pubmed_ids"
dataSource="sinatra"
onError="continue"
query="select id as pdb_code, related_id as
related_ids from biomap_admin.uniprot_pdb_pubmed_for_solr where id =
'${domain.pdb_code}'" />
</entity>
<!-- REMOVED MOST ENTITIES FOR TEST PURPOSES, RESTORE FROM
PREVIOUS REVISION -->
</document>
</dataConfig>
2009/11/13 Noble Paul നോബിള് नोब्ळ् <noble.p...@corp.aol.com>:
> am unable to get the file
> http://old.nabble.com/file/p26335171/dataimport.temp.xml
>
> On Fri, Nov 13, 2009 at 4:57 PM, Andrew Clegg <andrew.cl...@gmail.com> wrote:
>>
>>
>>
>> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>>
>>> no obvious issues.
>>> you may post your entire data-config.xml
>>>
>>
>> Here it is, exactly as last attempt but with usernames etc. removed.
>>
>> Ignore the comments and the unused FileDataSource...
>>
>> http://old.nabble.com/file/p26335171/dataimport.temp.xml dataimport.temp.xml
>>
>>
>> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>>
>>> do w/o CachedSqlEntityProcessor first and then apply that later
>>>
>>
>> Yep, that was just a bit of a wild stab in the dark to see if it made any
>> difference.
>>
>> Thanks,
>>
>> Andrew.
>>
>> --
>> View this message in context:
>> http://old.nabble.com/Data-import-problem-with-child-entity-from-different-database-tp26334948p26335171.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
--
Lance Norskog
goks...@gmail.com
