Hi All,
I managed to make create one more additional oracle driver which is visible in splunk db connect settings.
1. oracle
2. oracle service
3. oracle ojdbc6 version
I did so by creating 3 subfolders inside drivers directory and restarting splunk instance and added a stanza in db_connections_type.conf file inside local directory. But the problem I'm facing now is, if i place ojdbc7.jar in any one of these subfolders under drivers directory, supported versions of remaining 2 drivers which are still pointing to ojdbc6.jar are getting updated. Is there a way to prevent it?
Ideally with ojdc7.jar, im expecting to see 12.1 as supported and ojdbc6.jar im expecting 11.1. Is there a way to ensure drivers are looking only into the jar files present in the subfolder associated to it rather than highest version across any of oracle related.?
Below is the chunk of of db_connections_types.conf file.
[oracle_ojdbc6]
displayName = Oracle OJDBC 6
serviceClass = com.splunk.dbx2.OracleJDBC
jdbcUrlFormat = jdbc:oracle:thin:@::
jdbcUrlSSLFormat = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))
jdbcDriverClass = oracle.jdbc.OracleDriver
supportedVersions = 11.2
database = XE
port = 1521
connection_properties = {"oracle.net.authentication_services":"(TCPS)","oracle.net.ssl_cipher_suites":"(SSL_DH_anon_WITH_3DES_EDE_CBC_SHA, TLS_RSA_WITH_AES_128_CBC_SHA)"}
[oracle]
displayName = Oracle
serviceClass = com.splunk.dbx2.OracleJDBC
jdbcUrlFormat = jdbc:oracle:thin:@::
jdbcUrlSSLFormat = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))
jdbcDriverClass = oracle.jdbc.OracleDriver
supportedVersions = 12.0
database = XE
port = 1521
connection_properties = {"oracle.net.authentication_services":"(TCPS)","oracle.net.ssl_cipher_suites":"(SSL_DH_anon_WITH_3DES_EDE_CBC_SHA, TLS_RSA_WITH_AES_128_CBC_SHA)"}
[oracle_service]
displayName = Oracle Service
serviceClass = com.splunk.dbx2.OracleJDBC
jdbcUrlFormat = jdbc:oracle:thin:@//:/
jdbcUrlSSLFormat = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))
jdbcDriverClass = oracle.jdbc.OracleDriver
supportedVersions = 12.0
database = XE
port = 1521
connection_properties = {"oracle.net.authentication_services":"(TCPS)","oracle.net.ssl_cipher_suites":"(SSL_DH_anon_WITH_3DES_EDE_CBC_SHA, TLS_RSA_WITH_AES_128_CBC_SHA)"}
Below is how I have placed jar files
C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\drivers\oracle\ojdbc7.jar
C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\drivers\oracle_ojdbc6\ojdbc6.jar
C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\drivers\oracle_service\ojdbc6.jar
No other jar files under C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\drivers.
Regards,
Chris.
... View more