Deployment Architecture

Why does DB Connect App with ODBC Input not work?

PPape
Contributor

Hi,

I'm trying to use the DB Connect App with ODBC.
The Query over the DB Connect App works just fine but when I try to index the Data with an dbmon-dump i get this error

2015-04-07 13:33:15.881 dbx4640:INFO:DumpDatabaseMonitor - Executing database monitor=[dbmon-dump://AS400/AS400Dump]
2015-04-07 13:33:15.881 dbx4640:WARN:Database - Database type=com.splunk.dbx.sql.type.impl.ODBC@4a452244 does not support connection validation
2015-04-07 13:33:15.881 dbx4640:ERROR:DumpDatabaseMonitor - Error while executing database monitor: java.sql.SQLException: Invalid Fetch Size
java.sql.SQLException: Invalid Fetch Size
    at sun.jdbc.odbc.JdbcOdbcStatement.setFetchSize(Unknown Source)
    at com.splunk.dbx.sql.type.impl.AbstractDatabaseType.setStreamingResults(AbstractDatabaseType.java:355)
    at com.splunk.dbx.sql.Database.configureStatement(Database.java:222)
    at com.splunk.dbx.sql.Database.query(Database.java:247)
    at com.splunk.dbx.monitor.impl.DumpDatabaseMonitor.performMonitoring(DumpDatabaseMonitor.java:45)
    at com.splunk.dbx.monitor.DatabaseMonitorExecutor.executeMonitor(DatabaseMonitorExecutor.java:126)
    at com.splunk.dbx.monitor.DatabaseMonitorExecutor.call(DatabaseMonitorExecutor.java:102)
    at com.splunk.dbx.monitor.DatabaseMonitorExecutor.call(DatabaseMonitorExecutor.java:37)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
2015-04-07 13:33:15.881 dbx4640:INFO:DumpDatabaseMonitor - Database monitor=[dbmon-dump://AS400/AS400Dump] finished with status=false resultCount=0 in duration=0 ms
2015-04-07 13:33:15.881 dbx4640:INFO:ExecutionContext - Execution finished in duration=0 ms

What can i do? Or What am I doing wrong?

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

Hi,

I'm sorry, but we only support JDBC drivers in DB Connect.

0 Karma

PPape
Contributor

Maybe i expressed my self wrong.
I'm using the Database Input for ODBC of the DB Connect App.
Its an Option from the DB Connect App.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas     Cisco Live 2026 is almost here, and this ...

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Hello Splunkers,   So you searched, “what is the name of the usb key inserted by bob smith?”  Not gonna lie… ...

Automating Threat Operations and Threat Hunting with Recorded Future

    Automating Threat Operations and Threat Hunting with Recorded Future June 29, 2026 | Register   Is your ...