How to configure Hawk DB adapter on Windows system after installation?
Article ID: KB0092690
Updated On:
| Products | Versions |
|---|---|
| TIBCO Hawk Database Adapter | - |
| Not Applicable | - |
Description
Resolution:
Let's use sql server make a sample. For other db, it’s similar.:
1. Install the db adapter, no need to select the jdbc driver during this time.
2. After installation, go to <hawk>/adapters/dbhma/sqlserver/samples. Edit sqlserverDBHma.bat and sqlserverDBHma.xml file.
3. At the sqlserverDBHma.bat file, you can uncomment the following two lines:
set TIBCO_TPCL_JDBC=c:\tibco\tpcl\5.3\jdbc
set JDBC_CLASSPATH=%TIBCO_TPCL_JDBC%\TIbase.jar;%TIBCO_TPCL_JDBC%\TIutil.jar;%TIBCO_TPCL_JDBC%\TIsqlserver.jar
change the tpcl folder to your actually folder on this machine.
Comment the JDBC_CLASSPATH=c:\msSQLjdbc\lib\msbase.jar;c:\msSQLjdbc\lib\mssqlserver.jar;c:\msSQLjdbc\lib\msutil.jar
This way, TIBCO bundled JDBC driver for sql server will be used.
If you don’t want to use TIBCO bundled JDBC driver, use vendor provided instead, please keeps this JDBC_CLASSPATH parameter and point to the correct url.
4. At the sqlserverDBHma.xml, specify the correct parameters for ami_rvd, JDBCDriver, dbURL, DbUser and dbPassword.
5. After this, please run the sqlserverDBHma.bat file to install the service of DB hma for sql server. If you encounter the problem which says this service is already exist, please run the <hawk>/bin/tibhawkdbhma.exe --remove -name sqlserverDBHma to remove this service.
6. After this, check if the service can be started or not. If you encounter problem, please check the log under the <hawk>/adapters/dbhma/log/ for detail info.
Let's use sql server make a sample. For other db, it’s similar.:
1. Install the db adapter, no need to select the jdbc driver during this time.
2. After installation, go to <hawk>/adapters/dbhma/sqlserver/samples. Edit sqlserverDBHma.bat and sqlserverDBHma.xml file.
3. At the sqlserverDBHma.bat file, you can uncomment the following two lines:
set TIBCO_TPCL_JDBC=c:\tibco\tpcl\5.3\jdbc
set JDBC_CLASSPATH=%TIBCO_TPCL_JDBC%\TIbase.jar;%TIBCO_TPCL_JDBC%\TIutil.jar;%TIBCO_TPCL_JDBC%\TIsqlserver.jar
change the tpcl folder to your actually folder on this machine.
Comment the JDBC_CLASSPATH=c:\msSQLjdbc\lib\msbase.jar;c:\msSQLjdbc\lib\mssqlserver.jar;c:\msSQLjdbc\lib\msutil.jar
This way, TIBCO bundled JDBC driver for sql server will be used.
If you don’t want to use TIBCO bundled JDBC driver, use vendor provided instead, please keeps this JDBC_CLASSPATH parameter and point to the correct url.
4. At the sqlserverDBHma.xml, specify the correct parameters for ami_rvd, JDBCDriver, dbURL, DbUser and dbPassword.
5. After this, please run the sqlserverDBHma.bat file to install the service of DB hma for sql server. If you encounter the problem which says this service is already exist, please run the <hawk>/bin/tibhawkdbhma.exe --remove -name sqlserverDBHma to remove this service.
6. After this, check if the service can be started or not. If you encounter problem, please check the log under the <hawk>/adapters/dbhma/log/ for detail info.
Issue/Introduction
How to configure Hawk DB adapter on Windows system after installation?
Feedback
Yes
No
Powered by
