Expert status in experts exchange

e

Now i have got 50,066 points at experts-exchange. They have given me a Master grade

#1

#2

#3

Questions Answered

Articles Written

Overall Points

Earned master status in experts-exchange.
Also a 50,566 points

The stored procedure expects a parameter error

When executing your stored procedures through Sybase ace driver, you may get an error the stored procedure expects as a parameter even your passing the parameters
Ex getEmployes
assgin parameters to command
execute the command.
you may get an error saying no parameters found for the stored procedure
To resolve this error
you need to assign stored procedure as getEmployees ?,?,? (No of parameters that stored procedure takes)

Installing sharepoint 2010 in Amazon cloud

I have installed sharepoint 2010 on Amazon cloud. Working on cloud was wonderful experience.I have taken windows 2008 server with sql server 2008 already installed on it. With sql server 2008 the config wizard was givining no memory in internal pool.So i have downloaded the setup for sql server Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) .The configuaration went fine.

Executable UML

Executable UML is a different approach rather than standard UML process.
and is the evolution of the Shlaer-Mellor method[3] to UML
The executable UML consists of

Domain Chart
Class Diagram
Statechart diagram
Action language
Model testing and execution
Model compliation

Using executable UML we can model Platform independent systems. We can verify the system wheather it achieves the specified goals or not.

XMLHTTPRequest Object accessing web service

Hi
I just browing thorugh the xmlhttpobject and trying to call web service.I am posting the code the here. It calls the holiday web service GetHolidaysAvailable method which calls the method Synchronously.
The following is code

function GetSynchronousJSONResponse() {
var xmlhttp = null;
if (window.XMLHttpRequest)
xmlhttp = new XMLHttpRequest();
else if (window.ActiveXObject) {
if (new ActiveXObject("Microsoft.XMLHTTP"))
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
else
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
}
// to be ensure non-cached version of response
//url = url + "?rnd=" + Math.random();
url="http://www.holidaywebservice.com/Holidays/US/USHolidayService.asmx/GetHolidaysAvailable";
// xmlhttp.setRequestHeader("SOAPAction", "http://www.holidaywebservice.com/Holidays/US/USHolidayService.asmx/GetHolidaysAvailable");
xmlhttp.open("POST", url, false);//false means synchronous




//xmlhttp.setRequestHeader("Content-Type", "application/json; charset=utf-8");
xmlhttp.send();
//xmlhttp.send("action="+"null");
var responseText = xmlhttp.responseText;
alert(responseText);
return responseText;
}

This is one of learnings with XMLHTTPRequest object. Hope you find it useful

Dell studio 1535 and Yahoo messager problem

I experienced problem with yahoo messenger and Dell studio 1535. When you install yahoo IM all your sound drivers will be jamed. If you face this problem,uninstall the version you have have then you need to install Yahoo messenger 9.0 Beta. Then your sound drivers will work.

Current configuration contains errors that are not corrected by the requested operation Error

When running IBM rational product or Websphere inupdates you may get the following error

Current configuration contains errors that are not corrected by the requested operation and more errors would be introduced

You can solve this problem by using procedure

I came across this error i solved this way

Go to the directory where your product is installed
updater\eclipse\rpu.exe -init -nosplash
type: updater\eclipse\rpu.exe # then proceed as usual.
This is given in IBM site

rpu is rational product updater

Documentum 6 new features

Hi,
I have been working on documentum for quite a long time. I have worked on documentum 5.3. Which used web services. Now Documentum 6.0 has support for SOA.
The following are features.
retrieving, updating, and deleting repository objects. Copy and move operations are also available.
Version Control Service: provides operations such as checkin and checkout that concern object versions.
Query Service: provides operations for obtaining data from repositories using ad-hoc queries.
Schema Service: provides operations for examining repository metadata (data dictionary).
Search Service: provides operations concerning full-text and property-based repository searches.
Workflow Service: provides operations that obtain data about workflow process templates and an operation for starting a workflow process instance.

This article is by pawan kumar which came in CMS Wire.
It can found at http://www.cmswire.com/cms/enterprise-cms/documentum-6-d6-and-your-services-oriented-architecture-soa-001846.php

Abstract Factory Applicable Scenarios and

Abstract Factory Applicable Scenarios
The system needs to be independent of how its objects are created,composed, and represented.The system needs to be configured with one of a multiple family of objectsThe family of related objects is intended to be used together and thisconstraint needs to be enforced.You want to provide a library of objects that does not show implementationsand only reveals interfaces
J2EE Technology Features and J2SE API Association
Data Access Object (Sun)Value Object Assembler (Sun)Builder Applicable senarios
The algorithm for creating a complex object needs to be independent of thecomponents that compose the object and how they are assembled. The construction process is to allow different representations of theconstructed object.
javax.ejb.EJBHome javax.ejb.EJBLocalHome javax.jms.QueueConnectionFactory javax.jms.TopicConnectionFactory
CompositeThe following scenarios are most appropriate for theComposite pattern:¦ You want to represent a full or partial hierarchy of objects.¦ You want clients to be able to ignore the differences between the varyingobjects in the hierarchy.¦ The structure is dynamic and can have any level of complexity: for example,using the Composite view from the J2EE Patterns Catalog, which is usefulfor portal applications.
Decorator Applicable Scenarios
You want to transparently and dynamically add responsibilities to objectswithout affecting other objects.¦ You want to add responsibilities to an object that you may want to change inthe future.¦ Extending functionality by subclassing is no longer practical

