Chamara Silva's Blog

How to view check-sum values in JAR file

2011-09-02T01:46:00.000-07:00

I had couple of jar files and i need to check bot files are same or not. Hence those are signed jars i checked check sum values both of that jars. Following are the commands i have used.

1. Open terminal and traversed to the jar file location.
Ex : cd /wso2/project/support

2. Do checksum as follows.
Ex : md5sum axis2-1.6.1.wso2v1.jar

3. You will see this output
"18da73bd555fc231ad0ee7c93291549d axiom-1.2.11.wso2v1.jar"

How to create user in oracle database

2011-08-29T23:57:00.000-07:00

Following are the commands to create new user in Oracle database.

1. You have to log in to the oracle command window. In command prompt enter below command.
Syntax : sqlplus sys/DB_password@Database as sysdba;
Ex : sqlplus sys/password@orcl as sysdba;

2. Create user New_User_Name identified by password account unlock;

3. grant connect to New_User_Name;

4. grant create session, dba to New_User_Name;

5. commit;

How to restore oracle dmp file to the database.

2011-08-18T00:15:00.000-07:00

Here are the easiest steps to restore oracle dmp file to your database.

1. First you need to login to the sql command line terminal. Open command prompt if you are using windows and if you are using Linux environment open terminal.

2. Then you have to login to the SQL-PLUS as a system administrator. To do that use following command.

"sqlplus sys/admin@ORADB as sysdba"

Eg: D:\Documents and Settings\Administrator>sqlplus sys/admin@ORADB as sysdba

3. Then you have to create a new database user.

3.1 "create user username identified by password account unlock;"

Eg : create user chamara identified by chamara account unlock;

3.2 "grant connect to username;"

Eg : grant connect to chamara;

3.3 "grant create session, dba to chamara;"

Eg : grant create session, dba to chamara;

4. Now you have to exit from the SQL-PLUS and use "exit" command for that.

5. Finally restore your dmp file using this command.

"imp SYSTEM/test@ORADB fromuser=dbadmin touser=username IGNORE=Y FILE=file_path.dmp"

Eg : D:\Documents and Settings\Administrator>imp SYSTEM/test@ORADB fromuser=WSO2_RSCE touser=chamara IGNORE=Y FILE=D:\chamara\sample.dmp

Sample java code for start axis2 simple http server with service

2011-04-27T02:01:00.000-07:00

Some times you may want to use sample web service to communicate with your client written by java.This example will show you how to start/stop apache simple HTTP server programatically and upload axis2 service to the simple axis2 service programatically.

import org.apache.axis2.AxisFault;
import org.apache.axis2.context.ConfigurationContext;
import org.apache.axis2.context.ConfigurationContextFactory;
import org.apache.axis2.deployment.DeploymentEngine;
import org.apache.axis2.description.AxisServiceGroup;
import org.apache.axis2.engine.AxisConfiguration;
import org.apache.axis2.transport.http.SimpleHTTPServer;

import java.io.File;

public class HTTPServerManager {
private static SimpleHTTPServer server;
protected int serverPort = 9000;

public synchronized void startHTTPServer() {
ConfigurationContext context;
try {
context = ConfigurationContextFactory.
createConfigurationContextFromFileSystem(location of axis2.xml, null);
server = new SimpleHTTPServer(context, serverPort);
String resourcePath = HTTPServerManager.class.getResource("location of axis2service.aar").getPath();
AxisServiceGroup serviceGroup = DeploymentEngine.loadServiceGroup(new File(resourcePath), context);
AxisConfiguration xConfig = context.getAxisConfiguration();
xConfig.addServiceGroup(serviceGroup);
server.start();

} catch (AxisFault axisFault) {
axisFault.printStackTrace();
}
}

/**
* Method used to stop SimpleHTTPServer
*/
public synchronized void stopHTTPServer() {
server.stop();
}

public static void main {
startHTTPServer();
stopHTTPServer()
}
}

How to write Java code to listen runtime changes in text file

2011-04-25T02:16:00.000-07:00

I had a requirement to write a java code to listen continues changing text file.i have used following code to do that.

public void listenServer() throws IOException {
Reader fileReader = new FileReader("/home/chamara/server.log");
BufferedReader input = new BufferedReader(fileReader);
String line = null;
while (true) {
if ((line = input.readLine()) != null) {
System.out.println(line);
continue;
}
try {
Thread.sleep(1000L);
} catch (InterruptedException x) {
Thread.currentThread().interrupt();
break;
}
}
input.close();
return isException;
}

2011-04-07T02:31:00.000-07:00

How to run maven build without test

