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?
Hi,
I'm sorry, but we only support JDBC drivers in DB Connect.
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.