Monday, April 12, 2010

customized web service invocation with one bpm tool

Lately, I've been working on a customized java service for one bpm tool (Cordys) to invoke platform web services. Here are the implementation details:
1. A method that takes xml message as a string:
public static String invoke(String endpoint, String userName, String password,
String requestMessage) {
SOAPMessage soapResponse = invoke(endpoint, userName, password,
convertStringToSoapMessage(requestMessage));

return convertSoapMessageToString(soapResponse);
}

2. A method that handles SoapMessage data type:
public static SOAPMessage invoke(String endpoint, String userName,
String password, SOAPMessage soapMsg) {
try {
// Create the connection
SOAPConnectionFactory soapConnFactory = SOAPConnectionFactory
.newInstance();
SOAPConnection conn = soapConnFactory.createConnection();

CordysAuthenticator credential = new CordysAuthenticator(userName, password);
// CordysAuthenticator is an "Authenticator" implementation
Authenticator.setDefault(credential);

SOAPMessage soapResponse = conn.call(soapMsg, endpoint);
conn.close();
return soapResponse;
} catch (SOAPException e) {
System.out.println("SOAPException : " + e);
return null;

}
}

3. A method to convert String to SoapMessage:
public static SOAPMessage convertStringToSoapMessage(String requestString) {

try {

// Use SAAJ to convert Document to SOAPElement
// Create SoapMessage
MessageFactory msgFactory = MessageFactory.newInstance();
SOAPMessage message = msgFactory.createMessage();
SOAPPart part=message.getSOAPPart();

byte[] soapBytes=requestString.getBytes();
ByteArrayInputStream stream = new ByteArrayInputStream(soapBytes);
StreamSource source = new StreamSource(stream);
part.setContent(source);
message.saveChanges();

// This returns the SOAPBodyElement
// that contains ONLY the Payload
System.out.print("request message String:"+ requestString);
return message;

} catch (SOAPException e) {
System.out.println("SOAPException : " + e);
return null;

}

}

4. A method to convert SoapMessage to string
public static String convertSoapMessageToString(SOAPMessage soapMessage) {
try {
String result = "";

// Create transformer
TransformerFactory transFactory = TransformerFactory.newInstance();
Transformer transformer = transFactory.newTransformer();
// TransformerConfigurationException


// Get reply content
Source sourceMsg = soapMessage.getSOAPPart().getContent();
// SOAPException

// Set output transformation
StringWriter writer = new StringWriter();
StreamResult resultStream = new StreamResult(writer);
transformer.transform(sourceMsg, resultStream);
// TransformerException
result = writer.toString();
writer.close();
// IOException

return convertToXmlString(result);
} catch (...){}
}


There might be error message such as "invalid soap messages" when the message is sent to the web gateway. This might be caused by the doublequote used in the name space declaration of the xml message. In order to solve the problem, we can use the method String.replaceAll("\"","\\\""); to replace doublequotes with escaped doublequotes.

Thursday, March 25, 2010

Learning Scala

Some interesting read about scala, it could be a replacement for some J2EE implementations:
http://macstrac.blogspot.com/2009/04/scala-as-long-term-replacement-for.html
http://www.scala-lang.org/node/1305
http://programming-scala.labs.oreilly.com/

Monday, October 26, 2009

remove outdated files based on minor build number

I've created a script to remove old installation file based on the minor build number.
In one project I'm working on, we need to keep the file with the largest build number. Here's a sample to check which build number is the latest one.

for file in `find . -name \*$ESBPREFIX\*.isvp`
do
# echo $file
NAMELENGTH=`expr length $file`
POSITION=`expr $NAMELENGTH - 7`
ESBVERSION=`expr substr $file $POSITION 3`
if [ `expr index $ESBVERSION "."` -eq 1 ]; then
ESBVERSION=`expr substr $ESBVERSION 2 2`
fi
if [ `expr index $ESBVERSION "."` -eq 2 ]; then
ESBVERSION=`expr substr $ESBVERSION 3 1`
fi
# echo "[CO Build Number: $ESBVERSION]"
if [ $ESBVERSION -gt $MAXESBBDNR ]; then
MAXESBBDNR=$ESBVERSION
fi
done