This is simple one line command.go to the build directory from command prompt and type following command.

mvn clean install -Dmaven.test.skip=true

How To start WSO2 AMI instances from command line

2009-12-09T03:35:00.000-08:00

Introduction

WSO2 now their all SOA products exposed in to the cloud computing technology.As a reducing cost and improving flexibility as well as a stability WSO2 SOA products now available as a private and public cloud deployments.Currently WSO2 cloud products support "Amazon EC2" as a public cloud platform and VMware,Linux KVM as a private cloud platform.In this tutorial i am going to explain how you setup and operate WSO2 EC2 cloud products within a few minutes.These are the steps need to be taken for operate WSO2 AMI instances from your command line.

Setup JDK

As a prerequisites you have to setup JDK in your machine.

Step 1 : Download JDK .

Step 2: Install JDK and set JAVA_HOME environment variable.

If you are in Linux open a terminal or .bashrc and insert JAVA_HOME,

Syntax -

  export JAVA_HOME=JDK file path

Example -

   export JAVA_HOME=/usr/lib/jvm/java-6-sun-1.6.0.15

If you are in Windows set JAVA_HOME as a enviroment variable.

Syntax -

   set JAVA_HOME=JDK file path

Example -

   set JAVA_HOME=c:\\chamara\JDK1.6

Step 3: Open a terminal/command prompt and type "java -version". if you are configured JAVA_HOME correctly you will see the output like this.

Getting Private Key Files from Amazon

Step 4: Now you need amazon EC2 account for operate amazon instances.to create your own amazon account and follow the steps given there to create account.

Step 5: Once you create amazon account you will get couple of PEM-endosed x509 certificate and private key files as

cert-HKZYKTAIG2ECMXYIBH3HXV4ZBZQ55CLO.pem (A PEM encoded signed X.509 certificate)

pk-HKZYKTAIG2ECMXYIBH3HXV4ZBZQ55CLO.pem (An unencrypted, PEM encoded RSA private key that corresponds to the X.509 certificate above)

Step 6: Now download that .pem files.

Setup Amazon API Tools

Amazon API Tools package serves as the client interface of the amazon EC2 web services.to control our web servics we are using this interface.Following steps need to be follow for setup Amazon API Tools package.

Step 7: download Amazon-API tools package.

Step 8: Create a folder called "ami" in your machine,copy that "ec2-api-tools.zip" and extract it.

Step 9: Set "EC2_HOME"environment variable by locating ec2-api-tools folder.

If you are in Linux open a terminal or .bashrc and insert EC2_HOME,

Syntax -

   export EC2_HOME=directorypath/ami/ec2-api-tools

Example -

   export EC2_HOME=/home/chamara/ami/ec2-api-tools>

If you are in Windows set EC2_HOME as a enviroment variable.

Syntax -

   set EC2_HOME=folderpath/ami/ec2-api-tools

Example -

   set EC2_HOME=c://chamara/ami/ec2-api-tools

Step 10: now add ec2-api-tools/bin folder path to your path variable.(See screenshot above)

Step 11: Then create folder called ".ec2" and copy cert and PK .pem files in to that.(earlier we downloaded that)

Step 12: Now you have to create couple of invirenment variables by locating .pem files.

If you are in Linux open a terminal or .bashrc and insert EC2_PRIVATE_KEY & EC2_CERT,

Syntax -

   export EC2_PRIVATE_KEY=folderpath/.ec2/pk-********.pem
export EC2_CERT=folderpath/.ec2/cert-*******.pem

Example -

   export EC2_PRIVATE_KEY=/home/chamara/.ec2/pk-********.pem 
export EC2_CERT=/home/chamara/.ec2/cert-*******.pem

If you are in Windows set EC2_PRIVATE_KEY & EC2_CERT as a enviroment variables.

Syntax -

   set EC2_PRIVATE_KEY=folderpath/.ec2/pk-********.pem
set EC2_CERT=folderpath/.ec2/cert-*******.pem

Example -

   set EC2_PRIVATE_KEY=c//chamara/.ec2/pk-********.pem
set EC2_CERT=c://chamara/.ec2/cert-*******.pem

Step 13: Now you have completed 95% of the confugarions.to check this open terminal or command prompt traverce to .ec2 folder and type "ec2-describe-images".you will see all the available AMI images in your terminal if you are configured successfuly.

Creating Keypair

Step 14: Now you have to create or own key pair.to create that key pair in command prompt/terminal goto the .ec2 folder and type "ec2-add-keypair yourname-keypair"

Example

   chamara@chamara-laptop:~$ ec2-add-keypair chamara-keypair

now you can see your private key in your terminal.

