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?
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
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
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
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.
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