Tuesday, October 06, 2009

Firing SOAP requests via Excel

Here's a tutorial about how to fire a soap request via Excel
http://www.brainbell.com/tutorials/ms-office/excel/Access_SOAP_Web_Services_From_Excel.htm .
The prerequisite is to get "Office Web Services Toolkit" from Microsoft website; then you can use it in VBA.
It'll be quite handy for those guys who work with SOA projects. A simple VBA can be built within excel worksheet to load soap request from OS and send it to the web service endpoint.

Monday, May 18, 2009

A tricky problem for xml validation

There's an interesting article about XML Schema nillable=”true” vs minOccurs=”0″ in Dimithu's blog. minOccurs is an xml attribute that most people understand; but for nillable="true", people might understand its meaning; however, how to use it in a correct way is not well known. By "correct way", I mean "the way that complies with W3C specifications".
Actually, a lot of software vendors are not clear about its usage as well. This leads to interoperability problems. Some BPM/SOA vendors implement different validation rules for a "nillable" tag, which are not in accordance with W3C specifications. 

Imagine an application is built which utilizes web services from different external system, and those web services require web service validation. The problem occurs that some systems send out the message which they consider as valid, while it's rejected by other systems due to different interpretation of "wsdl/soap validity". 

In short, the problem can be described as follows:
When an element is defined in wsdl using  xs:element name="nilint" nillable="true" type="xs:int"

The nilint element in the soap message should look like this if it's an empty node:
nilint xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/
If it's not an empty node, we can remove the contained attribute because by default the value for nil is "false".

Considering the aforementioned scenario, if some development tools that are used to build the SOA application don't provide support for the nil tag, we need to find some way to workaround the issue. The normal way to do it is to create an interceptor class whenever the soap message is being sent out.
This looks like a minor issue, but indeed a lot tools have problems with it; for example, wsdl validation function in SoapUI does not work in a correct way.

Friday, May 08, 2009

Check Oracle tablespace

Here's the script to check oracle table space:

select d.status,   db.name dbname,   d.tablespace_name tsname,   d.extent_management,   d.allocation_type,   to_char(nvl(d.min_extlen / 1024, 0),     '99G999G990D90', 'NLS_NUMERIC_CHARACTERS = '',.'' ')     "ALLOC_SIZE (K)",   d.contents "Type", case when(d.contents = 'TEMPORARY') then   to_char(nvl(a.bytes / 1024 / 1024, 0),   '99G999G990D90', 'NLS_NUMERIC_CHARACTERS = '',.'' ') else   to_char(nvl(t.bytes / 1024 / 1024, 0),   '99G999G990D90', 'NLS_NUMERIC_CHARACTERS = '',.'' ') end as "Size (M)",   to_char(nvl((a.bytes - nvl(f.bytes, 0)) / 1024 / 1024,   0),   '99G999G990D90', 'NLS_NUMERIC_CHARACTERS = '',.'' ')   "Used (M)",   to_char(nvl((a.bytes - nvl(f.bytes, 0)) / a.bytes * 100,   0),   '990D90', 'NLS_NUMERIC_CHARACTERS = '',.'' ')   "Used (%)" from sys.dba_tablespaces d,     (select tablespace_name,      sum(bytes) bytes    from dba_data_files    group by tablespace_name) a,     (select tablespace_name,      sum(bytes) bytes    from dba_temp_files    group by tablespace_name) t,     (select tablespace_name,      sum(bytes) bytes    from dba_free_space    group by tablespace_name) f,   v$database db where d.tablespace_name = a.tablespace_name(+)  and d.tablespace_name = f.tablespace_name(+)  and d.tablespace_name = t.tablespace_name(+) order by 10 desc;