Without more of the stacktrace I don't think you'll get much help. However, its my experience that exceptions that begin with "Unable to execute query" mean the db didn't like something about one or both queries. I think it would have listed in there somewhere the actual query it didn't like, depending on your db driver. If memory serves correct, i think the oracle driver also lists out why it didn't like the query in the exception.
James Dyer Ingram Content Group (615) 213-4311 -----Original Message----- From: Lokn [mailto:nlokesh...@gmail.com] Sent: Friday, December 13, 2013 3:40 AM To: solr-user@lucene.apache.org Subject: SOLR DIH - Sub Entity with different datasource not working Hi, I have the data-config.xml with 2 data sources and the entity and sub sub-entity connecting to datasource1 and datasource2 respectively. When I do the full import, it is giving an error, Exception : org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: This is my db-data-config.xml configuration file: <dataSource name="datasource1" type="JdbcDataSource" driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@blah" user="aaa" password=aaa" /> <dataSource name="datasource2" type="JdbcDataSource" driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@blah" user="bbb" password="bbb" /> <document> <entity name="item1" dataSource="datasource1" query="select NAME, CREATED_BY from CSPR_TABLE"> <field column="NAME" name="name"/> <field column="CREATED_BY" name="user"/> <entity name="itemSubEntity" dataSource="datasource1" query="select USER_ID , PREF from PREF where USER_ID = '${item1.CREATED_BY}'"> <field column="USER_ID" name="uid"/> <field column="PREF" name="pref"/> </entity> </entity> </document> Let me know if there is anything wrong in this. Thanks, Lokesh -- View this message in context: http://lucene.472066.n3.nabble.com/SOLR-DIH-Sub-Entity-with-different-datasource-not-working-tp4106550.html Sent from the Solr - User mailing list archive at Nabble.com.
