Correct path to add JDBC driver JAR files in TIBCO ActiveMatrix Adapter Framework to start adapteragent using DBEMS
Article ID: KB0079609
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix Adapter Framework | 1.3.x, |
Description
As per the documentation, while doing a DBEMS connection need to add JDBC driver connector JAR files at location "{TIBCOHOME}/afx/version/system/lib".
After adding "ojdbc6.jar" at a given location the adapteragent still throws the error, "TIBCO-AFX-AGENT-500009: Failed to start agent due to an error in initializing data store, reason: Error getting DB connection, not able to find jdbc driver in class pathoracle.jdbc.OracleDriver".
After adding "ojdbc6.jar" at a given location the adapteragent still throws the error, "TIBCO-AFX-AGENT-500009: Failed to start agent due to an error in initializing data store, reason: Error getting DB connection, not able to find jdbc driver in class pathoracle.jdbc.OracleDriver".
Issue/Introduction
Add the JDBC driver connector JAR files at location "\afx\\system\lib\db" and then start the adapteragent.
Environment
========================================
Product: TIBCO ActiveMatrix Adapter Framework
Version: 1.3.x
OS: All Supported Operating Systems
========================================
Resolution
Add the JDBC driver connector JAR file "ojdbc6.jar" at location "<TIBCO_HOME>\afx\<version>\system\lib\db" and then start the adapteragent.
The TIBCO ActiveMatrix Adapter Framework 1.3.x also supports DBEMS connection with MSSQL Server.
To do the DBEMS connection using MSSQL Server , must add JAR file " sqljdbc4-3.0.jar"at location "{TIBCOHOME}/afx/version/system/lib/as/lib" or location "<TIBCO_HOME>\afx\<version>\system\lib\db" and then start the adapteragent.
The TIBCO ActiveMatrix Adapter Framework 1.3.x also supports DBEMS connection with MSSQL Server.
To do the DBEMS connection using MSSQL Server , must add JAR file " sqljdbc4-3.0.jar"at location "{TIBCOHOME}/afx/version/system/lib/as/lib" or location "<TIBCO_HOME>\afx\<version>\system\lib\db" and then start the adapteragent.
Feedback
Yes
No
Powered by
