Wednesday, December 5, 2012

JMS Clients

JMS Clients

  1. http://queuemanager.nl/offline-installation/  
  2. Hermes is an interactive JMS browser and administration tool. We can Download JNLP file from http://www.hermesjms.com/. Hermes is an interactive JMS browser (Useful with JBoss)

Wednesday, November 7, 2012

IBM Support Portal How-to videos on YouTube

IBM Electronic Support Channel
 









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

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>
                                    <SIResourceDefaultVersion>true</SIResourceDefaultVersion>
                                    <STATUS>1</STATUS>
                                    <COMMENTS/>
                                    <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>