Explore Your Thought Process

EGL: Performance Optimization

2009-01-11T15:30:00.001+05:30

There are many factors which directly or indirectly affects the performance of EGL/Java Web Application. Performance tunning can be done at various ends. Mainly Application Level, Database Level and Server Level.

A few thoughts mentioned below:

Application level:
1) If you are displaying huge chunk of data in the UI (say more than 25 rows in a page) then programmatic pagination is must. That is segregate the resultset into different pages (may be 20-25 rows per page). And load data for each page on demand.
2) Give a look at the UI components for the page you are getting less performance and see if it can be simplified with lesser components. I know it is not easy and advisable to redesign at the point when delivery date is close.
3) You can use "Ajax" whenever and wherever possible. It will definitely increase the performance.
4) If you are using session variable make sure you remove it once it is done. DONOT wait till user logoff.
A topic of debate:
1) Hand written java code by professional is always better than generated java code. Hand written java code can always be fined tunned and pin-point using optimization tools like Optimizeit etc.
2) Now million dollar question (or may be some cents) is why jsf is defaulted to session scope and why not defaulted to request scope? How it is removed from the session on page transition? How and when the memory is reclaimed by JVM? As we all know we cannot force JVM to garbage collected.
Server Level:
It is one of the several important steps that needs to be performed in order to get maximum output. It is NOT very difficult and scary to make changes to server setting then sticking onto the default setting. Refer below links to get an insite of it http://www.ibm.com/developerworks/websphere/library/techarticles/0602_lurie/0602_lurie.html
http://whitepapers.techrepublic.com.com/abstract.aspx?docid=325396
http://rifers.org/blogs/gbevin/2005/4/21/get_rid_of_outofmemoryerror

Database Level:
This is under discussion and will be posted shortly.

Debate and discussions are always wel-come.

Regards
Monu

JSF: Displaying "Loading....Please Wait!" message during ajax call

2009-01-08T15:08:00.002+05:30

AJAX is becoming a specification in present day web application. Web 2 already infected and spread all across internet application. Web 3 is knocking at the doop step. more...

A very common requirement in ajax based web page is to convey the user that some server-side process is going on and the page/portion of the page is reloading. The best way to do this is displaying a suitable message like "Loading.....Please Wait!". Java Server Faces (JSF) is very impressive in implementing AJAX behavior in a page. It has provided well abstracted and easy to implement steps. Now coming back to message displaying use case; it requires just 4 additional changes:

Download a ajax activity image and store in images folder under WebContent folder. You can refer to this site to generate a gif image http://www.ajaxload.info/
Copy the below code anywhere in the page. Preferrably immediately after <body>
<div id="loading"><p>Loading... Please wait!</p><img src="${pageContext.request.contextPath}/images/activity.gif" /></div>
Add two javascript function as mentioned below:

<script language="JavaScript">function startProgressBar(){ document.all.loading.style.visibility="visible";}function stopProgressBar(){ document.all.loading.style.visibility="hidden";}</script>
Change the ajax tag in your jsf page
<hx:ajaxRefreshRequest target="ajaxGroup" onstart="startProgressBar()" oncomplete="stopProgressBar()" id="ajaxRefreshRequest1"></hx:ajaxRefreshRequest>

Regards

Monu

EGL: Customize error message.

2008-11-19T00:20:00.002+05:30

In EGL/JSF there is an api called Syslib.setError("errorMsg"). This api display the error message in the UI provided there is an error component available in the page. You can put that error component by dragging onto the page from enhanced faces component . So far so good.

Now if you want to display multiple message with a break in each line. For example you want to display following messages:

Warning: you have not entered street name.

Form has been saved.

Now if you want to display these lines in the same fashion as above you can not do that using setError function. It will display both the statement in the same line. Also if you want to set different colors for warning and success message you can not do.

Now how to accomplish this requirement. JSF provide one component called outputText. You can drag this component from Enhanced Faces component list. Then create a string variable in the JSF Handler and assign the variable as below:

multipleMsg String = "Warning: you have not entered street name
Form has been saved";

After that bind this multipleMsg variable to the outputText component in the jsp. Similarly you can also add color on to these texts.

Is not it cool

Regards

Monu

Defect Fixing: Be careful of bug fixing side effect

2008-11-16T19:03:00.000+05:30

Defect Fixing ! Hmm one of the terrible thing to developers life. This is the biggest challenge a developer can have during developement. A small defect can make months long hard work bitter. So developers be careful of that and vows yourself to find remedy to tackle this and make your developement life easy. From my experience I have list down some points which might help minimizing defect counts.

Prevention is better than cure: I think this is the single most important statement that minimize all problems. So what prevention should we take? How this statment is applicable to software development? Well the answer is straight forward follow best practices and coding standard.
Bug fixing side effect: Most deadly defects are the result of defect fixing. Some features remain untested after fixing a defect in some other feature assuming that the former is already tested before. That is why automation of test cases are highly desirable. Make sure irrespective of severity of the defect you run the entire test cases only again before delivery of code.
Time line: Make sure you keep enough time for testing your application.

Regards

Monu

myLot

2008-11-16T12:34:00.000+05:30

myLot User Profile

EGL: Edit page details while printing web page

2008-11-05T22:02:00.002+05:30

What you do when you want to print a web page? Answer is obvious; use window.print() event. What you do when you want to print a web page which requires formatting like removing some text, page break, modifying some content etc. just before sending to printer? Answer could be you will create one more page and make the changes required for printing with window.print() event on page load function. Then forward to this page on clicking print button. Is there any other better solution? Remember the original page could be the result of lot of business which need to take care even when you are forwarding to other page taking up printing responsibility.
Well in that case I would prefer to advise you to use javascript and css. This approach is not only fast but also easy and accurate.
Now how to do that. Well answer is right below:

Surround the portion with a div in the jsp page you want to print . Donot think about the changes now.

Call a javascript function say printPage(divPrintId). divPrintId is the id of the div.

Retrieve the entire text within the div as str=document.getElementById(divPrintId).innerHTML

Now do the business changes on the innerHTML text.

For page break you can create a javascript inside printPage javascript like below:
newwin.document.write('pageBreakDetails();\n')
newwin.document.write('function pageBreakDetails(){\n')
newwin.document.write('var details = document.getElementById("form1:tableId").style.pageBreakBefore="always";\n ')
newwin.document.write('}\n')

Let me know if someone finds any difficulty implementing this

Regards

Monu

Blogger: Resolve Common Error while placing ads in a blogger

2008-10-06T15:08:00.002+05:30

This article is little off-beat. However this is definitely useful for those who are newbie in the blogging world. Recently I have tried to display ad inside the article. For that I have made some changes in the template. After entering the ad code when try to save the template I have encountered different errors.

Open quote is expected for attribute "{1}" associated with an element type <elementType> : Check the template code and look for (say height). This will be something like height = 5. Now blogger will complaint the above error. The solution is simple just put 5 within single quote like height = '5'.
The reference to entity "<entity>" must end with the ';' delimiter. : Check the template code and look for (say ad_size). Usually this kind of error is found when we use & inside a url (say http: // example.com?a=1&ad_size=3). Now "&" has to be replaced with "&" to get rid of the problem.

Note: These problem errors are reference to blogger.com

Similar kinds of problem might occur because less than and greater than sign.

> should be replaced with >

"" should be replaced with "

Regards

Monu

JSF: Avoid both Pagination and vertical scrolling at the same time

2008-10-04T23:17:00.000+05:30

I have seen many applications (including one of my own application) use page pagination and vertical scrolling at the same time. This is a bad design at any curcumstances. Pagination is commonly used where application needs to display a huge chunk of data rows. It enhances page response and processing time. However sometime a page may have lot of other UI components which may allow a smaller portion of page area to display data row (may be atmost 10 rows). In such cases web designer go for vertical scrolling. Eventually this will force developer to think about implementing fixed header data column in a table.

From my perception, even though you are able to display only few rows of data in a table at one time; do NOT go for vertical scrolling. This will reduce page usability. If user agrees to have say 20 rows in a page they might agree for 10 rows if convinced properly.

JSF allows two types of pagination.

UI Pagination only: This is pagination in the UI only. No need to do any kind of code in the server. Just need to use pagination component in the web page using tooling.
Both UI and Server side Pagination: This is pagination both in the UI and in the server. You need to take care of previous, next and current set of rows that need to be displayed.

Very shortly I will explain these pagination technics with example along with vertical scrolling and fixed header problem.

Regards

Monu

EGL: Extract URL details

2008-10-02T16:05:00.002+05:30

This article helps Enterprise Generation Language (EGL) programmers to get the details about the server, port number and url type. Given below is a piece of dirty code (DONT COPY)

1) Create a Java Class like below:

package explore.your.thought.process
public class URLDetails {
public String getServer(String url) {
String replacedStr = getURLType(url);
String server = "";
String urlWithOutHTTP = url.replaceAll(replacedStr, "");
String[] strArr = urlWithOutHTTP.split("[:]");
if (strArr.length > 0)
server = strArr[0];
return server;
}
public String getServerPort(String url) {
String replacedStr = getURLType(url);
String serverPort = "";
String urlWithOutHTTP = url.replaceFirst(replacedStr, "");
String[] strArr = urlWithOutHTTP.split("[:]");
if (strArr.length > 1) {
String[] strArr1 = strArr[1].split("[/]");
if (strArr1.length > 0) {
serverPort = strArr1[0];
}
}
return serverPort;
}
public String getURLType(String url) {
String urlType = "";
if (url.indexOf("https://") != -1)
urlType = "https://";
else if (url.indexOf("http://") != -1)
urlType = "http://";
return urlType;
}
}

2) create an EGL External Type:

ExternalType URLDetails type JavaObject
{JavaName = "URLDetails", PackageName = "explore.your.thought.process"}
Function getServer(url String in) returns (String) ;
function getServerPort(url String in) returns (String);
Function getURLType(url String in) returns (String);
End

Regards

Monu

EGL: Converting string to int

2008-10-01T15:20:00.001+05:30

Enterprise Generation Language (EGL) is coming up great. It has provided a good many number of API's. However sometime we need to rely on Java api to do some small task. For example converting string to int or any other datatype conversion. There is nothing great in converting string to int in EGL. We just need to do something like below:

resultInt int = JavaLib.invoke("java.lang.Integer", "parseInt", "12345");

if we print resultInt obviously the result would be "12345". So far so good. Now try to change the string to "9999999999" and execute the program again. Output will be something like
For input string: "9999999999" and the execution will stop by then. What is the reason for this behavior? This is because we are NOT handling exception. Try below snippet:

try

resultInt int = JavaLib.invoke("java.lang.Integer", "parseInt", "12345");

onException (e AnyException)

//assign some value as per business

resultInt = -1;

end

Regards

Monu

How To: Minimize Defects and Rework during Software Development

2008-09-30T14:01:00.002+05:30

This article tries to analyse various factors injecting defects and how to minimize the defect ratio and amount of rework we do during a software/application development.

When we estimate effort and hours for a project we dont estimate the number of bugs or the amount of rework we will be addressing during the development. Actually this is a hidden factor which eventually determines the delivery timeframe. More time we spend in rework+bug fixing, more deviation from the project plan.