Nice article on entity framework.

Nice article on entity framework.

What is entity framework

Teams build software, not developers. Different members of a team think of data differently. For example:
Developers think in class diagrams
Analysts think in OR diagrams
DBAs think in ER diagrams

Is There a Solution?
At the core of the Entity Framework is an Entity Data Model (EDM). The EDM is meant to be the common grammar in which different fiefdoms. The EDM defines a language for describing data without having to describe the storage of that data. On top of the EDM is a set of services that work to enable manipulation of the data in beneficial ways throughout an organization

This is a nice article on server side.com.Follow the link.

http://www.theserverside.net/tt/articles/showarticle.tss?id=IntroducingEntityFramework

Adapter Variations

//: adapter:AdapterVariations.java
// Variations on the Adapter pattern.
package adapter;
import junit.framework.*;

class WhatIHave {
public void g() {}
public void h() {}
}

interface WhatIWant {
void f();
}

class SurrogateAdapter implements WhatIWant {
WhatIHave whatIHave;
public SurrogateAdapter(WhatIHave wih) {
whatIHave = wih;
}
public void f() {
// Implement behavior using
// methods in WhatIHave:
whatIHave.g();
whatIHave.h();
}
}

class WhatIUse {
public void op(WhatIWant wiw) {
wiw.f();
}
}

// Approach 2: build adapter use into op():
class WhatIUse2 extends WhatIUse {
public void op(WhatIHave wih) {
new SurrogateAdapter(wih).f();
}
}

// Approach 3: build adapter into WhatIHave:
class WhatIHave2 extends WhatIHave
implements WhatIWant {
public void f() {
g();
h();
}
}

// Approach 4: use an inner class:
class WhatIHave3 extends WhatIHave {
private class InnerAdapter implements WhatIWant{
public void f() {
g();
h();
}
}
public WhatIWant whatIWant() {
return new InnerAdapter();
}
}

public class AdapterVariations extends TestCase {
WhatIUse whatIUse = new WhatIUse();
WhatIHave whatIHave = new WhatIHave();
WhatIWant adapt= new SurrogateAdapter(whatIHave);
WhatIUse2 whatIUse2 = new WhatIUse2();
WhatIHave2 whatIHave2 = new WhatIHave2();
WhatIHave3 whatIHave3 = new WhatIHave3();
public void test() {
whatIUse.op(adapt);
// Approach 2:
whatIUse2.op(whatIHave);
// Approach 3:
whatIUse.op(whatIHave2);
// Approach 4:
whatIUse.op(whatIHave3.whatIWant());
}
public static void main(String args[]) {
junit.textui.TestRunner.run(AdapterVariations.class);
}
} ///:~

Design Pattern -Builder Pattern

The builder Pattren intent is to Seperate the construction of a complex object from its representation so that the same construction process can create different objects.The builder pattren is useful when several kinds of complex objects.The Builder parttern is useful when several kinds of complex objects with similar rules for assembly need to joined at runtime but results in different object types.It achives this seperating the process of building the object from itsellf.t

The builder pattern creates complex objects in multiple steps instead of in single step as in other patterns.

Benefits

It permits you to vary an objects internal's internal representation.

It insolates the code for construction and representation

It provides finer control over the construction process.

GOF Creational pattern - Abstract Factory

More than Factory – allows creation of class families
Go to Sears and order a kitchen make-over. Same order request process can yield very different kitchen drawers, doors and hardware
Provide an interface for creating families of related or dependent objects without specifying their concrete classes

The abstract factory's intent is to provide an interface to use for creating families of related or dependent or dependent objects without actually specifying their concrete classes. For a given set of related abstract classes, this pattern supplies a technique for creating instances of those abstract classes from an equivalent set of concrete subclasses. On some occasions, you may need to create an object without having to know which concrete subclass of object to create.

The abstract factory pattern is also know as Kit.

Benefits

It isolates client from concrete classes.

It eases the exchanging of object families

It promotes consistency among objects

The base GOF patterns are divided into 3 types

Creational

Structural

Behavioral

The Abstract factory pattren come under the creational patterns
J2EE Applicability of Abstract Factory
DAO
Value Object Assembler

To find Number of pages in word document Programatically

To compute no of pages in a word document you can use the following
ActiveDocument.ComputeStatistics(wdStatisticPages,1)
This gives you the number of pages in the word document
Hope this helps

Java Bean Generator from Database table

