Troubleshooting
Problem
You see error message WSVR0017E. This message indicates a configuration error as the relationalResourceAdapter tag of a configured resource is missing or is null. The exception that is logged is this: com.ibm.ws.runtime.component.binder.ResourceBindingException: invalid configuration passed to resource binding logic. REASON: Invalid Configuration! The DataSource: wmmdbDS has a null RelationalResourceAdapter property.
Cause
This error can be caused by a wsadmin command that does not contain the tag relationalResourceAdapter, but is used to create the data source. So, if a wsadmin command has a relationalResourceAdapter tag set to a value that is null, the resulting entry in the resources.xml for the data source will have either no relationalResourceAdapter tag or an empty tag.
The relationalResourceAdapter is a required parameter for an IBM® WebSphere® Application Server DataSource Connection Factory:
<factories xmi:type="resources.jdbc:DataSource" xmi:id="DataSource_1175200479637" name="Cloudscape JDBC Driver XA DataSource" jndiName="jdbc/Cloudscape JDBC Driver XA DataSource" description="New JDBC Datasource" providerType="Cloudscape JDBC Provider (XA)" authMechanismPreference="BASIC_PASSWORD" authDataAlias="pmckennat42pNode03/testAlias" relationalResourceAdapter="" statementCacheSize="10" datasourceHelperClassname="com.ibm.websphere.rsadapter.CloudscapeDataStoreHelper">
Resolving The Problem
There are 3 options to resolve the issue:
1. Manually add the relationalResourceAdapter value to the datasource in the resources.xml file.
2. Delete the current datasource with the wsadmin command 'deleteDatasource'. More information on this command can be found at the following link:
JDBCProviderManagement command group for AdminTask object
Then, create a new datasource using the wsadmin command 'createDataSource' and include the attribute 'relationalResourceAdapter'. More information on this command can be found at the following link:
JDBC configuration scripts
3. Delete the current datasource through the admin console and create a new one in the admin console to pick up the default property to be set for the relational Resource Adapter.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21317655