I have the exact same thing. My production box is fine. My dev/test box is not. I built a dev/test box, loaded splunk DB connect on it, same drivers, same JDK etc. The connector is good enough to log on to a MySQL DB, it can read schemas, it knows what tables are there, but it cannot select any records. On executing the run command from splunk -> splunk DB Connect -> Data Lab -> Sql Explorer etc. I get this error "com.splunk.dbx.exception.NotFoundException: Can not find object [MyConnection] of type connection."
I'm running splunk 6.6.3, dbConnect 3.1.1 in production, and Splunk 7.2.3, dbConnect 3.1.4 on my problem dev/test box. It's not perms on Mysql, they are both using the same mysql Driver and the same jre. A mystery so far.
... View more