Step 15: Then create a file called "id_rsa-yourname-keypair" in ec2 directory.(yourname what you put here should be same with the key pare name what you add in 11.)

Step 16: Copy private key list in your terminal (point 11) from " -----BEGIN RSA PRIVATE KEY-----" to "-----END RSA PRIVATE KEY-----" in to the "id_rsa-yourname-keypair" file.

Step 17: If you are in linux give permission to that file.

in terminal, type

   chmod 600 id_rsa-yourname-keypair

Step 18: now you finish all the configuration and you should be able to run any ami instances from command line.

Start AMI Instance

Step 19: If you want to run 32 bit ami instance,

in terminal, go to the .ec2 folder and type

   ec2-run-instance ami-ID -k yourname-keypair

Step 20: If you want to run 64 bit instance you need to type,

 ec2-run-instances ami-ID -k yourname-keypair --instance-type m1.large

Step 21: If you want to see status of the running instance you need to type this command in terminal.

"ec2-describe-instance instance-id" (instance id you can see when you are start instance using ami-id.instance id start with i-1212 etc.)

for a example if you want to run 32 bit WSAS instance you have to get AMI-ID from the wso2.com Page

WSAS ID = ami-80bd5fe9

start WSAS instance like,

 ec2-run-instance ami-80bd5fe9 -k chamara-keypair

Step 22: After few second type "ec2-describe-instance instance-id" in terminal. you will see ec2 domain name like "ec2-174-129-171-196.compute-1.amazonaws.com".this is the unique url for your running instance.

Step 23: In browser type "https://ec2-174-129-171-196.compute-1.amazonaws.com/carbon" url and you will see WSAS management console finally.

How to activate clustering in WSO2 WSAS

2009-09-30T04:30:00.001-07:00

Web services application clustering is an major requirement in production environment.WSO2 carbon based products comes with the clustering functionality.To enable clustering in WSAS and other carbon based products is much easier that other open source applications.

To work WSAS with the clustering functionality you have to run more wsas instances in the same time.

Following are the steps to enable clustering in WSAS.(to enable clustering to all other wso2 carbon based products follow same steps.)

1. Download WSO2 WSAS.

2. Extract binary package.

3. Open axis2.xml in “WSAS_HOME/conf “ folder.

4. Change “clustering class” enable = true

Ex:

<clusteringclass="org.apache.axis2.clustering.tribes.TribesClusteringAgent" enable="true">

5. then you have use same cluster for all the wsas instances.That cluster domain name is mention in cluster domain parameter in axis2.xml.message multicasting based on that cluster domain.

Ex: <parameter name="domain">wso2.carbon.domain</parameter>

This is the basic of the wso2 WSAS clustering functionality. you can find more information here.

How to Enable Mail Notification in WSO2 Governance Registry

2009-09-29T05:03:00.001-07:00

WSO2 Governance Registry supports a variety of notification methods.It notify most of the activities you do inside the governance registry.those are,

Email - Any valid email address.
HTML/Plain-Text - An endpoint accepting HTML or text content.
SOAP - An endpoint accepting notifications as a SOAP message.
User Profile - A valid user's profile. Notifications will be sent to the email address specified on the user's default profile.

Here is the steps you need to follow enable email notifications in WSO2 Governance Registry.

1. Download WSO2 Governance Registry.

2. Extract Binary package.

3. Open “axis2_client.xml” file inside the “WSO2Registry/conf” folder.

4. Add Following Configuration and change Mail setting what you are using.

<transportSender name="mailto"      class="org.apache.axis2.transport.mail.MailTransportSender">
        <parameter name="mail.smtp.host">smtp.gmail.com</parameter>
        <parameter name="mail.smtp.port">587</parameter>
        <parameter name="mail.smtp.starttls.enable">true</parameter>
        <parameter name="mail.smtp.auth">true</parameter>
        <parameter name="mail.smtp.user">chamarasilva</parameter>
        <parameter name="mail.smtp.password">mailpassword</parameter>
        <parameter name="mail.smtp.from">chamarasilva@gmail.com</parameter>
    </transportSender>

you need to change following tags in above configuration,

1. mail.smtp.user = Username of the mail account

2. mail.smtp.password = Password of the mail account

3. mail.smtp.from = Email address of the mail account

5. Now start WSO2 Governance Registry server and set mail notification in each activity.

What would be the key factors of finding bugs....

2009-03-04T03:24:00.000-08:00

In my knowledge there should be a specific ways to finding software bugs too easy.i think following are the key factors for make easy to finding a bugs.

