Open Source Technologies

How to deploy WSO2 Gadget Server on tomcat

2010-08-05T04:25:00.000-07:00

Applies To: wso2gs-1.1.0.zip ( Carbon 3.0.0)
apache-tomcat-6.0.20

Step 1
Download WSO2 Gadget Server -1.1.0 from http://wso2.org/downloads/gadget-server. Extract the downloaded zip into a directory. And copy repository and resources directories in to a new folder. Here after, we will refer it as gs-repo (eg:- /home/krishatha/gs-repo)

Step 2
Lets refer to your tomacat installation directory as CATALINA_HOME. Go to CATALINA_HOME/webapps directory and create a new folder call wso2gs .Now, copy wso2gs-1.1.0/webapps/ROOT/WEB-INF to
CATALINA_HOME/webapps/wso2gs

Step 3
Now you will need to enable HTTPS on Apache Tomcat since WSO2 Gadget Server runs over HTTPS. To do this, access the server.xml file located at CATALINA_HOME/conf and uncomment the following
and fill as below.

<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"
maxThreads="150" scheme="https" secure="true"
clientAuth="false" sslProtocol="TLS"
keystoreFile ="/home/krishatha/gs-repo/resources/security/wso2carbon.jks"
keystorePass="wso2carbon"/>

One could find the wso2carbon.jks file inside the CARBON_HOME/repository/resources/security/ directory in WSO2 Gadget Server installation home (CARBON_HOME)

Make sure to give the exact location of wso2carbon.jks
Note: you can use your own keystore file if required.

Step 4
Now we must do the necessary configurations in a set of config files shipped with WSO2 Gadget Server. We will update carbon.xml, axis2.xml, registry.xml, mgt-transports.xml and user-mgt.xml which can be found at gs-repo/repository/conf directory.

(a) Edit the carbon.xml in gs-repo/repository/conf and put /wso2gs as the WebContextRoot

<WebContextRoot>/wso2gs</WebContextRoot>

the WebContextRoot will be the name you used to create war distribution in CATALINA_HOME/webapps

(b) Edit the same carbon.xml and set backend sever URL as below.

<ServerURL>https://your-ip:8443/wso2gs/services/</ServerURL>

It is recommended to use your IP rather than using localhost or hostname.
Note that we have configured Tomcat to run on 8443 port now.

(c)Now open axis2.xml to change the http and https ports in the Transports section of axis2.xml as follows:

<transportReceiver name="http"
class="org.wso2.carbon.core.transports.http.HttpTransportListener">
<parameter name="port">8080</parameter>
</transportReceiver>

<transportReceiver name="https"
class="org.wso2.carbon.core.transports.http.HttpsTransportListener">
<parameter name="port">8443</parameter>
</transportReceiver>

(d) Edit the mgt-transports.xml as follows: https and http ports of the transport section can be changed as follows.

<transport name="http" class="org.wso2.carbon.server.transports.http.HttpTransport">
<parameter name="port">8080</parameter>

<transport name="https" class="org.wso2.carbon.server.transports.http.HttpsTransport">
<parameter name="port">8443</parameter>

(e) Open registry.xml and update DB configurations as follows:

<dbConfig name="wso2registry">
<url>jdbc:h2:/home/krishatha/gs-repo/repository/database/WSO2CARBON_DB</url>
<userName>wso2carbon</userName>
<password>wso2carbon</password>
<driverName>org.h2.Driver</driverName>
<maxActive>50</maxActive>
<maxWait>60000</maxWait>
<minIdle>5</minIdle>
</dbConfig>

Note that you have to use absolute path to the H2 DB.

(f) Open user-mgt.xml and update DB configurations as follows:

<Property name="url">jdbc:h2:/home/krishatha/gs-repo/repository/database/WSO2CARBON_DB</Property>
<Property name="userName">wso2carbon</Property>
<Property name="password">wso2carbon</Property>
<Property name="driverName">org.h2.Driver</Property>
<Property name="maxActive">50</Property>
<Property name="maxWait">60000</Property>
<Property name="minIdle">5</Property>

Note that you have to use the absolute path to the H2 DB.

Step 5
You also need to copy the wso2gs-1.1.0/lib/log4j.properties file into CATALINA_HOME/webapps/wso2gs/WEB-INF/classes

Step 6
Now copy the jar files in wso2gs-1.1.0/lib/endorsed/ into CATALINA_HOME/lib. You need to copy the followig jar files.

1. xalan-2.7.0.wso2v1.jar
2. xercesImpl-2.8.1.wso2v1.jar
3. xml-apis-1.3.04.wso2v1.jar

