Skip to main content

Verify the WSO2 DSS config is valid to connect Cassandra

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

<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>
view raw WSO2_config_12 hosted with ❤ by GitHub


You can try as follows
  1. download the WSO2 DSS and start the server
  2. copy the above configuration to a text file and save as .dbs file and copy to the <DSS_HOME>\repository\deployment\server\dataservices
  3. wait until it deploy
  4. 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

Popular posts from this blog

How to generate random unique number in SOAP UI request

eg 1: ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} eg 2: ${=java.util.UUID.randomUUID()} ${=java.util.UUID.randomUUID()} ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} - See more at: http://tryitnw.blogspot.com/2014/03/generating-random-unique-number-in-soap.html#sthash.m2S4tUFu.dpuf ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} - See more at: http://tryitnw.blogspot.com/2014/03/generating-random-unique-number-in-soap.html#sthash.m2S4tUFu.dpuf ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} - See more at: http://tryitnw.blogspot.com/2014/03/generating-random-unique-number-in-soap.html#sthash.m2S4tUFu.dpuf

Tips on using environment variables in WSO2 Integration Cloud

Environment variables allow you to change an application's internal configuration without changing its source code. Let’s say you want to deploy the same application in development, testing  and production environments. Then database related configs and some other internal configurations may change from one environment to another. If we can define these configurations as an environment variables we can easily set those without changing the source code of that application. When you deploy your application in WSO2 Integration Cloud, it lets you define environment variables via the UI. Whenever you change the values of environment variables, you just need to redeploy the application for the changes to take effect. Predefined environment variables Key Concepts - Environment Variables   provides you some predefined set of environment variables which will be useful when deploying applications in WSO2 Integration Cloud. Sample on how to use environment variables ...

Invoking REST API using BPMN

You can use BPMN Service Task and configure it as following to invoke a REST API Example with text input and text output: Example with JSON input and JSON output mapping and registry based URL: You can find implementation of org.wso2.carbon.bpmn.extensions.rest.RESTTask class here https://github.com/wso2/carbon-business-process/blob/master/components/bpmn/org.wso2.carbon.bpmn/src/main/java/org/wso2/carbon/bpmn/extensions/rest/RESTTask.java Currently it supports GET and POST only. If you need support for other HTTP methods you have to implement custom java service task similar to REST Task implementation that supports rest of REST API functionalities.