From various analysis it is concluded that high severity defects are uncovered during UAT (User Acceptance Test) when actually the user do the testing. It is very likely that those issues are related to the business of the application i.e. it could be the business rule which is NOT being captured or it is implemented wrongly. The impact of such a defect could be very immense which might lead to a huge rework never captured during planning of the project. Eventually this result in slipping the delivery date.

So who has introduced those defects ? Who should be blamed for this? Hmmm probably every one will blame one another.

From the past experience most of the defects are induced during requirement analysis and designing and it is uncovered in QA or UAT. On the other hand the developers are the main victims and has to go ahead fixing those with all the blames on their shoulders.

I have tried to list down some of the key points that could lead to a smooth project delivery. Those are as follows:

Project Estimation: During estimation project managers should keep enough allowable buffer to cope with any uncertain activities like rework and increased defect ratio from past experience. Update project plan whenever client aggrees on that.
Requirement Analysis: These phase introduced most of the defects and unfortunately uncovered most of them during UAT. So give enough time/hours during estimation to baseline this. Do not wait till UAT comes back with issue which may be too late. Especially when writing use case give utmost attension.
Review: Many times it is seen that clients are NOT very reluctant to review those documents. In that case if application fails to go to production both client and vendor is responsible. It is also seen that when everything got over including developement and testing client comes back seeking updation in the requirement document and so on and forth. So it is very important that client review any documents being sent for his approval should be correct and as per the expectation and on time.
Avoid blame game: An individual can be blamed and responsible for NOT meeting the delivery date. Everyone is equally responsible for any thing good or bad happen during the development. It is the process which could be blamed. Keep this experience as historical data and can be used as input in future projects estimation.

Regards

Monu

EGL: Sorting Datatable Columns

2008-09-27T13:24:00.000+05:30

There are many instances when we need to sort a particular column in a datatable. In this article I am trying to demonstrate one out of thousand options to sort a particular column in EGL.

Create a Java Class:
public class DatatableSorting {
public List sortAsc(List list) {
Collections.sort(list);
return list;
}
public List sortDesc(List list) {
Comparator comparator = Collections.reverseOrder();
Collections.sort(list, comparator);
return list;
}
}
Create EGL External Type:
ExternalType DatatableSorting type JavaObject
{JavaName = "DatatableSorting", PackageName = "explore.your.thought.process"}
function sortAsc(sortableArray String[] inout) returns (String[]);
function sortDesc(sortableArray String[] inout) returns (String[]);
End
Use DatatableSorting in EGL File:
program test type BasicProgram {}
function main()
sortableArray String[]{"A", "B", "1", "2"};
sortingDatatableCols DatatableSorting = new DatatableSorting ();
sortingDatatableCols.sortAsc(sortableArray);
sortingDatatableCols.sortDesc(sortableArray);
end
end

Note: If we notice carefully the java functions sortAsc and sortDesc accepts list as parameter and returns a list. However in out EGL it is actually String[]. This is because in EGL string[] will be generated to list in Java.

I will be writing one more article on sorting multiple columns based on reflection shortly.

Your comments are most welcome.

Regards

Monu

JSF: Handling onchange event with input mask

2008-09-11T10:53:00.000+05:30

Problem:
onchange event is NOT working when we use mask on a text field with Input Assistance enable in java server faces (jsf).

Example: Following jsp code sample will illustrate the problem.

onchange is very important if we want to see if a particular form is got changed.

Solution:
One possible solution is to use hidden variable which will hold the same value as the phone number field initially.
Any change in the value of phone number field will not affect the hidden field. That means hidden variable will hold the old value. Any difference between the two means the field got changed.
Example:

Best Practice : Use of Report in Java/j2ee

2008-09-10T22:42:00.000+05:30

Use of reporting tool like jasper, crystal, brit etc. is common in web application developed in java/j2ee or any other language. Now a days all reporting tool provide greater flexibility and comes out with lot many features. Performing certain business, displaying computed columns etc which is also possible through java. What I meant by that is for a given feature we may have two ways to perform either in Java or in Report. Now should we choose Java or Reporting tool to implement the same?
We should be little careful and should analyse which is the best way......
From my personal experience, I would go with Java to perform business rule or performing some computation instead of report.
In most reporting tool we have to first create the design file which will be translated to intermediate form like xml. Then this intermediate form will eventually converted to appropriate report form. Now if we choose reporting design file to perform computation or other business rule then sometime it would be difficult to make changes if any business rule got changed because it has to under above discussed translation. Also to modify the design file you require certain tool. For example if an application is running in production and require immediate modification then we can make the changes in Java and then redeploy into the server. It is also easy to maintain.

Regards
Monu

Software Development Methodologies: A Practical Approach

2008-08-30T13:58:00.015+05:30

In this article I would like to discuss about some of the most frequently used software development models. These are Waterfall model, Iterative Model and Agile Methodology. I have experience of working in all these models ; so like to share some of my view points. Before that let me quote you the definitions of those models.

Waterfall: Wikipedia defines waterfall model as

" A sequential software development model (a process for the creation of software) in which development is seen as flowing steadily downwards (like a waterfall) through the phases of requirements analysis, design, implementation, testing (validation), integration, and maintenance. "

Iterative: Wikipedia defines Iterative model as

" A cyclic software development process developed in response to the weaknesses of the waterfall model. It is an essential part of the Rational Unified Process, the Dynamic Systems Development Method, Extreme Programming and generally the agile software development frameworks. "

Agile: Wikipedia defines waterfall model as

" A group of software development methodologies that promotes development iterations, open collaboration, and process adaptability throughout the life-cycle of the project. It chooses to get things do things in small increments, with minimal
planning, rather than plan at length. This helps to minimize the overall risk,
and allows the project to adapt to changes more quickly. "

All the above methodologies are widely accepted. However these models has its own pros and cons.