1: Check for inconsistency within the product
2: Check for the Inconsistency on the purpose of the product
3: Check for inconsistency with the product versions
4: Check for inconsistency with the image a company is trying to portray
5: Check for inconsistency with a comparable product
6: Check for inconsistency with claims that are made about the product
7: Check for Inconsistency with user expectations on the product
8: Check for the Inconsistency in regards to legal requirements.
9:Talk to developers on how they have coded a piece of function(s). This may sometimes reveal scenarios
that they may have been missed out and hence chances of finding bugs becomes higher for those
scenarios.
10: Give rest to your brain and eyes. Tired eyes may miss, an easy to see bugs.

What do you think ? is this correct or not?............

Best Automation tool to web application testing

2009-02-19T01:59:00.000-08:00

In software quality assurance there is an many tools to automate your tests.for a example Test Complete,Selenium,mercury Win runner are most famous test automation tools in the world.
If you want to automate your test with web based application,personally i recommended to use selenium.thus it is freeware and it allows to use HTML,java and many scripting languages.my next blog will be detail explanation of using selenium for web based application testing.

How to Setup WSAS on Apache Tomcat

2008-12-23T02:51:00.000-08:00

WSO2 Web Services Application Server is an Open Source service based application server fully built on Apache Axis2 Framework. It supports to manage various web services and protocols.

WSO2 Web Services Application Server capable to deploy most of the application servers. Such as Apache Tomcat , IBM WebSphere , BEA WebLogic Server and JBoss.In this tutorial, I am going to explain how WSAS deploy on the Apache tomcat application server. Following are the steps need to follow.

Step1

Download Web Services Application Server and unzip package.

Step2

Download Apache Tomcat and unzip package

Steps 3

Tomcat need to WSAS resource files other than WSAS deployment package to run on the tomcat server in running time. So you should assign the entire resource files in one environment variable. To do that,

A. Copy “resources”,”conf” and “repository” folders from WSAS unzipped package.

B. Create new folder and name it as a “CarbonRepo”.

C. Paste copied folder in to “CarbonRepo”.

D. Set Environment variable called “CARBON_HOME” by locating “CarbonRepo” folder.

Ex: your CarbonRepo folder in “D:\Projects\Carbon\WSAS\ CarbonRepo”

If you are using Linux,

export CARBON_HOME =/Projects/Carbon/WSAS/ CarbonRepo

If you are using Windows,

set CARBON_HOME = D:\Projects\Carbon\WSAS\ CarbonRepo

Step 4

Now WSAS need to deploy in apache tomcat. To deploy following instruction need to follow.

A. Copy “WEB-INF” in unzipped WSAS package/ webapps/ROOT

B. Create folder in tomcat “webapps” folder and paste copied WEB-INF.

Step 5

Now you have to enable https in your tomcat installation.(By default HTTPS protocol is disable in apache tomcat.)

A. Open server.xml in apache tomcat conf folder. This is the script tag need to add in apache tomcat server.xml

port="8443" minSpareThreads="5" maxSpareThreads="75"

enableLookups="true" disableUploadTimeout="true"

acceptCount="100" maxThreads="200"

scheme="https" secure="true" SSLEnabled="true"

keystoreFile="CARBON_HOME/resources/security/wso2carbon.jks" keystorePass="wso2carbon"

clientAuth="false" sslProtocol="TLS"/>

B. You need to locate wso2carbon.jks keystore file in keystoreFile parameter inside the Connector tag.

If your CARBON_HOME in “D:\Projects\Carbon\WSAS\ CarbonRepo”,this is the full path need to add in kerstoreFile parameter.

“D:/Projects/Carbon/WSAS/ CarbonRepo /resources/security/wso2carbon.jks”

C. Now HTTPS 8443 port number open for apache tomcat.

Steps 6

Now you should change WSAS “Server URL” in Server.xml. Because you need to add folder name to server url, what you create in tomcat webapps folder. Following are the instructions to change WSAS server.xml

A. Open server.xml file in your CARBON_HOME/conf folder.

B. Change the HTTPS port number from 9443 to 8443.because tomcat HTTPS enable in 8443 port number.

C. If your folder name is “WSAS” in tomcat webapps folder.

D. Your Final server url should be ,
https://localhost:8443/WSAS/services/

Steps 7

Now you have to do small modification in Axis2.xml as well. In Tomcat HTTP transport enable in port number 8080, but in WSAS HTTP enable in 9763 port number. Because of this you have to re-map those HTTP and HTTPS port umbers in WSAS Axis2.xml.Change the HTTP port number from 9763 to 8080 and HTTPS from 9443 to 8443.that should change as,

class="org.wso2.carbon.core.transports.http.HttpTransportListener">

