KB309112: A sample of Database Instance Configuration in order to connect to a JBoss Data Virtualization instance through JDBC driver in MicroStrategy Intelligence Server

SUMMARY
The following Technical Note contains an example of how to configure a Database Instance in order to connect to a JBoss Data Virtualization instance in Strategy Secure Enterprise 10.4.
 
For further information on how to connect to database using JDBC Drivers, please refer to:
        KB250923: Connecting to Databases using JDBC Drivers in Strategy 10.x
 
The environment used in the below example is configured using:

• Strategy Intelligence Server Universal 10.4 running on AIX 7.1
• JBoss Data Virtualization

 
Following the instructions described in KB250923, initially, the Database Instance had been configured with the following string:
 

JDBC;MSTR_JDBC_JAR_FOLDER=[path to Driver.jar folder];DRIVER=[file].jar;URL=jdbc:teiid:CNE@mms://IP/URL.

 
 
As noted above, the JDBC DRIVER field is making reference to the JDBC driver jar file. By using this configuration, the connection to the Strategy DB Query Tool works and tables can be selected normally with no error. However, the error below occurs when connecting through Strategy Intelligence Server:
 
DSSErrors:
 

datetime [HOST:xxxxxxxx][SERVER:][PID:xxxxxx][THR:xxxx][JdbcWrapper][Error] JdbcUnknowException occur. 
Error Message: teiid-8.7.1.6_2-redhat-6-jdbc.jar, Java Trace: java.lang.ClassNotFoundException: teiid-8.7.1.6_2-redhat-6-jdbc.jar 
at java.lang.Class.forNameImpl(Native Method) 
at java.lang.Class.forName(Class.java:273) 
at com.Strategy.database.Jdbc.JdbcConnection.connect(Unknown Source) 
, Connection String: JDBC;MSTR_JDBC_JAR_FOLDER=xxxxxxx;DRIVER=teiid-8.7.1.6_2-redhat-6-jdbc.jar;URL=jdbc:teiid:CNE@mms://xxxxxxx:31000;UID=xxxxxx;, Statement String: 
datetime [HOST:xxxxxxxx][SERVER:CastorServer][PID:xxxxxx][THR:xxxx][Database Classes][Error] JdbcConnectionWrapper::Connect failed. Disconnected. 
Error type: Unknown exception. Jdbc operation attempted: Connect. Error Message:teiid-8.7.1.6_2-redhat-6-jdbc.jar. Connection String: JDBC;MSTR_JDBC_JAR_FOLDER=xxxxxxxx;DRIVER=teiid-8.7.1.6_2-redhat-6-jdbc.jar;URL=jdbc:teiid:CNE@mms://xxxxxxxx:31000;UID=xxxxxxxx;. 
datetime [HOST:xxxxxxxx][SERVER:CastorServer][PID:xxxxxxxx][THR:xxxxxxxx][Database Classes][Error] Failed to connect to data source. Error message: JdbcConnectionWrapper::Connect failed. Disconnected. 
Error type: Unknown exception. Jdbc operation attempted: Connect. Error Message:teiid-8.7.1.6_2-redhat-6-jdbc.jar. Connection String: JDBC;MSTR_JDBC_JAR_FOLDER=xxxxxxxx;DRIVER=teiid-8.7.1.6_2-redhat-6-jdbc.jar;URL=jdbc:teiid:CNE@mms://xxxxxxxx:31000;UID=xxxxxxxx;.

 
 
 
This is a generic error message, but essentially means it could find an entry point for the teiid driver. The reason for this is because the DRIVER parameter is either not specified or specified incorrectly and the jar file's manifest does not contain a reference for it's main class path.
 
In this case, for the teiid driver, modifying the DRIVER parameter to the main entry point of the teiid driver as seen below allows the connection to work as expected.
 

JDBC;MSTR_JDBC_JAR_FOLDER=[path];DRIVER=org.teiid.jdbc.TeiidDriver;URL=jdbc:teiid:CNE@mms://IP/URL