Step 7
We have completed the required configurations. Now, open a new command window and change the directory to CATALINA_HOME/bin. Define an environment variable called CARBON_HOME and set the path to your gs-repo directory.

In windows; set CARBON_HOME=C:\gs\gs-repo
In linux; export CARBON_HOME=/home/krishatha/gs-repo

Start tomcat server from the same command window/shell.

eg:- catalina.sh run
catalina.bat run

After starting the WSO2 Gadget Server, you can access the management console using below URL

https://your-ip:8443/wso2gs/carbon

How to install oracle XE on ubuntu 10.04 64 bit

2010-07-20T05:05:00.000-07:00

Recently I had to go though the pain of installing oracle on Ubuntu again in my new laptop. Two years back I did the same installation on Ubuntu 7.10 and cost me two days to complete the installation. But this time things are rather easy.

So here we go.

Before installing
1. sudo apt-get install bc

Then I installed the packet.
sudo dpkg --force-architecture -i oracle-xe_10.2.0.1-1.0_i386.deb

Then I configured the system:
sudo /etc/init.d/oracle-xe configure

Then follow the below steps

1. export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
2. export ORACLE_SID=XE
3. export PATH=$ORACLE_HOME/bin:$PATH
4. sudo apt-get install ia32-libs
5. sudo /etc/init.d/oracle-xe start

If you get bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus: No such file or directory error then killer might be missing step 4
sudo apt-get install ia32-libs

References :
[1] http://littlebrain.org/2008/05/12/how-to-install-oracle-xe-in-ubuntu-64-bit/

Guide to install oracle using apt get
[2] http://www.webxpert.ro/andrei/2009/05/31/instal-oracle-10g-xe-on-ubuntu-server-904-jaunty-jackalope/

Start SOA governance with WSO2 governance Registry

2010-05-04T00:30:00.000-07:00

WSO2 has recently announced their new release of WSO2 Governance Registry which is based on WSO2 Carbon framework 3.0.0.

It was packed with some exciting and very useful new features. The product can be used not only to govern you SOA metadata, but also as a registry-repository for your organization. Most interestingly the product is open source and available freely under Apache license. First version (0.1) of the product was released in December, 2007. Thus, the product has been matured over two years and good enough to cater your SOA governance requirement easily.

List of new features of the release as follows.

New Features
============================

* Gadgets for impact analysis on services and registry resources
* WSDL custom view
* Dynamic Handler configuration
* Handler simulator
* Tree-based Resource view
* API to govern SOA artifacts
* Complete Web Services API for Registry
* Improved options for Service discovery
* WS-Discovery support
* Scripting support for lifecycle management
* Improved P2 based provisioning and feature management support
* Support for adding remote mounts
* Platform, and Group/Cluster based deployment model
* Support for multiple server instances
* E-mail verification for subscriptions
* Support for deleting tags and comments
* Support for PostgreSQL DBMS
* Paged activity and resource search
* Hierarchical permission model with granular and extensible permissions
* Ability to upload metadata (in addition to importing)
* Governance Archive for uploading WSDLs and Schemas with imports
* Ability to update resource content by uploading
* Rich text editor for editing text resources
* XML editor for editing handler, lifecycle and service UI configurations

How to capture popup windows using selenium.

2009-10-29T22:48:00.000-07:00

I am going to discuss on selenium popup handling specifically with selenium RC. I was searching though internet for a while to find a solution for processing of popups though selenium.But I was unable to find best fit answer for my test scenario. I wanted to capture pop-up window do some processing then close the popup and get back to parent window again.Anyway by following the reference guides and other available materials I was able to implement the the above mentioned test scenario.

As per my understanding selenium IDE supports capturing popup windows but get back to parent window is not supported. I tried several times and failed to set focus to parent window again. Selenium API doc says, in order to select parent window again, use selectWindow() methods with null parameter. But that didn't work for me. selenium RC was fail to select the parent window again. There are several API methods available in selenium to detect required references for popup windows. Those are

selenium.selectWindow();
selenium.getAllWindowIds();
selenium.getAllWindowNames();
selenium.windowFocus();
selenium.waitForPopUp();
selenium.close();

In my case,I have followed implementation give below to write the test scenarios in junit.

click the popup window link

selenium.click("link=Feed");

Get the pop up window ID.

String feedWinId = selenium.getEval("{var windowId; for(var x in selenium.browserbot.openedWindows ) {windowId=x;} }");