8080

class="org.wso2.carbon.core.transports.http.HttpsTransportListener">

9443

To enable WSAS tools section you need to do another change in Axis2.xml.add “carbon” after back slash in Context root parameter.

Ex: - /carbon

Step 8

All the apache tomcat configurations finished now.Finally start apache tomcat.

A. Go to the Tomcat bin folder in command prompt/terminal.

B. Start tomcat as,

Windows = apache-tomcat-6.0.14\bin>catalina.bat run

Linux = apache-tomcat-6.0.14\bin>catalina.sh run

Step 9

After start apache tomcat this url you can use for access WSAS.

https://localhost:8443/wsas/carbon

How to Check Java Script enable your browser

2008-11-24T21:08:00.001-08:00

Some browsers disable of running java script by default.if you browse java script embedded web site,you may not seen java script functionalities.Using following instruction you can check you browser java script enable or not.

1. In address bar type = javascript:alert("Hello World")

2. If your browser already enable java script, you can see the following out put message box.

What is Software Testing?

2008-09-17T02:00:00.000-07:00

Software testing is major part of the software development. It is ensure quality of the software application. Software testing has Software Testing Life Cycle (STLC) like Software Development Life Cycle (SDLC) and software testing have many testing techniques to test software application and ensure the quality of the application.

Who is doing Software Testing?

Most of the times software testing doing by the test engineers or software quality assurance engineers. But some testing needs to be done from the software developers.

Software Testing Life Cycle (STLC)

In software Development process, Software Testing Life Cycle goes parallel with the Software Testing Life Cycle. STLC Contain following phases.

Test Planning

This is the phase QA Engineer has to decide what things need to be tested, what will be the coverage of testing, how test are doing etc. Naturally proper planning at this stage would greatly reduce the risk of low quality software. This planning will be an ongoing process with no end point.

Activities at this stage would include preparation of high-level test plan- (according to IEEE test plan template The Software Test Plan (STP) is designed to prescribe the scope, approach, resources, and schedule of all testing activities. The plan must identify the items to be tested, the features to be tested, the types of testing to be performed, the personnel responsible for testing, the resources and schedule required to complete testing, and the risks associated with the plan.). Almost all of the activities done during this stage are included in this software test plan and revolve around a test plan.

Test Analysis

Once test plan is made and decided upon, next step is to delve little more into the project and decide what types of testing should be carried out at different stages of SDLC, do we need or plan to automate, if yes then when the appropriate time to automate is, what type of specific documentation I need for testing.

Proper and regular meetings should be held between testing teams, project managers, development teams, Business Analysts to check the progress of things which will give a fair idea of the movement of the project and ensure the completeness of the test plan created in the planning phase, which will further help in enhancing the right testing strategy created earlier. We will start creating test case formats and test cases itself. In this stage we need to develop Functional validation matrix based on Business Requirements to ensure that all system requirements are covered by one or more test cases, identify which test cases to automate, begin review of documentation, i.e. Functional Design, Business Requirements, Product Specifications, Product Externals etc. We also have to define areas for Stress and Performance testing.

Test Design

Test plans and cases that were developed in the analysis phase are revised. Functional validation matrix is also revised and finalized. In this stage risk assessment criteria is developed. If you have thought of automation then you have to select which test cases to automate and begin writing scripts for them. Test data is prepared. Standards for unit testing and pass / fail criteria are defined here. Schedule for testing is revised (if necessary) & finalized and test environment is prepared.

Construction and verification

In this phase we have to complete the entire test plans, test cases, complete the scripting of the automated test cases, Stress and Performance testing plans needs to be completed. We have to support the development team in their unit-testing phase. And obviously bug reporting would be done as when the bugs are found. Integration tests are performed and errors (if any) are reported.

Testing Cycles

In this phase we have to complete testing cycles until test cases are executed without errors or a predefined condition is reached. Run test cases --> Report Bugs --> revise test cases (if needed) --> add new test cases (if needed) --> bug fixing --> retesting (test cycle 2, test cycle 3….).

Final Testing and Implementation

In this we have to execute remaining stress and performance test cases, documentation for testing is completed / updated, provide and complete different matrices for testing. Acceptance, load and recovery testing will also be conducted and the application needs to be verified under production conditions.

Post Implementation

In this phase, the testing process is evaluated and lessons learnt from that testing process are documented. Line of attack to prevent similar problems in future projects is identified. Create plans to improve the processes. The recording of new errors and enhancements is an ongoing process. Cleaning up of test environment is done and test machines are restored to base lines in this stage.

Create basic data service using WSO2 Data Service

