title: Indexing oracle (XMLTYPE) attribute in elasticsearch using logstash
body: <p><strong>Query :</strong> </p>
  
  <p>SELECT event_event_dt, event_event_tm, ilmd FROM event;</p>
  
  <p><strong>ilmd</strong> filed is of (XMLTYPE) in Oracle DB which contains xml document in it. I am trying to index it in elastic search using logstash.</p>
  
  <p>My configuration file is below, I am not able to index it.</p>
  
  <pre><code>input {
      jdbc {
          jdbc_validate_connection =&gt; true
          jdbc_connection_string =&gt; "jdbc:oracle:thin:@localhost:1521/orcl"
          jdbc_user =&gt; "abc"
          jdbc_password =&gt; "abc"
          jdbc_driver_library =&gt; "/home/abc/ES/ojdbc6-11.2.0.4.0.jar"
          jdbc_driver_class =&gt; "Java::oracle.jdbc.driver.OracleDriver"
          statement =&gt; "SELECT event_event_dt, event_event_tm, ilmd FROM event"
          last_run_metadata_path =&gt; "/tmp/logstash-oradb.lastrun"
          record_last_run =&gt; true
      }
  }
  filter {
      mutate { convert =&gt; [ "sample_time" , "string" ]}
      date { match =&gt; ["sample_time", "ISO8601"]}
      xml {
       source =&gt; "ilmd"
       xpath =&gt; ["/ilmd/@string","profile"]
     }
  }
  output   {
      elasticsearch {
        index =&gt; "userProfile"
        document_type =&gt; "user_data"
        workers =&gt; 2
      }
  }
  </code></pre>
  
  <p>No index filed named <strong>ilmd</strong> has been created, neither any error on the console. Simply a message on the console "Configuration Ok".</p>