Select the popup window.In order to select it, you must somehow identify it. Various identification methods are available with selectWindow() function see http://release.seleniumhq.org/selenium-remote-control/0.9.0/doc/java/ for more details

selenium.selectWindow(feedWinId);

Set focus to popup window.

selenium.windowFocus();

//Then do some proccssing

close the popup

selenium.close();

select parent window again. You need to know the window title or name

String[] winFocus;
String winTitle;
winFocus = selenium.getAllWindowTitles();

If there is more than one open windows you have to iterate though winFocus array and find the correct window to set the focus.

winTitle = winFocus[0];

if (winTitle.equalsIgnoreCase("WSO2 Management Console")) {
selenium.selectWindow(winTitle);
}

If you need to wait for the popup then use

selenium.waitForPopUp(winID, time-ms);

I hope above instructions will help you in dealing with pop ups. Please feel free to comment and ask questions

Source code of the test : https://wso2.org/repos/wso2/branches/commons/qa/web-test-framework/2.0.2/registry/src/test/java/org/wso2/carbon/web/test/registry/FeedsTest.java

WSO2 SOA workshop - Santa Clara, CA | November 3rd 2009

2009-10-22T00:05:00.000-07:00

Join us in Santa Clara, CA on the 3rd of November for a full-day interactive workshop on real world best practices for SOA. Learn how to map specific business requirements to concrete SOA development.

WSO2 Governance Registry 3.0.0 installation on Jboss 5.0 with Oracle 10g

2009-08-18T06:07:00.000-07:00

WSO2 G-Reg, one of the leading open source SOA governance solution available. The latest release of the WSO2 G-Reg support multiple application servers along with most common production databases.This post list down the steps to deploy G-Reg 3.0.0 on Jboss 5.0 GA using oracle 10g.

Step 1
Download WSO2 G-Reg-3.0.0 from here. Extract the downloaded zip into a directory. Copy conf, database, repository and resources directories in to a new folder. Here after, we will refer it is greg-repo (i.e:- /home/krishatha/greg-repo)

Step 2
Lets refer to your jboss installation directory, JBOSS_HOME. Go to JBOSS_HOME/server/default/deploy directory and create a new folder, wso2greg.war.Now, copy wso2greg-3.0.0/webapps/ROOT/WEB-INF to JBOSS_HOME/server/default/deploy/wso2greg.war

Step3
Now configuring jboss ssl connector as given below.

a. First up, you should probably shut down the JBoss server as you do this step.
In the JBoss directory, there should be a file called server.xml:

JBOSS_HOME/server/default/deploy/jbossweb.sar/server.xml

This file includes information about what web features to turn on when the server starts up.Inside this file, there should be a part that looks like this



b. Make the following changes:

i. Uncomment the block
ii. Change the port to 8443
iii. Change the keystore password to the password used.

The end result should look something like this:


<Connector protocol="HTTP/1.1" SSLEnabled="true"
port="8443" address="${jboss.bind.address}"
scheme="https" secure="true" clientAuth="false"
keystoreFile="/home/krishatha/greg-repo/resources/security /wso2carbon.jks"
keystorePass="wso2carbon" sslProtocol = "TLS" />

Make sure to give the exact location of wso2carbon.jks as highlighted above.
Note: you can use your own keystore file if required.

Step 4
Now we must do the necessary configurations in a set of config files shipped with WSO2 G-Reg. We will update carbon.xml, axis2.xml, registry.xml, transports.xml and user-mgt.xml which can be found at greg-repo\conf directory.

a. Edit the carbon.xml in greg-repo/conf and set backend sever URL as below.

<ServerURL>https://IP:8443/wso2greg/services/</ServerURL>

it is recommended to use your IP rather than using localhost or hostname.
Note that we have configured JBoss to run on 8443 port.

b. Edit the same carbon.xml and put /wso2greg as the WebContextRoot

<WebContextRoot>/wso2greg</WebContextRoot>

the webcontextroot will be the name you used to create war distribution in JBOSS_HOME/server /default/deploy/wso2greg.war/

c. Then open axis2.xml, We must change the http and https ports in In Transports section of axis2.xml as follows.

<transportReceiver name="http"
class="org.wso2.carbon.core.transports.http.HttpTransportListener">
<parameter name="port">8080</parameter>

</transportReceiver>
<transportReceiver name="https"
class="org.wso2.carbon.core.transports.http.HttpsTransportListener">
<parameter name="port">8443</parameter>
</transportReceiver>

d. Edit the transports.xml as follows. https and http ports of the transport section can be changed as follows.

