Archive

Why does DB Connect App with ODBC Input not work?

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

Splunk Employee
Splunk Employee

Hi,

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

0 Karma

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