topic Re: Help creating new database type and mapping JDBC driver in Reporting

Help creating new database type and mapping JDBC driver

Dan — Fri, 07 Dec 2012 18:36:35 GMT

From Andrescolo:

Im trying to use JDBC to connect an AS400 database.
I put the driver JT400.jar in $SPLUNK_HOME/etc/apps/dbx/bin/lib, restart splunk.
When i setup the database, i cant see a new Database type related to the jar file added, and i dont see any other place to configure.

How is posible to map database type with driver?

Re: Help creating new database type and mapping JDBC driver

Dan — Fri, 07 Dec 2012 18:37:05 GMT

From Stepmmx:

I have the same problem.
I tried to define AS400 DB2 DB in database_types.conf
[as400]
displayName = DB2 AS400
jdbcDriverClass = com.ibm.as400.access.AS400JDBCDriver
defaultPort = 446
connectionUrlFormat = jdbc:as400://{0}:{1};naming=sql;errors=full

but the connectionUrlFormat is propably wrong 😞

In DBVisualizer I'm using this format:
jdbc:as400://HOSTNAME;naming=sql;errors=full

Re: Help creating new database type and mapping JDBC driver

ziegfried — Fri, 07 Dec 2012 18:45:17 GMT

To match your JDBC URL jdbc:as400://HOSTNAME;naming=sql;errors=full, you could probably use:

connectionUrlFormat = jdbc:as400://{0};naming=sql;errors=full

in database_types.conf.

Re: Help creating new database type and mapping JDBC driver

piebob — Fri, 07 Dec 2012 22:13:12 GMT

i've updated the documentation to include a topic on how to do this in more detail:

http://docs.splunk.com/Documentation/DBX/1.0.6/DeployDBX/DefineanewDB

Re: Help creating new database type and mapping JDBC driver

mwwb — Wed, 31 Jul 2013 18:03:39 GMT

try the jdbc tutorial at this website http://www.unityjdbc.com/doc/jdbc/jdbc_tutorial.php

it is really easy to understand, great explanations, tons of links for more information, and has sample code.

Hope this helps