The success of any software is mostly depend on the type of development model we select. Waterfall model is better suited for those softwares where requirements remain constant. If we expect requirement changes during the developement of the software, it is very difficult to inject those changes in water fall model. For example if the software is in UAT phase and demand some changes in the requirement then all artifacts need to change. Also overall risk in terms of cost, effort and time will scale up many folds. This may even lead to change in design which will eventually effect the developement phase.

Now how to deal with those sudden changes in the software with minimal cost and effort. Iterative and Agile models is targetting to solve these uncertainities with small time slice and minimal planning. Both iterative and agile model pass through entire software developement phase in each iteration. While in iterative model usually each iteration measured in months, agile model is measured in weeks.

Summary of these models:

Waterfall: No requirement changes

Iterative: Probability of Medium to less requirement changes

Agile: Requirement Changes

Regards

Monu

Power Builder to Web Application Migration

2008-08-12T12:04:00.000+05:30

Power builder is a client/server application development tool. It is relatively simpler to develop complex application with power builder. Due to easy to access web application and other reasons, companies are fast migrating to web application version using various languages like java/j2ee, php, .net so on and forth.

Re-platforming of power builder (PB) version of application to web application is NOT easy. Care has to be taken with proper design and prototyping. I have tried to list down a few points which might be helpful.

Single most important factor is designing. Designer has to understand the current features and implementation of the application. Also he/she has to be able to visualize the web application version and how to implement those features. Designer should try to keep user experience same as PB application. ALL SIMPLE POWER BUILDER features are actually complex when realizing in web application.
Prototyping is useful in visualizing the converted version of PB application. This is the best time to make changes as per client request. Also do not forget to take an approval from end user. Prototype is the best way to convey the user about the changes from PB. Also convinced them with simple to understand explanation.
Displaying list of records in the browser is the toughest job in migration project like this. PB can retrieve thousands of rows within a fraction of second while web application can not show these many records with same amount of time. Try to display minimum number of records with pagination. You may need to convince the user for that.
PB has an excellent and powerful concepts called data window. You can do anything and everything using Data Window. I doubt any programming language will have something like data window. So pay special attention to data window and extract all the properties pertaining to it. Take a close look at the sorting, column properties etc.
Finally compare the data being shown in both the version of application including default sort order, masking of fields, coloring etc.

I will be happy if readers can increase this list with there experience and skill. Comments are welcome.

Regards
Monu

How to resume ssh after installing IBM RBDe 7.1 in Linux OS

2008-08-05T14:32:00.001+05:30

Recently I have installed IBM RBDe 7.1 in Linux OS. It has installed and running successfully. However remote connection to the linux system STOP working. Usually we use Secure Shell (ssh) to connect from windows/other os to connect to Linux machine. ssh uses port 22 by default. When I installed RBDe 7.1 I was unable to connect to Linux from windows through ssh. This is probably because while installing RBDe it set some rules or some other manipulation to iptables. To resume remote connection, open a terminal in Linux then enter the command iptables -F.

From man iptables:
iptables - administration tool for IPv4 packet filtering and NAT
-F, --flush [chain]
Flush the selected chain (all the chains in the table if none is given). This is equivalent to deleting all the rules one by one.

How to resolve problem with X11GraphicsEnvironment in unix

2008-07-24T15:37:00.000+05:30

Are you planning to display report or graphics in web application running in unix operating system? Are you getting error similar to below error?

java.lang.InternalError: Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable. at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method) at sun.awt.X11GraphicsEnvironment.(X11GraphicsEnvironment.java:175)

This error is very common in unix with NO X environment. Here, I am trying to give couple of troubleshooting steps. Those are as follows:

Set up headless mode: To set up headless mode, set the appropriate system property by using the setProperty() method. This method enables you to set the desired value for the system property that is indicated by the specific key.
System.setProperty("java.awt.headless", "true");
Set Java Environment Variable: Djava.awt.headless=true
In JVM Process Definition of WAS, we need to create variable DISPLAYwith port # on which X11 is running, the Value field (default is:0.0).
example :
DISPLAY=0.0
X11 server is running: If running please note the port number by issuing following command
ps -ef egrep X11
Setting the DISPLAY variable using script or in cell by issuing,setenv DISPLAY=:0.0 export DISPLAY
Use the xhost + command to make this variable to global scope with above

Follow above steps one at a time and carry a test.

Regards

Monu

Implementation of SaveAs functionality in JSP as well as Servlet

2008-07-23T17:49:00.000+05:30

Implementing SaveAs functionality in java/j2ee may not be a big deal. However for developers like me it is sounding difficult.
Every complex problem has a simple solution - atleast I believe that.
For those folks who found implementing SaveAs functionality in web application is difficult, this article will crack it.

Description: Implementing save as functionality in jsp as well as using servlet.
Assumptions: I assume that content of the file is already generated or file is generated in the server. Also assumes that we know the file type. Now browser should ask the user to save the file in desired location or open the file in appropriate editor.

Implementation in JSP:
FileType: excel
Code: response.setContentType("application/vnd.ms-excel")
FileType: pdf
Code: response.setContentType("application/pdf")
FileType: text
Code: response.setContentType("text/plain")
FileType: csv
Code: response.setContentType("application/octet-stream")
FileType: csv
Code: response.setContentType("application/octet-stream")
Additionally you can use following statement which will set the filename
response.setHeader ("Content-Disposition", "attachment;filename=\""+ fileName +"\"");

Implementation in Servlet: In servlet you can do something like below:
//set the content type based on file type
if(fileType.equalsIgnoreCase("PDF")){
response.setContentType ("application/pdf");
}
if(fileType.equalsIgnoreCase("TEXT")){
response.setContentType ("text/plain");
}
if(fileType.equalsIgnoreCase("CSV")){
response.setContentType ("application/octet-stream");
}
//set the file name
response.setHeader ("Content-Disposition", "attachment;filename=\""+ fileName +"\"");
//get the file content

