All Apps and Add-ons

Splunk DB Connect 1: Why am I getting error "Execute method cannot be used for update" trying to run dbquery via CLI?

govarthini
Engager

I have installed Splunk Enterprise edition V 6.2.4 in Rhel machine. With the help of the Splunk DB Connect app, I am able to retrieve the database tables and view the data, but while trying to execute the same DBquery in CLI (command line interface), I am facing an issue. The query which I have given there in CLI is

[root@openstack bin]# ./splunk search "| dbquery DB2400 select * from govarthini.telecom"

The Error that I am facing is:

DB2 error code :SQL code -104 and SQL state 42601. Execute method cannot be used for update.

Help us to solve the issue.
Thank You.

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

Google says to update JDBC driver. http://lmgtfy.com/?q=DB2+Execute+method+cannot+be+used+for+update

What JDBC driver are you using? http://docs.splunk.com/Documentation/DBX/1.2.1/DeployDBX/Installdrivers for the supported ones.

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...