title: I want to use multiple datasources in DataImporthandler in Solr and pass URL value in child entity after querying database in parent entity
body: <p>I want to use multiple datasources in DataImporthandler in Solr and pass URL value in child entity after querying database in parent entity.
  Here is my rss-data-config file:</p>
  
  <pre><code>&lt;dataConfig&gt;
      &lt;dataSource type="JdbcDataSource" name="ds-db" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/HCDACoreDB" 
                              user="root" password="CDA@318"/&gt;
      &lt;dataSource type="URLDataSource" name="ds-url"/&gt;
      &lt;document&gt;
          &lt;entity name="feeds" query="select f.feedurl, f.feedsource, c.categoryname from feeds f, category c where f.feedcategory = c.categoryid"&gt;
  
          &lt;field column="feedurl" name="url" dataSource="ds-db"/&gt;
          &lt;field column="categoryname" name="category" dataSource="ds-db"/&gt;
  
          &lt;field column="feedsource" name="source" dataSource="ds-db"/&gt;
  
          &lt;entity name="rss"
                  transformer="HTMLStripTransformer" 
                  forEach="/RDF/channel | /RDF/item" 
                  processor="XPathEntityProcessor" 
                  url="${dataimporter.functions.encodeUrl(feeds.feedurl)}" &gt; 
  
              &lt;field column="source-link" dataSource="ds-url" xpath="/rss/channel/link" commonField="true" /&gt;
              &lt;field column="Source-desc" dataSource="ds-url" xpath="/rss/channel/description" commonField="true" /&gt;
              &lt;field column="title" dataSource="ds-url" xpath="/rss/channel/item/title" /&gt;
              &lt;field column="link" dataSource="ds-url" xpath="/rss/channel/item/link" /&gt;
              &lt;field column="description" dataSource="ds-url" xpath="/rss/channel/item/description" stripHTML="true"/&gt;
              &lt;field column="pubDate" dataSource="ds-url" xpath="/rss/channel/item/pubDate" /&gt;
              &lt;field column="guid" dataSource="ds-url" xpath="/rss/channel/item/guid" /&gt;
              &lt;field column="content" dataSource="ds-url" xpath="/rss/channel/item/content" /&gt;
              &lt;field column="author" dataSource="ds-url" xpath="/rss/channel/item/creator" /&gt;
          &lt;/entity&gt;
  
      &lt;/entity&gt;
  &lt;/document&gt;
  </code></pre>
  
  <p></p>
  
  <p>What I am doings is in first entity named feeds I am querying database and want to use the feedurl as the URL for the child entity names rss.</p>
  
  <p>The error I get when I run the dataimport is:
  java.net.MalformedURLException: no protocol: nullselect f.feedurl, f.feedsource, c.categoryname from feeds f, category c where f
  .feedcategory = c.categoryid</p>
  
  <p>the URL us NULL meaning its not assigning the feedurl to URL. </p>
  
  <p>Any suggestion on what I am doing wrong?</p>