File file = new File(filePath);
// Create the byte array to hold the data
byte[] bytes = null;
InputStream is;
try {
is = new FileInputStream(file);
// Get the size of the file
long length = file.length();
// You cannot create an array using a long type.
// It needs to be an int type.
// Before converting to an int type, check
// to ensure that file is not larger than Integer.MAX_VALUE.
if (length > Integer.MAX_VALUE) {
// File is too large
}
bytes = new byte[(int)length];
// Read in the bytes
int offset = 0;
int numRead = 0;
while (offset < numread="is.read(bytes,">= 0) {
offset += numRead;
}
// Ensure all the bytes have been read in
if (offset <>
response.setContentLength(bytes.length);
response.getOutputStream().write(bytes);
response.getOutputStream().close();

Common Mistake: I have seen developers try to write the file content into response object inside jsp which is illegal because server is already finished writing onto the response.

Regards
Monu

EGL: Handling session timeout

2008-07-16T11:51:00.001+05:30

Session Handling is one of the most important task in web application. Same is true for EGL generated Java/j2ee code. In this article we will discuss about session handling in EGL targetting to Java/J2ee code. Also we will see how to deal with the scenerio when user tries to access the application pages without login.

Use Case:
1) When session expires, if the user clicks any of the link/buttons in the application, the application should log out and take the user to login page

2) When user enter the url of a page directly in the brower without validating itself, it should take you to login page.

One possible approach:

For session handling to work firstly we have to make an entry in the web.xml as session-timeout set to integer variable greater than 0.

In the application we should have a template. This template will be used by all the pages in the application except for login page. In general template is used to get a consistent look and feel through out the application. It may have header, footer, menus and so on. That means before loading individual pages it will first load template. So we have to write the session handling code in the template.

Sample code snippet:
You can do something like below in onConstructor

if(userId == null StrLib.clip(userId) == "")
urlPath string = urlType+server+":"+serverPort+contextPath;
//clear all session attributes
J2EELib.clearEGLSessionAttrs();
forward to url urlPath;
end

This way we can achieve the use case 2.

Regards
Monu

5 Key Points Resolving Application Issues in Production

2008-06-21T10:43:00.002+05:30

No software is bug free. Even time critical application may fail at some or other point of time. There are many instances when a particular application running in production fail.

That is why care should be taken when deploying application in production when application is ready to use by end user. I have shortlist 5 key points deal with those issues.

Maintaining Log File: Always maintain a log file to track the activities of user in production. If a issue arise in the application, first look into the log file and try to analyse the problem. So make sure your log file capture all critical application scenerio in the log file.
Sit with the user to understand the issue: If the log file does not help in finding the issue, sit with the client/user to understand the issue. Record the steps user is performing so that you yourself can reproduce the issue later.
Reproduction of issue in development environment: By following recorded steps try to reproduce the issue in development environment. This is a very important step and has to happen. Once reproduced the issue can be resolved very easily.
Creating duplicate environment in Production (if applicable): If issue can not be reproduced in development environment, then there is a serious problem. Try to create a duplicate environment in production if user allows to do that. Then fix the issue in production.
Run automated test cases: After fixing the issue either in production or development run your automated test cases to make sure that application is running fine and there is no side effect due to issue fix

Regards

Monu

Process of Knowledge Transfer : Part Three

2008-06-18T23:22:00.003+05:30

In continuation with Process of Knowledge Transfer : Part Two we will discuss about various methods of Knowledge Transfer.

Methods of Knowledge Transfer

The employee who is giving KT should aware of some basic KT methods which accelerate the handover process.
Following some or all below methods helps greatly:
i) Preparation of Documents: There should be some project related documents like requirement specs and/or technical specs and/or manuals or any other project related documents. These documents should be distributed to the employees who is (are) taking the KT. These documents give a feel of the project.
ii) Preparation of presentation: Distribution of project related presentation also helps in handover process.
iii) Identification of key flows: The employee who is giving KT should prepare certain key flows of the project/application. Number of key flows should depend on the complexity of the project. Key flows should be high level design breaking of which will break the system. Key flows should not be too fine grain. In a small size project key flows may vary from 5 to 10 flows. After identifying the key flows it should be explained to the employee who is (are) taking the KT.
iv) Debugging of the project: Debugging is the best way to know the sequence of events happening inside the project. Pick one key flow at a time and allow the developers to drill down.
v) Testing the application: Presented the developers with the test cases and allow them to test the application.
vi) Identification of critical and common defect: If the project is in support and maintenance phase, it would definitely encountered certain critical and common defect during the course. Identify those defects and presented to the employee who is taking KT. Analyze those defects and provide some tactics to find the possible solution.
vii) Workshop of defect analysis and fix: There should be a workshop in which all critical and similar defects should be presented to the developer and allow them to analyze the defect and come out with probable fix.
viii) Workshop to correct the breaking system: Break the application by commenting out certain lines of codes and allow developers to correct the system.
ix) Real time defect fix: During the process of KT, last task could be give opportunities to analyze the incoming simple defect to developers and also allow them fix those.

The discussed Knowledge Transfer framework should NOT considered as a burden or rigid structure. Rather it is a process which can be taken as base upon which every one will follow a common path for the common goal. It can be modified and enhanced to become a mature framework. Implementer should understand the importance of knowledge transfer and management should understand the time required to accomplish these activities.

Regards
Monu

Process of Knowledge Transfer : Part Two

2008-06-18T23:12:00.005+05:30

In continuation with Process of Knowledge Transfer : Part One we will discuss about various factors affecting Knowledge Transfer.

