<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic DB Connect - Oracle DB - SQL Java Runtime Error when creating input in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-DB-SQL-Java-Runtime-Error-when-creating-input/m-p/556503#M92110</link>
    <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have established a connection to a Oracle DB successfully using DBX.&lt;/P&gt;&lt;P&gt;Now I want to create the input using a queries like this&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Select * from UNIFIED_AUDIT_TRAIL Where EVENT_TIMESTAMP &amp;gt; ? ORDER BY EVENT_TIMESTAMP ASC&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;and i do get Java runtime errors messages like this&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ojay_0-1624269246548.png" style="width: 608px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/14714iA5DC1B9ACEC89852/image-dimensions/608x38?v=v2" width="608" height="38" role="button" title="ojay_0-1624269246548.png" alt="ojay_0-1624269246548.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;It fails at Nr. 4 - How do I make the query accept the checkpoint value?&amp;nbsp; Is there a default query available to make this work?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ojay_1-1624269357694.png" style="width: 251px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/14715iFCE84D8DA857C807/image-dimensions/251x954?v=v2" width="251" height="954" role="button" title="ojay_1-1624269357694.png" alt="ojay_1-1624269357694.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;Jay&lt;/P&gt;</description>
    <pubDate>Mon, 21 Jun 2021 10:04:26 GMT</pubDate>
    <dc:creator>ojay</dc:creator>
    <dc:date>2021-06-21T10:04:26Z</dc:date>
    <item>
      <title>DB Connect - Oracle DB - SQL Java Runtime Error when creating input</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-DB-SQL-Java-Runtime-Error-when-creating-input/m-p/556503#M92110</link>
      <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have established a connection to a Oracle DB successfully using DBX.&lt;/P&gt;&lt;P&gt;Now I want to create the input using a queries like this&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Select * from UNIFIED_AUDIT_TRAIL Where EVENT_TIMESTAMP &amp;gt; ? ORDER BY EVENT_TIMESTAMP ASC&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;and i do get Java runtime errors messages like this&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ojay_0-1624269246548.png" style="width: 608px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/14714iA5DC1B9ACEC89852/image-dimensions/608x38?v=v2" width="608" height="38" role="button" title="ojay_0-1624269246548.png" alt="ojay_0-1624269246548.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;It fails at Nr. 4 - How do I make the query accept the checkpoint value?&amp;nbsp; Is there a default query available to make this work?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ojay_1-1624269357694.png" style="width: 251px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/14715iFCE84D8DA857C807/image-dimensions/251x954?v=v2" width="251" height="954" role="button" title="ojay_1-1624269357694.png" alt="ojay_1-1624269357694.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;Jay&lt;/P&gt;</description>
      <pubDate>Mon, 21 Jun 2021 10:04:26 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-DB-SQL-Java-Runtime-Error-when-creating-input/m-p/556503#M92110</guid>
      <dc:creator>ojay</dc:creator>
      <dc:date>2021-06-21T10:04:26Z</dc:date>
    </item>
  </channel>
</rss>

