Zero Bytes

Sunday, November 11, 2012

Startup Tools | Steve Blank

Good read for startup,

http://steveblank.com/tools-and-blogs-for-entrepreneurs/

Saturday, November 10, 2012

Beautiful Sunset, King of Prussia, PA on November 9th 2012

Beautiful Sunset, King of Prussia, PA on November 9th 2012.

Friday, November 9, 2012

Why Startup Founders are Always Unhappy — jessblog

Good read...

http://www.jessyoko.com/blog/2012/11/07/why-startup-founders-are-always-unhappy/

Wednesday, November 7, 2012

IBM Support Portal How-to videos on YouTube

IBM Electronic Support Channel

IBM Support Portal How-to videos on YouTube

via IBM Sterling B2B Support Blog

Electronic Support Channel (all videos are posted here by scrolling down to "Uploaded Videos" section) - http://www.youtube.com/IBMElectronicSupport
What is the IBM Support Portal? - http://www.youtube.com/watch?v=0VzVfdKA8zo
IBM Support Portal Overview - http://www.youtube.com/watch?v=laOCDj5xdAs
Getting started with IBM Support Portal using Quick Start - http://www.youtube.com/watch?v=2mORmlZGLWI
Inside and IBM Support Centre - http://www.youtube.com/watch?v=TUy2cq8IPL0
Managing Your Product List in the IBM Support Portal - http://www.youtube.com/watch?v=P7vqYH6pH0E
Getting Started with IBM Support: How to Obtain an IBM ID - http://www.youtube.com/watch? v=afQmxE4wjIg&feature=results_main&playnext=1&list=PL421D5E967BB1398D
Downloading Products from Passport Advantage - http://www.youtube.com/watch?v=HuatqV8jpu4&feature=related
How to download software fixes from Fix Central - http://www.youtube.com/watch?v=G0Q02Mvx07c&feature=related
Installing and running IBM Support Assistant - http://www.youtube.com/watch?v=TUv8mge8PIk&feature=related
The IBM Web Problem Reporting Initiative - http://www.youtube.com/watch?v=HphQ3qYMy1M&feature=results_video&playnext=1&list=PL421D5E967BB1398D
Glossary of Support Terms - http://www.youtube.com/watch?v=YHbo9HDrI98
Accelerated Value Program features of the IBM Support Portal - http://www.youtube.com/watch?v=UrNbdIIXgUA
Electronic Support Channel (all videos are posted here) - http://www.youtube.com/IBMElectronicSupport

Sterling Integrator - Database to XML Mapping

Here is the process for oracle and I am sure it's gonna be same for other databases as well,

1. Install Oracle Client Software. (Not Server).
2. Put database server entry in tnsnames.ora file.
3. Go to Control Panel where you installed Map editor create System DSN. When you click on
   Add you should see Oracle client there. (If you installed oracle client property)
4. Provide required database credentials and complete DNS creations.
5. Bring up your map editor create new map choose data format as SQL (Database
   Connectivity).
6. Go to Source Side properties in map editor go to Data Source tab select your DNS name and
   it will list all your tables and when you select table you can auto generate fields.

From here regular mapping. Be careful while editing tnsnames.ora.

Sunday, November 4, 2012

Join DropBox

A cool website for sharing and storing pictures, Join here http://db.tt/xMMRuufS

Tuesday, October 2, 2012

Override Persistence Level in Business Process

Here is how we can override persistence level in Workflow dynamically,

<assign to="WF_RUNTIME_OVERRIDE_PERSISTENCE_LEVEL">PERSISTENCE_FULL</assign>

<assign to="WF_RUNTIME_OVERRIDE_PERSISTENCE_LEVEL">PERSISTENCE_MINIMAL</assign>

Friday, September 28, 2012

Append two Arrays in Java

Still need to optimize this method but this works with out any issues,

public String[] appendArrays(String[] arrayToAdd, String[] arrayFromAdd) {
        List<String> list = new ArrayList<String>(Arrays.asList(arrayToAdd));
        if (arrayFromAdd != null && arrayFromAdd.length > 0) {
            list.addAll(Arrays.asList(arrayFromAdd));
        } else {
            arrayFromAdd = new String[]{"N/A"};
            list.addAll(Arrays.asList(arrayFromAdd));
        }
        return list.toArray(new String[list.size()]);
    }

Convert ResultSet to Array in Java

public String[] convertRStoArray(ResultSet resultSet, boolean closeResultSet) {
        String[] arrayofDataColumns = null;
        Map columnsMap = new HashMap();
        int columns = 0;
        try {
            List<String> record = new ArrayList<String>();
            while (resultSet.next()) {
                arrayofDataColumns = new String[resultSet.getMetaData().getColumnCount()];
                columns = (resultSet.getMetaData()).getColumnCount();
                String value = null;
                for (int i = 1; i <= columns; i++) {
                    value = resultSet.getString(i);
                    record.add(value);
                    if (columnsMap.containsKey(i)) {
                        if (value != null && !value.equals("")) {

                            if (columnsMap.get(i) != null && !columnsMap.get(i).equals("") && !columnsMap.get(i).equals(value)) {
                                value = columnsMap.get(i) + "|" + value;
                                columnsMap.put(i, value);
                            }
                        }
                    } else {
                        columnsMap.put(i, value);
                    }
                }
                Object[] keys = columnsMap.keySet().toArray();
                for (int ii = 0; ii < keys.length; ii++) {
                    arrayofDataColumns[ii] = (String) columnsMap.get(ii + 1);
                }
            }

        } catch (Exception e) {
            logger.log(Level.SEVERE, "Got the exception in convertRStoArray:" + e.getMessage());
        } finally {
            if (closeResultSet)
                closeResultSet(resultSet);
        }
        return arrayofDataColumns;
    }