2008-09-16T05:36:00.001-07:00

This tutorial describes how you create simple data service using WSO2 Data Service. WSO2 Data Service is latest web service application introduced by the WSO2.Before you create your data service you have to setup WSO2 Data Service Server. Following are the prerequisites for set up the Server.

Prerequisites

Download WSO2 Data Service
Download MySQL (This tutorial explain create a data service using MySQL Database)
Download JDK 1.5 or Higher

Before setup WSO2 Data service you have to install JDK and MySQL. Once you set up JDK and MySQL you have to setup sample database. here's the sample database format.

Database Name : Test

Table Format : Table Name - student

You can use following SQL Command in MySQL Command prompt for creating a database.

mysql>create database Test;

mysql>CREATE table student(Name varchar(100),Marks int(50),Status varchar(100));

mysql>insert INTO student values ('Chamara',88,'Pass');

mysql>insert INTO student values ('John',76,'Pass');

mysql>insert INTO student values ('Suminda',69,'Pass');

mysql>insert INTO student values ('Peter',41,'Fail');

Next step is setup the WSO2 data service server. Extract the downloaded WSO2 Data service pack in any location.

Then you need to add MySQL database driver to WSO2 data service. thus otherwise you cannot access MySQL database from the WSO2 Data service. for that download “mysql-connector-java-5.0.4-bin.jar and copy it to “\lib\extensions” inside data service folder.

If you are windows user you have to run wso2server.bat file or if you are Linux user you have to run wso2server.sh script using command prompt or shell to start WSO2 Data Service Server.

Once server start you can browser data service user interface using browser by using following URL.

For local Access :https://localhost:9443/ds/index.html

For Remote Access :https://[ServerIP]:9443/ds/index.html

[ServerIP] = IP address of the WSO2 data service server

Now you will see WSO2 Data service User interface.

To login to the Management Console Use following default user Credentials in sign in page.

User Name : admin

Password : admin

After login you can see WSO2 Data Service Home page as follows.

In this tutorial use only few major functionalities in WSO2 Data service application. Following are the two major functionalities use in this tutorial.

Data Services (See above Screen shot) - Displays List of data services currently deployed in the server.
Add (See above Screen shot) - Use to create new data service.
Try it tool - use check output of the data service

( For more information about WSO2 Data Services functionalities,refer User guide.)

Now you are ready to create new basic data service using MySQL Database. Follow there steps to create your data service. Chamara = 380

Click "Add" and insert data service name and description and click "next"

2. Select "RDBMS" Data Source Type in Step-2 window and click Add button for configure the data base connection

(For Integrate Relational databases like MySQL,MSSQL Server,Oracle etc RDBMS data source type should select. in addition to that WSO2 Data service support MS Excel,CSV and JNDI Data Sources also.)

3. Insert data service connection id and select data base type as follows. you can insert any name for Connection id )

4. Once you fill above fields Driver class will automatically load.

5.JDBC url you have to change for your database information

Default JDBC url display as "jdbc:mysql://[machine-name/ip]:[port]/[database-name]".for a example your database machine ip is 10.100.1.149 and MySQL port 3306 and database name id "Test", this is the way to fill up JDBC url.

jdbc:mysql://10.100.1.149:3306/test

6. Insert user name and password for database login

7. Click Test Connection button for establish data base connection.(if you are successfully configured in data service following message will applier) 545 chamara

8. Click Ok in configuration window and click next button in Step-2 window.

9.In Step 3 window click New query button for Add new query,

10. Insert following information in to add new query window.

Query ID = Name of the query (Test Query)

Data Source = Select data source connection created earlier. (Sample Connection)

SQL Statement = select * from Test

Grouped by element = Name of the group element (BaseElement)

Row name = Name of the sub element (Element)

11. Insert output mappings for get out put from the data service

for the click add new output mapping button and select element mapping type, insert output field name and SQL Column name. (output field name can be any name, but SQL Column name should equal to the database column name )

12. Add all the output mapping and click ok button.

13. click Next button for add new operation..

14. Click add new Operation button and type new operation name, select a query and click ok button.

15.Click Finish button for finish data service creation process.

Now you finished the data service creation process. you will see the created data service in data service list page.

For checking the data service you can use Try-it tool.fot that click "MyDataService"link in Service list.you will see page as follows.

Click Try this Service link and click Sample Operation button for get the output of the data service

Finally you will the the output as follows.

How to Access MySQL Database fom the Remote Location using Command Line

2008-09-03T04:14:00.001-07:00

The is the way to access MySQL Database from the remote location using command line.

Before you access database from the remote location, you have to grant the permission to access database . (See How to Grant Permission )

