All Apps and Add-ons

DBConnect parameter 1 error with rising input

nick405060
Motivator

3.1.3, gives me a java.sql.SQLException: Invalid parameter index 1. error, or a Parameter #1 has not been set error. Any clues? I'm literally just trying to do the most basic rising input possible for a SELECT * query and I had the same issue with another database last week, which all of a sudden started working.

0 Karma
1 Solution

nick405060
Motivator

The app interface claims to populate the SQL query template for you on the right-hand side, but it does so incorrectly: it only populates half of it. It populates the rising column in the query template but not the table name. Select the table, select batch type rising, select the rising column, copy and paste the SQL template into the SQL section but modify the table name.

It sounds like a silly problem that you should have caught, but it's not. The app claims to populate the SQL query template for you, but it only populates part of it. Ridiculously unexpected. For anyone having this problem, this is a Splunk QA team problem not a user problem.

View solution in original post

nick405060
Motivator

The app interface claims to populate the SQL query template for you on the right-hand side, but it does so incorrectly: it only populates half of it. It populates the rising column in the query template but not the table name. Select the table, select batch type rising, select the rising column, copy and paste the SQL template into the SQL section but modify the table name.

It sounds like a silly problem that you should have caught, but it's not. The app claims to populate the SQL query template for you, but it only populates part of it. Ridiculously unexpected. For anyone having this problem, this is a Splunk QA team problem not a user problem.

Get Updates on the Splunk Community!

New Release | Splunk Cloud Platform 10.1.2507

Hello Splunk Community!We are thrilled to announce the General Availability of Splunk Cloud Platform 10.1.2507 ...

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

🗣 You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...

Splunk New Course Releases for a Changing World

Every day, the world feels like it’s moving faster with new technological breakthroughs, AI innovation, and ...