Posts
Beautiful Sunset, King of Prussia, PA on November 9th 2012
- Get link
- X
- Other Apps
IBM Support Portal How-to videos on YouTube
- Get link
- X
- Other Apps
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&f...
Sterling Integrator - Database to XML Mapping
- Get link
- X
- Other Apps
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.
Append two Arrays in Java
- Get link
- X
- Other Apps
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
- Get link
- X
- Other Apps
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 = c...
IBM Sterling B2B Integrator Code List Deployment through Command Prompt
- Get link
- X
- Other Apps
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 > ...
Offset for given Time Zone
- Get link
- X
- Other Apps
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(); ti...
Graphical Process Modeler not opening in Sterling Integrator
- Get link
- X
- Other Apps
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(...