then from remote location use following command

Syntax : mysql -h [IP Address of MySQL DB] -u [UserName] -p

IP Address of MySQL DB = IP Address of MySQL Server Machine

UserName = Username which granted in MySQL Server

Ex : mysql -h 10.100.1.42 -u chamara -p

When you enter above command MySQL Server will ask Password.you have to submit password which you enter in granting permission phase.

How to Retrieve data using MySQL in Java Console

2008-09-02T02:53:00.001-07:00

This is simple example of data retrieving from the MySQL Database using java code. For connecting mysql database from the java code, you have to add MySQL Connector jar file ( Download MySQL Connector ) in to your reference libraries.

Here's the sample Code....

public class ReadingMySQL

{

public static void main(String[] args)

{

          Connection conn = null;
           Statement stmt = null;
            ResultSet rs = null;

            try {
              String dbURL = "jdbc:mysql://localhost:3306/wsasset";   // url of the mysql database
              String username = "root";    // username of wsasset database
              String password = "";    // password of wsasset database

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection(dbURL, username, password);

stmt = conn.createStatement();

if (stmt.execute("select * from assets"))

               {
                     rs = stmt.getResultSet();
                }

else

               {
                    System.err.println("select failed");
                }
               while (rs.next())

               {
                   String entry = rs.getString(2);
                   System.out.println(entry);
                   System.out.println(rs.getString(3));
                   System.out.println(rs.getString(4));
                   System.out.println(rs.getString(5));
                   System.out.println(rs.getString(6));
                   System.out.println(rs.getString(7));
               }

} catch (ClassNotFoundException ex)

             {
                  System.err.println("Failed to load mysql driver");
                   System.err.println(ex);
              }

       catch (SQLException ex) {
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: " + ex.getSQLState());
            System.out.println("VendorError: " + ex.getErrorCode());
            }

       finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException ex) { /* ignore */ }
                rs = null;
            }
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException ex) { /* ignore */ }
                stmt = null;
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException ex) { /* ignore */ }
                conn = null;
            }
        }
    }
}

How to Grant Permission to Remote Access in MySQL

2008-08-20T09:16:00.001-07:00

If you are using Client Server architecture with MySQL database,you cant directly access MySQL database which is in the server.

To Access MySQL Database thought the network,you have to grant the permission to each database.to do that you have to follow following steps.

Ex :- Create a database "WSO2"

1. Open MySQL Command Prompt

2. Type Following Command to grant usage permission to access MySQL

Syntax -

mysql> GRANT USAGE ON *.* TO username@[Client_IP] IDENTIFIED BY 'password';

Ex :-

mysql> GRANT USAGE ON *.* TO Chamara@10.100.1.149 IDENTIFIED BY 'chamara123';

3. Then Type following command to Grant database Permission

Syntax -

GRANT ALL PRIVILEGES ON database_name.* TO username@[Client_IP];

Ex :-

GRANT ALL PRIVILEGES ON WSO2.* TO chamara@10.100.1.149;

Now you can access WSO2 Database from anywhere.

User Interface Testing at Glance

2008-08-19T05:17:00.001-07:00

In Software Quality Assurance, UI Testing is most important Testing area.Because users are directly communicate with the User Interfaces.During the UI Testing Tester must concentrate to following key areas.

Colors of the controls and application
Look And Feel of the application
Ease of use
Controls up to Standard

Colors of the controls and application

Tester should concentrate on color used to buttons,labels and other controls.if application use dark colors or very bright colors,it tired users eye.because I think middle class colors are very user friendly.

Look And Feel of the application

Look and feel of the application is another important part.because user see the application at glance, it should be able to attract the user.other wise user will leave the application within a short time.so Tester should see the application user point of view and test look and feel.

Ease of use

Every task of the application should very user friendly.if user want to do some task using application,application should provide that very easy manner.for that application can use wizards,Help tips,meaningful labels and icons etc.In testing "Ease of use" of an application tester need to check wether that application follows wizards,meaningful labels,buttons,icons etc by covering all the functionalities.

Controls up to Standard

Using application controls based on the standards is another tip for improve user friendliness in application.in testing this section tester should concentrate whether that application follows standard buttons,labels,text boxes,drop down boxes,control sizes etc.otherwise user may confuse with the controls application used.

What makes a good Test Engineer

2008-08-18T03:57:00.000-07:00