<transport name="http" class="org.wso2.carbon.server.transports.http.HttpTransport">
<parameter name="port">8080</parameter>

<transport name="https" class="org.wso2.carbon.server.transports.http.HttpsTransport">
<parameter name="port">8443</parameter>

e. Open registry.xml and update DB configurations as follows.

<dbconfig name="wso2registry">
<url>jdbc:oracle:thin:@hostname:1521:SID</url>
<userName>wso2</userName>
<password>wso2</password>
<driverName>oracle.jdbc.driver.OracleDriver</driverName>
<maxActive>80</maxActive>
<maxWait>60000</maxWait>
<minIdle>5</minIdle>
</dbconfig>

Note that the DB configuration used here is for oracle and you can set the DB configuration to any other supported DB accordingly.

f. Open user-mgt.xml and update DB configurations as follows.

<Database>
<URL>jdbc:oracle:thin:@hostname:1521:SID</URL>
<UserName>wso2</UserName>
<Password>wso2</Password>
<Dialect>oracle</Dialect>
<Driver>oracle.jdbc.driver.OracleDriver</Driver>
<maxActive>30</maxActive>
<maxWait>60000</maxWait>
<minIdle>5</minIdle>
</Database>
Note that the DB configuration used here is for oracle and you can set the DB configuration to any other supported DB accordingly.now you have done with configuration changes.

More details on setting up G-Reg with oracle can be found from here.

Step 5
Now you need to copy oracle driver class to the correct location. In my case I have used ojdbc14.jar.

copy ojdbc14.jar into greg-repo/repository/components/extensions

step 6
You also need to copy the wso2greg-3.0.0/lib/log4j.properties file into JBOSS_HOME/server/default/deploy/wso2greg.war/WEB-INF/classes, and JBOSS_HOME/common/lib/log4j.jar to JBOSS_HOME/server/default/deploy/wso2greg.war/WEB-INF/lib

step7
We have completed the required configurations. Now, open a new command window and change the directory to JBOSS_HOME/bin.Define an environment variable called CARBON_HOME and set the path to your greg-repo directory.

In windows; set CARBON_HOME=C:\greg\greg-repo
In linux; export CARBON_HOME=\home\user\greg\greg-repo

Start JBoss from the same command window/shell. To start JBoss with the "-b [IP]" option use the following commands.

ex:- run.bat -b 12.34.56.78 OR
./run.sh -b 12.34.56.78

WSO2 G-Reg will be started successfully. You can access the management console using https:\\IP:8443\wso2greg\carbon

Related posts: How to deploy WSO2 WSAS-3.* on JBoss

Deploying and securing web service with Username Token Policy

2009-04-26T21:51:00.000-07:00

Here Charitha Kankanamge, one of my colleague demonstrate deploying a java web Service on WSAS and Securing it with Username Token Policy

Microsoft SQL Server (Microsoft Driver)

2009-03-26T00:50:00.000-07:00

Today I wanted to configure WSO2 Registry to run with MSSQL server. To do that I had to specifically use sqljdbc.jar 1.2 driver. I had to struggle few minutes to find correct connection parameters. Most of the connection details mentioned in the web are outdated or invalid. So I waisted around 1 hour due to my laziness to debug the application. To the benefit of others I will publish the connection details here. (at least to save others time)

Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Default Port: 1433

JDBC URL

jdbc:sqlserver://host:1433;databasename=db

or

jdbc:sqlserver://host:port;databasename=db;user=yourUser;password=yourPwd

If you set the incorrect connection URL probable you will end up with "java.sql.SQLException: No suitable driver" exception.

How to Deploy WSO2 Registry on JBoss using oracle

2009-03-18T07:44:00.000-07:00

The step by step guide is available at here

Deploying WSO2 Registry on tomcat

2009-03-16T11:46:00.000-07:00

WSO2 registry is one of the leading open source registry-repository available today. It allows users to store and manage SOA metadata in a more convenient and manageable manner. WSO2 Registry can be used as a standalone distribution as well as it can be deployed on most of the servlet containers . Following step by step guide will show you how to deploy wso2registry on tomcat.

This guide applies to WSO2 registry 2.0.1 and tomcat-6.0.14

Step 1 – Enable SSL connector in tomcat.

Lets refer to your tomcat installation directory, CATALINA_HOME.

E.g.: -
CATALINA_HOME=C:\apache-tomcat-6.0.14

Now you will need to enable HTTPS on Apache Tomcat since WSO2 REGISTRY runs over HTTPS. To do this, access the server.xml file located at %CATALINA_HOME%/conf and uncomment the following.

