Collector Studio DB2 JDBC driver issue
I am running into an issue with collector studio when attempting to access a DB2 database via jdbc. I connected to this database using jdbc via SQL Squirrel and following the instructions on this site. http://ashraffouad.blogspot.com/2012/02/configure-squirrel-sql-to-connect-to.html
The problem I am running into is that it appears I need both jars (db2jcc.jar and db2jcc_license_cu.jar) for the jdbc connection to function properly. I tried removing db2jcc_license_cu.jar from the SQL squirrel driver I created and it does not work in that case. Is it possible to include both jars in the Sensor Property List?
When I attempt to just put in these values for the sensor I get an error when testing the sensor:
JDBC Drivers Directory | C:\Program Files\IBM\SQLLIB\java
DatabaseDriver | db2jcc.jar
JdbcDriverFiles | com.ibm.db2.jcc.DB2Driver
com.symantec.cas.ucf.sensors.InitSensorException: Cannot find JDBC driver class "db2jcc.jar". It is possible an incorrect "JDBC Drivers Directory" was specified. at com.symantec.cas.ucf.sensors.DB.DBSensor.init(DBSensor.java:1852) at
Odd error because I can see db2jcc.jar in that directory.