Factors Affecting Knowledge Transfer
To ensure an orderly transition of responsibilities we need to define a process. Let us discuss the various process oriented mechanism that help us achieving smooth knowledge transfer. There are various factors that affect the knowledge transfer process. The below mentioned factors are valid for both form of knowledge transfer i.e. for employee who is moving out of the project to other project and for employee who is leaving the organization.

1) Awareness: This is very crucial factor as the person who is taking the knowledge transfer has to understand the importance of his involvement. Project leader or mentor or project manager (or any one whom the developer is reporting to) has to motivate the developer to prepare themselves with a positive note. Developers should be advised to ask tons of questions about the project. Developers and the person who is giving the knowledge transfer should not follow any shortcut learning. Communicate to the team that person “A” is leaving and that person “B” is replacing.

2) Preparation of Handover Plan: Planning is important for any successful task. Similarly handing over the responsibility has to be carried out in a planned manner so that the task can be accomplished more affectively and efficiently. The employee who is giving the KT should prepare the handover plan in case the employee is moving out of the project and the NOT the organization. In the case of employee who is leaving the organization should prepare the handover plan together with another team member (can be team leader or manager) who is aware of the project. While creating the plan the employee has to put himself into the shoe of the developer who does not know anything about the project. Time is an important factor to accomplish these tasks. The organization has to sort out the time factor.

3) Review of Handover Plan: Review of the handover plan has to be carried out. It has to approve by concern authority. This is very important as the person who is leaving the organization will not be available for further help. So it has to make sure that the handover plan is complete and provide enough information for the developer to know insight of the project.

4) Timeframe: How long handover will continue? How much time does the developer requires contributing towards the project activities? The concern authority has to discuss with both the employees (one who is giving KT and who is (are) taking KT) to come out with the timeframe. Again this can be little flexible for the employee who is moving out of the project and NOT the organization because he/she will be available even after KT. But for the employee who is leaving the organization, the authority has to decide it cautiously. Depending on the complexity of the project timeframe will vary.

5)Weekly Meeting on Status and progress of KT: Activity or task tracking helps the organization to see if the realization of the plan is happening as schedule or any diversion. This can be achieved by weekly meeting on status and progress report. The concern authority should discuss with the developer to see how comfortable he/she is becoming with the project.

In part Three, we will discuss about Methods of Knowledge Transfer

Regards
Monu

Process of Knowledge Transfer : Part One

2008-06-18T22:53:00.004+05:30

Knowledge transfer is the process of transferring knowledge from one individual to another by means of mentoring, training, documentation, and other means. It is an important aspect of project management and life cycle. It is not uncommon practice to transfer information from one person to another during a project life cycle. Lack of proper knowledge transfer may lead the project to instable position. Those projects which are already in production may need special attention because different people contribute to the project at different time.

Process oriented knowledge transfer is an integral part any organization. There are typically two scenarios when knowledge transfer has to happen during the life of a particular project.

Firstly, when an existing employee moves out of the project and take up some new roles and responsibility. Success of any project depends on the methodology or process it flows during the life of the project. It follows a defined life cycle and process. Likewise accomplishment of a particular project, movement among employee is desirable for the betterment of the organization. At certain point of time developer has to step up to take the responsibility of a designer, designer has to take up the responsibility of architect. Similarly sooner or later project leader has to become project manager. In order to achieve these, people move in and out of project at regular interval. It is therefore desirable and responsibility of the employee to do knowledge transfer so that internal movement does not affect the project activities and client expectation.

Secondly, when an employee leaves the company, proper knowledge transfer become very crucial. This is because he/she won’t be available to provide any further assistance.
In Part Two, we will discuss about various factors affecting knowledge transfer.

Regards
Monu

A Topic of Debate : Web 1.0 vs Web 2.0 vs Web 3.0

2008-05-26T15:40:00.000+05:30

Firstly I would like to quote the definitions of these terminologies from Wikipedia :

" Web 1.0 refers to the state of the World Wide Web, and website design style before the Web 2.0 craze, and included most websites in the period between 1994 and 2004. It is important to note that "Web 1.0" is a retronym. That is to say that
it has been retroactively named only after the introduction of the term "Web 2.0", and has very loosely defined boundaries. For the most part websites were a strictly one-way published media, similar to the Gopher protocol that came before it. "
" Web 2.0 is a term describing the trend in the use of World Wide Web technology and web design that aims to enhance creativity, information sharing, and, most notably, collaboration among users. These concepts have led to the development and evolution of web-based communities and hosted services, such as social-networking sites, wikis, blogs, and folksonomies. "

" Web 3.0 is a term used to describe the future of the World Wide Web. Following
the introduction of the phrase "Web 2.0" as a description of the recent evolution of the Web, many technologists, journalists, and industry leaders have used the term "Web 3.0" to hypothesize about a future wave of Internet innovation. "

From above definitions it is really difficult to find a given web application should call as Web 1.0 or Web 2.0. However it is certain that any web application is Web 1.0 compatibility but which application is to call Web 2.0 is a matter of debate. There is no specification which independently certifies a given web application as Web 2.0 compatibility. People thinks any application which has ajax capability or where users can upload pictures, display them, and modify as in when required or all colorful designs with 3D shades is to be called as Web 2. All these features were pretty much available in sites developed before the term "Web 2.0" was coined.

First of all we have to come up with specification which defines the boundaries of Web 2.0. Otherwise the actual meaning of the term will go in vein and left out with just a technical jargon to represent a complex, multi-feature web application.

When people around the world struggling to understand the meaning and semantics of Web 2.0, there is one more terminology revolving around us as Web 3.0 which is looking as the future course of web application. It is always good to look at the future and set up certain milestone. But at the same time we have to benchmark the current stand and move ahead.

Readers are requested to provide comments which help us to understand the underlying meaning of these jargons.

