Solution:
You can try querying column families from system.schema_columnfamilies to check whether DSS configuration is valid and integration happens correctly.
Here's the DSS configuration
You can try querying column families from system.schema_columnfamilies to check whether DSS configuration is valid and integration happens correctly.
Here's the DSS configuration
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<data name="UTDS" transports="http https local"> | |
<config id="UTDataSource"> | |
<property name="cassandraServers">data.wso2.com</property> | |
<property name="port">9042</property> | |
<property name="username">cassandra</property> | |
<property name="password">cassandra</property> | |
</config> | |
<query id="getColumnfamilies" useConfig="UTDataSource"> | |
<expression>select columnfamily_name from system.schema_columnfamilies;</expression> | |
<result element="columnfamily_names" rowName="columnfamily_name"> | |
<element column="columnfamily_name" name="columnfamily_name" xsdType="string"/> | |
</result> | |
</query> | |
<operation name="getColumnfamilies"> | |
<call-query href="getColumnfamilies"/> | |
</operation> | |
</data> |
You can try as follows
- download the WSO2 DSS and start the server
- copy the above configuration to a text file and save as .dbs file and copy to the <DSS_HOME>\repository\deployment\server\dataservices
- wait until it deploy
- get the WSDL from management console and add it to the SOAP UI and invoke the getColumnfamilies operation – it will list all the column families from your database.
Comments