Connector port="8443" maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" disableUploadTimeout="true"
acceptCount="100" scheme="https" secure="true"
clientAuth="false" sslProtocol="TLS"

Then you will need to provide the keystore file location along with it's password as below.

Connector port="8443" maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" disableUploadTimeout="true"
acceptCount="100" scheme="https" secure="true"
clientAuth="false" sslProtocol="TLS"
keystoreFile = "C:\Carbon\ESB\tomcat\WSO2-registry-2.0.1\resources\security\wso2carbon.jks"
keystorePass="wso2carbon"

One could find the wso2carbon.jks file inside the /resources/security/ directory in wso2 registry installation home.

Step 2 - Downloading and installing WSO2 Registry

Download the latest WSO2 Registry distribution from here and extract to a specific location. (E.g.:- C:\Carbon\Registry\tomcat\WSO2 registry 2.0.1). From this folder copy the folders,

- conf
- database
- resources
- repository

to a separate folder. (E.g.:- C:\Carbon\REGISTRY\tomcat\registry_home)

Step 3 - Setting environmental variables

You will have to set an environment variable with the name CARBON_HOME pointing it to the directory which you copied the above files to.

E.g.:-
CARBON_HOME=C:\Carbon\REGISTRY\tomcat\registry_home

Step 4 - Copying required files to Apache Tomcat

Now create a folder inside the webapps folder of Tomcat.

E.g.:-
C:\apache-tomcat-5.5.20\webapps\wso2registry

Next, you need to copy the WEB-INF folder, which is in the folder which you extracted the downloaded Registry distribution. Then copy it into the registry folder which you created above.

E.g.:-
Copy
C:\Carbon\REGISTRY\tomcat\WSO2-registry-2.0.1\webapps\ROOT\WEB-INF
to
C:\WSO2\Installations\apache-tomcat-6.0.14\webapps\wso2registry

Step 5 - Changing necessary files of the WSO2 Registry distribution

a) Open the carbon.xml file which is in the CARBON_HOME\conf folder and specify the following URL as the backend ServerURL

E.g.:-
https://localhost:8443/wso2registry/services/

b) Next open the axis2.xml which is located inside the CARBON_HOME\conf and change the http port from 9763 to 8080 (the default http port of Tomcat) and the https port from 9443 to 8443.

c) In addition to the above, you need to specify the correct paths for the two .jks files wso2carbon.jks and client-truststore.jks specified in the axis2.xml and also the wso2carbon.jks file specified in the carbon.xml file.

d) Then you need to specify the absolute paths of the WSO2CARBON_DB of the two files registry.xml and user-mgt.xml

E.g.:- Change
jdbc:derby:database/WSO2CARBON_DB;create=true
to
jdbc:derby:C:\Carbon\REGISTRY\tomcat\registry_home\WSO2CARBON_DB;create=true

Step 6 - Starting the Apache Tomcat Server

Now you can start the Apache Tomcat server by giving the following command.
catalina.bat run

Step 7 - Login to the WSO2 Registry Administration Console

Now you should be able to login to the WSO2 Registry Administration Console as, https://localhost:8443/wso2registry/carbon

Guide to deploy other wso2 product on tomcat server is available also.

1. WSO2 Web Services Application Server (WSAS)
2. WSO2 Enterprise Service Bus (WSO2 ESB)
3. WSO2 Business Process Server (WSO2 BPS)

How to use H2 shell

2009-03-04T04:35:00.000-08:00

H2 is one of the fastest database which comes under modified version of the MPL 1.1 ( Mozilla Public License ) or under the (unmodified) EPL 1.0 ( Eclipse Public License ).

H2 Shell is a command line database tool which can be used for any of the database sql operation. To run the H2 shell go to the bin directory of your H2 installation and run the following.

java -cp h2*.jar org.h2.tools.Shell

Once you run the tool it will ask some connection details.

URL       jdbc:h2:tcp://localhost/~/test1
Driver    org.h2.Driver
User      sa
Password  sa
Connected
Commands are case insensitive; SQL statements end with ';'
help or ?      Display this help
list           Toggle result list mode
maxwidth       Set maximum column width (default is 100)
show           List all tables
describe       Describe a table
quit or exit   Close the connection and exit

sql>

Users can either use H2 shell or web console. H2 web console will allow you to access sql database using a browser. One of my colleague has written nice blog entry on getting started with H2 database and using the H2 web console.

Installing oracle 10g on Ubuntu 7.10 (Linux)

2008-08-29T07:02:00.000-07:00

