Apache Drill JDBC connection

[arjun_kr]

I'm trying to setup Drill JDBC connectivity using db connect. When I connect using SQL Explorer, I'm able to see Catalog, Schema and Tables listed. The queries fired as part of schema selection are found in Drill logs. When I run queries from SQL editor ,it fails with below exception.I couldn't find any relevant messages from splunk/drill logs. Any tips to solve this issue ?

Exception : java.sql.SQLException: [MapR]DrillJDBCDriver Error setting/closing connection: :31010

[arjun_kr]

I had to set '-Djava.security.auth.login.config=/opt/splunk/splunk/etc/apps/splunk_app_db_connect/login.conf' as jvm option in server setting for tables/schemas to get listed. Apparently,this jvm options is not getting in effect when queried from SQL editor. I was able to get it working by adding this option in '/opt/splunk/splunk/etc/apps/splunk_app_db_connect/linux_x86_64/bin/command.sh' as below.

export DRILL_OPTS="-Djava.security.auth.login.config=/opt/splunk/splunk/etc/apps/splunk_app_db_connect/login.conf"
exec $JAVA_CMD $DRILL_OPTS $@

If there is any cleaner to specify jvm options required for JDBC driver , that would be great.

[mhouse3]

See:
http://docs.splunk.com/Documentation/DBX/3.1.0/DeployDBX/Installdatabasedrivers

Be sure to create directory in $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers.

[arjun_kr]

I have added Drill jdbc drivers and connection is valid. As mentioned in question , it is able to retrieve schema/information in SQL explorer. But fails with queries on SQL editor.