Amalka Subasinghe's Blog

This is about how to configure WSO2 DSS to support Cassandra user defined data types Cassandra user defined data type and table: WSO2 DSS configurations: Request we should send as:

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 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.

Here are the steps to setup DSS and Cassandra integration Setup 1: download and install Cassandra WSO2 DSS 3.5.0 is based on WSO2 Carbon 4.4.2 and Cassandra version 2.0 is recommended WSO2 DSS 3.2.2 is based on WSO2 Carbon 4.2.0 and Cassandra version 2.0 is recommended Step 2: download and install WSO2DSS http://wso2.com/products/data-services-server/ https://docs.wso2.com/display/DSS322/WSO2+Data+Services+Server+Documentation Step 3: configure following operations in DSS Create Key space - UserKS CREATE KEYSPACE UserKS WITH replication = {'class':'SimpleStrategy', 'replication_factor': 1} Create column family - User (id, name, country) CREATE TABLE UserKS.User (id text, name text, country text, PRIMARY KEY (id)) addUser INSERT INTO UserKS.User (id, name, country) values (?,?,?) getUsers SELECT * FROM UserKS.User updateUser UPDATE UserKS.User SET country = ? WHERE id =? deleteUser DELETE FROM UserKS.User WHERE id = ? You can try the abov...