Hi again,
I have written a small utility to generate the java bean classes from exiting tables whihc are present in the database.
You can gerenarate your bean class/Model classes with a click of button.
Hope this helps you

Create a from in VB and keep one text boxes and list box places two command buttons
Here is code

Dim conn As ADODB.Connection
Private Sub CommandButton1_Click()Set conn = New ADODB.Connectionconn.Open "xxxx", "xxxx", "xxxx"Dim arr As ADODB.Recordsetconn.CursorLocation = adUseClientSet arr = New ADODB.Recordsetarr.Open "select TNAME from tab", conn, adOpenDynamic, adLockOptimisticDo While Not arr.EOF ListBox1.AddItem (arr.Fields(0)) arr.MoveNextLooparr.Close
End Sub
Private Sub CommandButton2_Click()Dim arr As ADODB.RecordsetDim strValue As StringDim strClassName As StringIf (conn Is Nothing) Then MsgBox "get the tables first", vbCritical Exit SubEnd IfSet arr = New ADODB.RecordsetstrClassName = Replace(ListBox1.Text, "_", "")strValue = "public class " & StrConv(strClassName, vbProperCase) & "{" & vbCrLf
arr.Open "select * " & "from " & ListBox1.Text, conn, adOpenDynamic, adLockOptimisticFor i = 0 To arr.Fields.Count - 1 Select Case arr.Fields(i).Type Case adNumeric, adInteger, adSingle, 139 strValue = strValue + "private int " & Replace(StrConv(arr.Fields(i).Name, vbLowerCase), "_", "") & ";" + Chr(13) Case adVarChar strValue = strValue + "private String " & StrConv(Replace(arr.Fields(i).Name, "_", ""), vbLowerCase) + ";" + Chr(13) End SelectNextstrValue = strValue & "}"TextBox1.Text = strValuearr.Close
End Sub
Private Sub UserForm_Click()
End Sub
Private Sub UserForm_Terminate()If Not (conn Is Nothing) Thenconn.CloseEnd IfEnd Sub
Raj

My blog migrated to New Blogger

Hi all,
Hope you like my upgrade to new blogger. It has lots of features which you make use of.

Business Process Execution Language (BPEL)

Before we jump right into a discussion on Business Process Execution Language (BPEL) we need to set a framework for its use. It is important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. Business process management (BPM) technology is a framework for applications that can effectively track and orchestrate business processes. BPM solutions will automatically manage processes and process flow, but allow for manual intervention when necessary. BPM might coordinate the extraction of customer information from a database or manage a new customer information transaction. BPM could generate transactions in multiple related systems or support straight-though processing without human intervention. BPM allows you to automate tasks involving information from multiple systems with rules to define the sequence in which the tasks are performed as well as responsibilities, conditions and other aspects of the process. BPM not only allows a business process to be executed more efficiently, it also provides the tools to allow you to measure performance and identify opportunities for improvement. A benefit of BPM is that changes can be easily made in processes or flow by adding, removing or updating a process.To take the advantage of the whole process the systems should follow Service Oriented architecture.

Business Process excecution language

Business process excecution language defines a notation for specifying the business process behavior.

The following are BPEL servers aviaible they are

ActiveBPEL Engine
IBM BPEL4WS Editor and Java Run-Time
Oracle BPEL Process Manager
Microsoft BizTalk Server 2004(Biz talk server orchestration)
Other BPEL Servers
Here iam giving a brief overview of Oracle BPEL server.

Oracle's BPEL server allows you to connect to data sources via its adaptors

1) File adapters
2) FTP adapters
3) Oracle advanced querying
4) Database server querying
5) JMS adapter
6) Oracle application adaptors
Oracle's BPM has a buit-in support for the following

XSLT Mapper
XPATH
XSD
XSL.

This BPM is completely built on XML.
This is an abstract from Search Oracle's article on BPEL
Hope this gives an idea about BPEL.

To summaries, if you want to implement BPEL in a project, the following are the steps

Expose the service(s) (by registering)
Invoke a process flow
Perform data transformation
Manage exception processing
Include user tasks
Place sensors throughout the process flow
Monitor the process

Open Source Content Management Systems - .NET

Recently, i came accross some links on Open source Content Management Systems.
I am exploring them
http://petesbloggerama.blogspot.com/2006/10/open-source-aspnet-20-cms-content.html
http://msdn.microsoft.com/newsgroups/default.aspx?&guid=&sloc=en-us&dg=microsoft.public.dotnet.framework.aspnet&p=1&tid=b86611bd-2b72-4ee6-a397-d6f0d8ee9181&mid=b86611bd-2b72-4ee6-a397-d6f0d8ee9181

In my next posts i will write articles on these.

Log4J log file not getting generated in Weblogic

If you get a problem of Log file of Log4J is not getting generated, you need to add a entry to the weblogic.xml,

<container-descriptor>
<prefer-web-inf-classes>true</prefer-web-inf-classes>
</container-descriptor>

This is because weblogic has it's own logger.