-
Bug
-
Resolution: Done
-
Highest
-
Amsterdam Release
Trying to query database using sdnc-sql-resource adaptor to fetch data.
In SqlResource.java, DBLIB_SERVICE is defined as:
private static final String DBLIB_SERVICE = "org.onap.ccsdk.sli.adaptors.resource.dblib.DBResourceManager";
This is giving service reference as NULL.Then it is creating a new DBResourceManger instance by passing System.getProperties() in to constructor. The key-value pairs mentioned in dblib.properties file are not available as System parameters giving the below error trace:
2017-10-17 12:56:36,736 | ERROR | etwork-operation | DBResourceManager | 291 - org.onap.ccsdk.sli.core.dblib - 0.1.2.SNAPSHOT | Generated alarm: DBResourceManager.getData - No active DB connection pools are available. 2017-10-17 12:56:36,736 | ERROR | etwork-operation | SqlResource | 327 - org.onap.ccsdk.sli.adaptors.resource.sql - 0.1.0.SNAPSHOT | Caught SQL exception org.onap.ccsdk.sli.core.dblib.DBLibException: No active DB connection pools are available in RequestDataNoRecovery call. at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeDataNoRecovery(DBResourceManager.java:531) at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeData(DBResourceManager.java:507) at org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource.executeSqlWrite(SqlResource.java:214) at org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource.save(SqlResource.java:320)
And in dblib-blueprint.xml of dblib-service provider, the service is referenced by the interface name which lead the value to:
private static final String DBLIB_SERVICE = "org.onap.ccsdk.sli.core.dblib.DbLibService";