If you are not an genius on oracle, Installing oracle on Ubuntu/Linux is really a hard process.Two days ago,I had to undergo though the same installation process and thought of sharing my steps for installation in here (at least to save someones time and effort). By being successful with the installation, wso2 registry team is in the effort of making their SOA registry-repository compatible with oracle.

This guide applies to 10.2.0 linux32 and Ubuntu 7.10.

1.Download and unpack 10201_database_linux32.zip

2.Run the following commands in a terminal

$ sudo ln -s /usr/bin/basename /bin/basename
$ sudo ln -s /usr/bin/awk /bin/awk

The installer relies on some binaries being in /bin instead of /usr/bin so you need to make a few links.

3.Add nobody and dba groups.

sudo addgroup nobody
sudo addgroup dba

4. Add yourself to dba group Useradd -G {group_name} username o

Go to /etc/groups and modify the dba group with your name
in my case "dba:x:1003:krishantha"

5. I recommend you to set ORACLE_HOME and ORACLE_OWNR environment variables before begin the installation. Setting these values may overcome lots of problems that your will have to face when working with oracle instance.I know, it is quite strange to set those values before beging the installation. But better to do it. Noramally oracle takes it home as /product/10.2.0/db_1 with default settings.

so set the env variable in your terminal or .bashrc file as below.

export ORACLE_HOME=/home/krishantha/oracle/product/10.2.0/db_1
export ORACLE_OWNR='krishantha'

6. Before starting with oracle installation start installing following packages, in any case those packages are unavailable on your machine.
-gcc
-make
-binutils
-lesstif2 libc6
-libc6-dev
-rpm
-libaio
-libaio-dev
-libstdc++5
-ibstdc++5-3.3-dev
-build-essential

You can use apt-get install and apt-cache search command for finding and installing missing packages.

7. Now you need to run the installer. Go to zip extracted directory (./product) and issue the below command. Note that you must not run this command as root.

./runInstaller -ignoresysprereqs

ignoresysprereqs option will ignore the process of checking product prerequisite.

(please ignore "sh: /bin/rpm: not found" message on the terminal)

8. In the oracle installation wizard follow the default settings ( You can define your own settings based on your requirement)

Oracle installation wizard.

In one of the step oracle ask global database group, you need to enter dba as the group which you are already a member. By keeping that in mind, follow the wizard.

a. Keep the default path for oraInventory or else you can change it to another.

b. Select installation type as Enterprise edition.