Regards

Monu

EGL: Handling dynamic schema

2008-05-18T22:23:00.010+05:30

There are different ways to handle dynamic schema in EGL. One of the very common approach is to get the schema from the jvm properties in egl handler and store it in the session and set it in a record "StatusRec" and pass to the data access layer as argument. For more details on this you can refer to http://64.233.183.104/search?q=cache:YfYe-ju-9dUJ:www.jsayles.com/ibm/TableNamesVariable.doc+EGL+StatusREc&hl=en&ct=clnk&cd=1" Below statement is quoted from this link
"You must then set the schema name in each function prior to running the EGL I/O statement. It is assumed that the schema will be a programmatically determined value and would be stored in session. Therefore, this example assumes the schema has been set in a jsfHandler by reading the data out of the session and passing it through the record StatusRecord (or status as generated by the data Access Application Wizard). The reason this record is used is that all functions created using the wizard include the status record in the pass parameters"-Mark Evans, Rational – EGL Development, IBM Software Group.
However I feel there is a overhead in this approach that is each time you want to make a database call you need to get the schema from the session and populate the schema variable in statusRec and then send it from egl handler to data layer. The overhead in this approach is you have to pass one extra record as parameter every time you make a call.There is another solution for reading the schema in data layer itself without passing schema name from handler every time. Create a library which will probably have two methods setDatabaseNameSchema and getDatabaseNameSchema. Get method will read the jvm properties and return to data layer. Set can be used to set the schema from anywhere. Set is useful when you are performing unit testing when your server is not ON.

EGL: Integrating Jasper Report

2008-05-16T11:17:00.001+05:30

This section describes how to integrate the Jasper reports to the Enterprise Generation Language EGL Web application.

Required library files:-
1) The following jar files need to be included in the Web-INF – lib
a. Jasper-Reports 2.0.5.jar
b. iText.jar – for PDF format to be output.

Steps for integration of Jasper file into the application:-
1) The jasper file generated earlier has to be included in the Java resource folder of the application.
2) Create an array for holding the data of the report.
3) Export the report using the “Report” and “Report Data” object.

Initialize the report data object:-
a. Data – assign the report data array to the data property of the report data object.

Initialize the following properties of the report object:-
a. reportDesignFile – Path of the jasper file(.jasper file).
b. reportDestinationFile – Path of the temporary report file (.jrprint file).
c. reportData – assign the report data object to this property.
d. reportExportFile – Name of the file to which the report has to be exported.

Call ReportLib functions:-
a. FillReport method – send the report object and Datasource.reportData as parameters to this method.
b. exportReport method – send the report object and the export format as parameters to this method. Available export formats are - “html”, “pdf”,”text”,”csv”,”xml”.

Code Snippet:-
//report object

report Report = new Report();
//report data object
reportData ReportData = new ReportData();
//jasper file location
report.reportDesignFile = jasperLocation;
//temp file location
report.reportDestinationFile = reportFileLocation + exportFileName + ".jrprint";
//assign data array to report data object
reportData.data = <>;
//assign data to report
report.reportData = reportData;
//complete report file location
filePathName string = reportFileLocation + reportFileName;
//assign the export file name
report.reportExportFile = filePathName;
//fill the report
ReportLib.fillReport(report, DataSource.reportData);
//Export report to the required formatReportLib.exportReport(report, ExportFormat.html);

Monu

EGL: Handling DB2 sqlcode:-904

2008-04-14T02:36:00.002+05:30

Recently I have come across an sql error while trying to execute a sql in DB2 version 7 from web application. The application is developed in Enterprise Generation Language (EGL). The query retrieves huge result set of around 14000 rows. The sql error reads as "UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000302, AND RESOURCE NAME ....[sqlstate:57011][sqlcode:-904]". However the same sql is executed successfully from DB2 SQL client.

After lot of R&D, we tried to set isolation level in the SQL. By default db2 is set to Repeatable Read (RR) level. We have changed this level to Uncommitted Read (UR). Great it works.

Example

Select * from Emp order by empName WITH UR;

Regards

Monu

Earn Money Online

2008-04-04T00:07:00.007+05:30

Now you can increase your revenue by taking part in online free surveys. At this recession period when everyone wants to save each cent they earn; people are looking for alternative ways to increase their revenue. And that's the demand of the situation. This information is to share with you guys that online surveys are of the easiest way in this regard. I have tried couple of such organization who offers online surveys. A few shortlisted organizations are listed below (use the link to join). REMEMBER YOU CAN JOIN ALL THESE ORGANIZATIONS AT FREE OF COST.

Opinion India : Join Now
Ciao-Survey : Join Now
Spidermetrix:
Spidermetrix is an Australia based website which pays you to participate in paid surveys, polls and to evaluate websites. There are also short single question surveys on the site where you earn one point. Sometimes they send well paying surveys to Indian members. Members are called spiders and they earn spider points as rewards. They also give you rewards for referring friends. Payment is by paypal when your account balance reaches the equivalent of $20. Join Spidermetrix here
Planet Pulse:

Get paid for your opinions! Click on the banner above to join Planet Pulse. Its totally free to sign up, and you can earn UNLIMITED. Find out more by visiting PLANET PULSE.
Survey Savvy:
Global Test Market:

Articles

2008-03-05T09:50:00.003+05:30

A) Enterprise Generation Language, EGL

EGL: Sorting Datatable Columns - In this article I am trying to demonstrate one out of thousand options to sort a particular column in EGL. more..

EGL: Extract URL Details - This article helps Enterprise Generation Language (EGL) programmers to get the details about the server, port number and url type. more..

EGL Converting String to int - Enterprise Generation Language (EGL) is coming up great. It has provided a good many number of API's. However sometime we need to rely on Java api to do some small task. more..