Saturday, September 22, 2012

IBM Sterling B2B Integrator Code List Deployment through Command Prompt

C:\Sirish\SterlingIntegrator\install\tp_import>import.cmd -update -passphrase passphrase -input C:\Sirish\bpml_coding\Sirish.xml

This is the format requires to import from command prompt.

Sirish.xml

<?xml version="1.0" encoding="UTF-8"?>

<SI_RESOURCES xmlns="http://www.stercomm.com/SI/SI_IE_Resources" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" GISVersion="6000" FrameworkVersion="2">

<CODE_LISTS>

<CODE_LIST_XREF>

<LIST_NAME>Sirish</LIST_NAME>

<SENDER_ID/>

<RECEIVER_ID/>

<LIST_VERSION>2</LIST_VERSION>

<USERNAME>Sirish Reddy Gongal Reddy</USERNAME>

<CREATE_DATE>2012-09-21 14:43:16.087</CREATE_DATE>

<CODE_LIST_XREF_ITEMS>

<CODE_LIST_XREF_ITEM>

<SENDER_ITEM>Sirish Reddy</SENDER_ITEM>

<RECEIVER_ITEM>Gongal Reddy</RECEIVER_ITEM>

<TEXT1>Target System - One</TEXT1>

<TEXT2>Target System - Two</TEXT2>

<TEXT3>Target System - 3</TEXT3>

<TEXT4>Target System - 4</TEXT4>

<TEXT5>Target System - 5</TEXT5>

<TEXT6>Target System - 6</TEXT6>

<TEXT7>Target System - 7</TEXT7>

<TEXT8>Target System - Eight</TEXT8>

<TEXT9>Target System - Nine</TEXT9>

<DESCRIPTION>Just Testing the Auto Import</DESCRIPTION>

</CODE_LIST_XREF_ITEM>

</CODE_LIST_XREF_ITEMS>

</CODE_LIST_XREF>

</CODE_LISTS>

</SI_RESOURCES>

Tuesday, September 11, 2012

Offset for given Time Zone

import java.util.TimeZone;

public String getTimeZoneOffSet(String timeZoneID) {
        TimeZone tz = TimeZone.getTimeZone(timeZoneID);
        int rawOffset = tz.getRawOffset();
        int hour = rawOffset / (60 * 60 * 1000);
        int minute = Math.abs(rawOffset / (60 * 1000)) % 60;
        return hour + ":" + minute;
    }

Test:
tc.getTimeZoneOffSet("America/New_York")); This returns Offset for NY -->-5:0

Using Calendar Class

import java.util.Calendar;

public int getOffsetForTimeZone(String timeZoneId) {
        int a;
        Calendar calendar = new GregorianCalendar();
        TimeZone timeZ = calendar.getTimeZone();
        timeZ = timeZ.getTimeZone(timeZoneId);
        a = (int) ((timeZ.getRawOffset()) * (2.77777778 / 10000000));
        return a;
    }

Thursday, September 6, 2012

Graphical Process Modeler not opening in Sterling Integrator

Most of the times we get the below exception while opening Graphical Process modeler because the IP address in the below URL is not correct. Sterling Integrator host address and GMP host address different then we need to fix the host name and make it common.

com.sun.deploy.net.FailedDownloadException: Unable to load resource: http://192.168.235.76:15000/gbm/pmodeler/ProcessModeler.jnlp
    at com.sun.deploy.net.DownloadEngine.actionDownload(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResourceCacheEntry(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
    at com.sun.deploy.net.DownloadEngine.getResource(Unknown Source)
    at com.sun.javaws.Launcher.updateFinalLaunchDesc(Unknown Source)
    at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
    at com.sun.javaws.Launcher.prepareToLaunch(Unknown Source)
    at com.sun.javaws.Launcher.launch(Unknown Source)
    at com.sun.javaws.Main.launchApp(Unknown Source)
    at com.sun.javaws.Main.continueInSecureThread(Unknown Source)
    at com.sun.javaws.Main$1.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

How to Fix:

       1. Stop Sterling Integrator.
       2. <SI_Install>/bin folder and execute the below commnad.
       3. <SI_Install>/bin> patchJNLP.cmd <put your hostname here>
       4. Start the Sterling Integrator and go to Business Process Manager and Run Graphical Process Modeler. (Don't use old jnlp file and download fresh copy)

Sunday, August 26, 2012

Comprehensive Enterprise and B2B Integration Webinar

Comprehensive Enterprise and B2B Integration Suite Webinar (Recorded) from Bradley C Loetz on Vimeo.