c. Keep the default values for oracle home (make sure to change the ORACLE_HOME value if your are changing the path.

d. Select "create database" in configuration option step.

e. Select database configuration as "General Purpose"

f. Set Global database name and sid as 'orcl' or your own name.( if you want to create database with sample oracle schemas then tick
the sample creation text box

g. Select Use database control for database Management.

h. Select file system.

i. Enable or disable automated backups.

j.Set database schema passwords.

k.After you do that the installer will ask you to run two scripts as root. Paths to these scripts (shown in installer dialogue) depend on your system, for me they were:

$ sudo /home/krishantha/oraInventory/orainstRoot.sh
$ sudo /home/krishantha/oracle/product/10.2.0/db_1/root.sh

9. Finally wizard will display some links to sqlplus and em. Make sure to copy them.

10. Finally set following environmental variables.

export LD_LIBRARY_PATH=/home/taw/oracle/product/10.2.0/db_1/lib/
export ORACLE_SID='orcl'

ORACLE_SID is the database name give in 6th step of the installation wizard. In my case it is 'orcl'.
And also you can check the SID value from /etc/oratab file.

orcl:/home/krishantha/oracle/product/10.2.0/db_1:N

Now you have finished with the installation. It is time to check the new oracle installation is working or not.

Below simple steps will guide your to startup and shut down of oracle instance.

In a new terminal issue
$ sqlplus /nolog

Then
SQL> connect sys/yourpassword as sysdab
Connected.

If it displays "connected to idle instance",means that your oracle instance is not up and running. you can start the oracle instance using startup command.

Issue startup command.

shut command will shut-down the oracle instance.

Now as the sys DBA create simple table and query to see how much you are lucky.

CREATE TABLE TEST (ID NUMBER PRIMARY KEY,NAME VARCHAR2(30));
INSERT INTO TEST(ID,NAME) VALUES ('1','test1');
INSERT INTO TEST(ID,NAME) VALUES ('2','test2');
SELECT * FROM TEST;

Okay you have done!!!. Enjoy with oracle.

Reference:
1 .http://ubuntuforums.org/showthread.php?t=112572
2. http://t-a-w.blogspot.com/2007/11/installing-oracle-10g-enterprise.html

Change mysql max_allowed_packet variable

2008-08-21T23:52:00.000-07:00

There are several ways to change the max_allowed_packet variable size in mysql

1. Edit max_allowed_packet entry of /etc/my.cnf file (on Linux). Change the following line

[mysqld]
max_allowed_packet=16M

2. Start the mysql server with the --max_allowed_packet option.

/etc/init.d/mysql restart --max_allowed_packet=1024M

3. To edit the max_allowed_packet without restarting the server.

mysql> show variables like 'max_allowed_packet%' ;
+--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+
1 row in set (0.00 sec)

mysql> set max_allowed_packet = 1073741824;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'max_allowed_packet%' ;
+-----------------------------------+---------------------+
| Variable_name | Value |
+----------------------------------+---------------------+
| max_allowed_packet | 1073741824 |
+--------------------+------------+----------------------+

How to set heap size for tomcat on Linux.

2008-08-20T06:22:00.000-07:00

I was searching about the subject on internet. But unable to find a exact answer. Finally I manage to solve my probe with below mentioned work round.This is a quick tip to change heap size for tomcat.

Fist set the CATALINA_OPTS as follows.
export CATALINA_OPTS="-Xms256m -Xmx900m"

Then start the tomcat server by > sh startup.sh

The two JVM options for heap size are

-Xms - is the minimum or initial size of your heap
-Xmx - is the maximum size of your heap.

JUnit best practices

2008-08-06T03:49:00.000-07:00

I found this article written by Andy Schneider about Junit best practices from here. He talks about techniques to improve unit test and test usefulness, avoiding basic mistakes and design level issue.

Just have a quick look if you are interesting.

How to run JUnit test suite from Ant

2008-07-16T01:52:00.000-07:00

When I was developing performance test framework for wso2registry, I came across a problem of using Ant to run a Junit test suite. As I seen in the web, lots of users asking whether Ant supports for running Junit test Suite class. I didn't see anything mentioned in the documentation as to if this is possible. Here is my answer for all, running a Junit test Suite is possible using Ant. Following simple step by step guide illustrate how to do that.

As the first step, let's create a sub directory called “mytest” and put the bellow test class to the directory. For simplicity this test class doesn't really test anything.

import junit.framework.TestCase;
public class HelloWorld extends TestCase {

public HelloWorld(String text){
super (text);
}

public void testprint1(){
System.out.println("Hello World1");
assertTrue( "TestExample", true );
}

public void testprint2(){
System.out.println("Hello World2");
assertTrue( "TestExample", true );
}
}

Then create the below test suite in the same subdirectory. In JUnit, "suites" can be used to run a group of test classes and allows for some additional functionality.

import junit.framework.Test;
import junit.framework.TestSuite;

public class HelloworldSuite extends TestSuite {

public static Test suite(){
TestSuite suite = new TestSuite();

suite.addTest(new HelloWorld("testprint1"));
suite.addTest(new HelloWorld("testprint2"));
suite.addTest(new HelloWorld("testprint1"));

return suite;
}
}

Now create a directory called “lib” inside your “mytest” directory and copy the junit.jar file to it. In my case, I'm using junit-4.4.jar. In addition to that you need to add junit.jar to your CLASSPATH or copy junit.jar to your Ant library(ANT_HOME/lib) from your JUnit library to enable the integration of JUnit and Ant.

Now put the below build.xml file to your “mytest” directory.

<project name="Hello-world-sample" basedir="." default="test">

<property name="dest.dir" value="build" />
<property name="dest.dir.classes" value="${dest.dir}/classes" />
<property name="dest.dir.lib" value="${dest.dir}/lib" />
<property name="home" value="." />

<path id="build.class.path">
<fileset dir="${home}/lib">
<include name="*.jar" />
</fileset>
</path>

<path id="test.class.path">
<pathelement location="${dest.dir.classes}" />
</path>

<target name="clean">
<delete dir="${dest.dir}" />
</target>

<target name="prepare">
<mkdir dir="${dest.dir}" />
<mkdir dir="${dest.dir.classes}" />
</target>

<target name="compile" depends="clean,prepare">
<javac srcdir="src" destdir="${dest.dir.classes}">
<classpath refid="build.class.path" />
</javac>
</target>

<target name="run" depends="compile"/>

<target name="test" depends="compile">
<junit>
<classpath refid="test.class.path" />
<classpath refid="build.class.path" />
<formatter type="brief" usefile="false" />
<test name="HelloworldSuite" />
</junit>
</target>
</project>

Finally execute the test as below.

C:\Ant_Test>ant test
Buildfile: build.xml

clean:
[delete] Deleting directory C:\Ant_Test\build

prepare:
[mkdir] Created dir: C:\Ant_Test\build
[mkdir] Created dir: C:\Ant_Test\build\classes

compile:
[javac] Compiling 4 source files to C:\Ant_Test\build\classes

test:
[junit] Testsuite: HelloworldSuite
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0 sec
[junit]
[junit] ------------- Standard Output ---------------
[junit] inside test print1
[junit] inside test print2
[junit] inside test print3
[junit] ------------- ---------------- ---------------

BUILD SUCCESSFUL
Total time: 1 second

Note that if you use packages then the test name in the build.xml should be change as

<test name="package.name/HelloworldSuite"/>

SOA registry competition

2008-07-02T05:12:00.000-07:00

Deepal Jayasinghe has written this blog entry about Open source competition - Mule Galaxy vs WSO2 Registry. He has published an article of comparing Glaxy vs WSO2 Registry. It is worth to read his article before you starting with any open source SOA registry.

Using WSO2 Registry as URL-based repository for WSO2 Web Services Application Server (WSAS)

2008-07-02T04:32:00.000-07:00

Here I discusses how to configure WSAS to use WSO2 registry as URL repository. Versions above WSAS 2.0 support URL-based repositories. It is simple to configure WSAS to use WSO2 Registry as repository. Let's follow step by step guide given below to do the configuration.

Step 1: Deploy WSAS binary distribution. See WSO2 WSAS Installation Guide for details.

Step 2: Deploy wso2registry.war file in a preferred servelet container it is matter of copying wso2registry.war file into your servelet container. See WSO2 Registry user guide for details. WSO2 Registry 1.1 can be downloaded from here.

Step 3: Go to http://localhost:8080/wso2registry. Note that port should be changed according to yours.

Step 4: Login to the system using user name “admin” and password “admin.

Step 5: Then go to add collection and create a collection with the name “wsas-repo” , and select Media Type as “application/vnd.wso2.wsas”. you will notice it creates a collection name "wsas-repo",there will be three sub collection called “services” , “modules” and “conf” inside the wsas-repo.

At the moment please ignore the “conf” directory.

Step 6: Next you need to upload WSAS administration modules into “wsas-repo”. To do that go to modules collection and upload following modules and module.list file by using “Add resource” option. These modules are shipped with WSAS binary distribution and can be found under the $WSO2WSAS_HOME/repository/module
(in my case /home/krishantha/wsas/wso2wsas-2.2.1/repository/modules on Linux).

Step 7: Same as the above step, now you need to upload WSAS default services in to “services” collections. To do that, go to “service” collection and upload following service files. These services are shipped with WSAS and can be found under the $WSO2WSAS_HOME/repository/services.

Step 8: Now you need to configure the registry URL repository in WSAS. Locate the server.xml file under the $WSO2WSAS_HOME/conf directory, and locate the following entry in the file.

<RepositoryLocation>${wso2wsas.home}/repository/<RepositoryLocation>

Change the "RepositoryLocation" entry to "http://localhost:8080/wso2registry/resources/wsas-repo".

Step 9: Restart WSAS server pointing to repository so all the available services under “services” collection will be deployed.

step 10: Check your WSO2 WSAS instance using the URL https://localhost:9443. Login as administrator with user name “admin” and password “admin”

Step 11: Now navigate though services link in WSAS admin console (Services > echo > Try Web Service) . And try out the echo sample.

FinallyIf you have done the above steps correctly then you will be able to invoke all the WSO2 WSAS default services without any problem.You can find nice tutorial explaining WSAS URL-based repositories from here.

Open Source registry for SOA governance.

2008-07-01T05:27:00.000-07:00

WSO2 has announced their latest release of WSO2 Registry 1.1. Comparing to registry 1.0 release, the new release has lots of new features and performance improvements. So it has more enhanced support for SOA governance.

New features:

Performance improvements
Change from auto-versioning collections to explicit checkpointing
Lifecycle/Aspect support
Much improved WSDL handling, validation, and WS-I validation
Support for transaction handling
Generic typed associations
API improvements, including streamlined Filter/Handler plugins

WSO2 registry comes with a web based user interface, which is really user friendly and easy to use by technical or non technical people. The UI is based on web 2.0 look and feel. Newly implemented pagination support is cool feature which serve the users more faster. WSO2 ESB and WSO2 Mashup Server have embedded WSO2 Registry, so the registry is already used in production environments.