A good test engineer has a 'test to break' attitude, an ability to take the point of view of the customer, a strong desire for quality, and an attention to detail. Tact and diplomacy are useful in maintaining a cooperative relationship with developers, and an ability to communicate with both technical (developers) and non-technical (customers, management) people is useful.
Previous software development experience can be helpful as it provides a deeper understanding of the software development process, gives the tester an appreciation for the developers' point of view, and reduce the learning curve in automated test tool programming. Judgment skills are needed to assess high-risk areas of an application on which to focus testing efforts when time is limited.

What makes a good Software QA engineer?
The same qualities a good tester has are useful for a QA engineer. Additionally, they must be able to understand the entire software development process and how it can fit into the business approach and goals of the organization. Communication skills and the ability to understand various sides of issues are important. In organizations in the early stages of implementing QA processes, patience and diplomacy are especially needed. An ability to find problems as well as to see 'what's missing' is important for inspections and reviews.

What makes a good QA or Test manager?

A good QA, test, or QA/Test(combined) manager should:

be familiar with the software development process
be able to maintain enthusiasm of their team and promote a positive atmosphere, despite what is a somewhat 'negative' process (e.g., looking for or preventing problems)
be able to promote teamwork to increase productivity
be able to promote cooperation between software, test, and QA engineers
have the diplomatic skills needed to promote improvements in QA processes
have the ability to withstand pressures and say 'no' to other managers when quality is insufficient or QA processes are not being adhered to
have people judgement skills for hiring and keeping skilled personnel
be able to communicate with technical and non-technical people, engineers, managers, and customers.
be able to run meetings and keep them focused.

What's the role of documentation in QA?

Critical. (Note that documentation can be electronic, not necessarily paper.) QA practices should be documented such that they are repeatable. Specifications, designs, business rules, inspection reports, configurations, code changes, test plans, test cases, bug reports, user manuals, etc. should all be documented. There should ideally be a system for easily finding and obtaining documents and determining what documentation will have a particular piece of information. Change management for documentation should be used if possible.

What's the big deal about 'requirements'?

One of the most reliable methods of insuring problems, or failure, in a complex software project is to have poorly documented requirements specifications. Requirements are the details describing an application's externally-perceived functionality and properties. Requirements should be clear, complete, reasonably detailed, cohesive, attainable, and testable. A non-testable requirement would be, for example, 'user-friendly' (too subjective). A testable requirement would be something like 'the user must enter their previously-assigned password to access the application'. Determining and organizing requirements details in a useful and efficient way can be a difficult effort; different methods are available depending on the particular project. Many books are available that describe various approaches to this task. Care should be taken to involve ALL of a project's significant 'customers' in the requirements process. 'Customers' could be in-house personnel or out, and could include end-users, customer acceptance testers, customer contract officers, customer management, future software maintenance engineers, salespeople, etc. Anyone who could later derail the project if their expectations aren't met should be included if possible. Organizations vary considerably in their handling of requirements specifications. Ideally, the requirements are spelled out in a document with statements such as 'The product shall.....'. 'Design' specifications should not be confused with 'requirements'; design specifications should be traceable back to the requirements.
In some organizations requirements may end up in high level project plans, functional specification documents, in design documents, or in other documents at various levels of detail. No matter what they are called, some type of documentation with detailed requirements will be needed by testers in order to properly plan and execute tests. Without such documentation.

What is Software Testing Life Cycle (STLC)

2008-08-15T02:37:00.001-07:00

Software Testing is most important task in software development.Once you developing a software Application,you have to understand the software development life cycle.like wise Software Testing Life Cycle is also parallel goes with the Software Development life Cycle.

Now I am going to explain section by section of Software Testing Life Cycle.

1. Requirement Analysis

In Requirement analysis phase need to understand of all the software requirements.for this you can use Software Requirement Specification (SRS) Document.

2. Test Case Writing

In this phase you have to write test cases by covering all the features and functionality in application.

Test Case Document should contain following sections.

Test Case Name :- Name Of the Test Case (Ex : Click Ok Button)
Test Case :- How that test should do (Ex: Go to X window and Left Click Ok Button)
Expected Result : - Result Of the Test (Ex : Y window Display)
Status : - Actual Result of test case Pass/Fail
Comments : - Special Remarks of the test case.

3. Test Case Executing

Executing test cases in test case Document and filling.

4. Issue Reporting

During the application testing you have to track all the issues currently having.for this you can use issue tracking tool.

5.Issue Verification

After fix the issue you reported by the developer you have to retest that.above 3,4,5 STLC phases you have to follow as a cycle until application come up to some standard.

6. Release Product

In this phase you are ready to release the application.you have to make release notes for it.In release not contain all the areas you tested and what are the knows issues in this release application.

Test Blog

2008-06-19T22:17:00.001-07:00

This is an test blog.....