EGL: Handling session timeout - Session Handling is one of the most important task in web application. Same is true for EGL generated Java/j2ee code. In this article we will discuss about session handling in EGL targetting to Java/J2ee code. more..

EGL: Handling dynamic schema - There are different ways to handle dynamic schema in EGL. One of the very common approach is to get the schema from the jvm properties in egl handler and store it in the session and set it in a record "StatusRec" and pass to the data access layer as argument. more..

EGL: Integrating Jasper Report - This section describes how to integrate the Jasper reports to the Enterprise Generation Language EGL Web application. more..

EGL: Handling DB2 sqlcode:-904 - Recently I have come across an sql error while trying to execute a sql in DB2 version 7 from web application. The application is developed in Enterprise Generation Language (EGL). more..

EGL: Do we need to learn IBM Enterprise Generation Language ( IBM EGL ) ? Another 4GL or something more? - Recently i have come across a new or not so new programming language IBM's Enterprise Generation Language EGL. more..

About Me

2008-03-01T00:39:00.002+05:30

'I' is the most selfish word in the dictionary. However there is no better place then in this article to use the word 'I'. Explore Your Thought Process is not just a blog, it's like a dream come true. It is a platform where I can reach out to tech savy, share technical thoughts and can help others. Probably this is the only way I can help others.

I have started my career as Geologist. During the course of sedimentation this geologiest who deals with rocks and earth science become a computer professional. Now I am enjoying being called as software professional.

Display Name: Monu
Full Name: Monuranjan Borgohain
Email: monudjn@gmail.com
Gender: Male
Birthday: 01-05-1978
Location: Bangalore, Karnataka, India
Work: Software Professional
Interests: Writing articles, Music, Playing Guitare, Reading books etc.

Favorite Site

2008-02-05T13:55:00.000+05:30

Home URL

GalaxE Solutions

Google

YouTube

Google Analytics

Google WebMasters

Gmail

Yahoo

Internet: Configure wireless router to Reliance Broadband connection

2008-02-01T00:01:00.001+05:30

Recently i have taken reliance broadband connection and i wanted to configure a wireless router to connect to internet. After looking at different routers from different vendors, i have finally decided to go for NETGEAR WGR614v7. When i called reliance customer care for assisstence in configuring the router, i didn't get any help. Then i decided to configure myself by following the user manual comes with the router. However i have found it very difficult. The router was not getting the ip address of ISP dynamically.
With lot of experiment finally i have made router to talk to internet.
If someone stuck in configuring the netgear router with reliance broadband can follow the below steps:
1) Follow the exact procedure mentioned in the manual. Set up will guide to configure the router. Donot follow the manual process.
2) First time do the setup with the wire that will connect the router and the laptop/desktop.
3) If the router doesnot find the dynamic ip address, switch off the modem, wait for 1 mins, switch on the router, wait for 1min and then restart your pc.
4) If atleast once you done your setting correctly then take a back up of the setting. This is very useful if you lose your setting later on, you can get it back by using the back up file.
5) Without removing the wire between the pc and the router, enable/create your wireless device in the pc to locate the router. Then you remove the wire.
6) If your router not finding the ip address, then disconnect the router from modem.
Connect your pc directly to the modem and see if you are getting the ip address automatically.
If not then go to properties of LAN and then click on "use the following ip address" radio button and enter 192.168.1.2 followed by tab. Sub net mask will get filled with 255.255.255.0 .
Go to command prompt and try to ping the entered ip address. If it is pinging then go back to LAN properties and select "obtain an ip address automatically" radio button. Wait for sometime and then go to command prompt and type ipconfig/all, it gives dynamic ip address along with name of the ISP. Then you can connect to internet directly using your modem. After connect the wire from modem to router and allow your pc to connect to router and router will connect to modem

Let me know for any issue or further clarification in configuring the netgear router with reliance broadnet

Regards
Monu

EGL: Do we need to learn IBM Enterprise Generation Language ( IBM EGL ) ? Another 4GL or something more?

2008-01-01T00:55:00.001+05:30

Recently i have come across a new or not so new programming language IBM's Enterprise Generation Language EGL. Browsing through some of the articles and tutorials in the net, i came to know that it's a new 4GL which can generate java and cobol code. It's a programming language which let us writing full functions applications. As i said it's a new language it has its own syntax and learning curve. However IBM claims it's easy to learn compare to Java. When i look into the syntax of EGL, it has remind me COBOL which i have studied during my engineering. IBM RAD can be used to develop EGL application. EGL can be used to develop web application which will eventually be converted into java code. EGL contains programs and libraries to create your bussiness and data layer. It has page handlers and jsp's to create presentation layer.

EGL tries to bridge between procedural and Object oriented programmer. It claims that procdural programmers and 4GL developers can develope java web application in EGL with or little knowledge of Java.

However as a java/j2ee/php developer i have certain concerns whether to accept EGL or not.

I would appreciate if someone (EGL experts) to answer below questions. Also request all you readers to continue this discussion which might help someone to choose among EGL,php,java and so on and forth.

Question1: As EGL says a procedural programmer need not to know Object oriented programming. Do they really need not to learn OO ?

Question2: How can we trust EGL, when most of the 4GL are out of market and in the process of migrating to x,y,z technology?

Question3: EGL programmer's need not to know Java/j2ee... However there many best to be proven framework/design pattern in java/j2ee/php. How one will implement these patterns wihout knowing those?

Question4: How about maintainability, scalability, performance, extendibility, reliability and security compare to hand written program in java?

There are many more questions which EGL has to answer before it goes big.

I think we should not have any problem accepting a new language/technology which is better than current trend of technlogy. However it cannot claim global audience if it is just better than some of out of market trend technologies

Regard

Monu