All Apps and Add-ons

dbConnect - java.sql.SQLException: Invalid column index

BernardEAI
Communicator

Hi

I'm trying to set up a query in dbConnect. I have configured the connection correctly. I'm running the following query:

SELECT CREATE_DATE,
DELETE_DATE,
SPLUNK_DEDUP_SQID,
SPLUNK_IDX_ASC,
FROM "USER"."TABLE"
WHERE CREATE_DATE BETWEEN TO_DATE('20161101', 'RRRRMMDD') AND TO_DATE('20180821', 'RRRRMMDD')
ORDER BY SPLUNK_IDX_ASC ASC

If I run this in batch mode, the query works. However, if I run it in "rising" mode,  with SPLUNK_IDX_ASC set as the rising column, the query returns:

java.sql.SQLException: Invalid column index

No results found.

Labels (1)
0 Karma
1 Solution

isoutamo
SplunkTrust
SplunkTrust

Hi

in which splunk, DBX, database engine, jdbc etc. version you have into use?

Usually the there should be ? as indicating the rising column and it's value.

SELECT CREATE_DATE,
  DELETE_DATE,
  SPLUNK_DEDUP_SQID,
  SPLUNK_IDX_ASC,
FROM "USER"."TABLE"
WHERE CREATE_DATE BETWEEN TO_DATE('20161101', 'RRRRMMDD') 
        AND TO_DATE('20180821', 'RRRRMMDD')
  AND SPLUNK_IDX_ASC > ?
ORDER BY SPLUNK_IDX_ASC ASC

And then you should set value for it on checkpoint field in your input definition.

r. Ismo

View solution in original post

0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

in which splunk, DBX, database engine, jdbc etc. version you have into use?

Usually the there should be ? as indicating the rising column and it's value.

SELECT CREATE_DATE,
  DELETE_DATE,
  SPLUNK_DEDUP_SQID,
  SPLUNK_IDX_ASC,
FROM "USER"."TABLE"
WHERE CREATE_DATE BETWEEN TO_DATE('20161101', 'RRRRMMDD') 
        AND TO_DATE('20180821', 'RRRRMMDD')
  AND SPLUNK_IDX_ASC > ?
ORDER BY SPLUNK_IDX_ASC ASC

And then you should set value for it on checkpoint field in your input definition.

r. Ismo

0 Karma
Get Updates on the Splunk Community!

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 3)

Welcome back to Splunk Classroom Chronicles, our ongoing blog series that pulls back the curtain on Splunk ...

Operationalizing TDIR: Building a More Resilient, Scalable SOC

Optimizing SOC workflows with a unified, risk-based approach to Threat Detection, Investigation, and Response ...

Almost Too Eventful Assurance: Part 1

Modern IT and Network teams still struggle with too many alerts and isolating issues before they are notified. ...