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 Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...