R.Amirtharaj

Solution for server port is already in use

2013-07-10T02:05:00.002-07:00

For developer while running server based application will get error like as

Starting of Tomcat failed, the server port 8080 is already in use.

This problem may occur in following reasons :

1. if another application used same port(then we need to select different port)

2. we already stopped application but port is still in used ,
then we need to stop port use and make it available for running application

goto command prompt

netstat -aon

it will show you something like

TCP    192.1.200.48:8080     24.43.246.60:443       ESTABLISHED     248
TCP    192.1.200.48:8080      24.43.246.60:443       ESTABLISHED     248
TCP    192.1.200.48:2126      213.146.189.201:12350 ESTABLISHED     1308
TCP    192.1.200.48:3918      192.1.200.2:8073       ESTABLISHED     1504
TCP    192.1.200.48:3975      192.1.200.11:49892     TIME_WAIT       0
TCP    192.1.200.48:3976      192.1.200.11:49892     TIME_WAIT       0
TCP    192.1.200.48:4039      209.85.153.100:80      ESTABLISHED     248
TCP    192.1.200.48:8080      209.85.153.100:80      ESTABLISHED     248

check which process has binded your port. here in above example its 248 now if you are sure that you need to kill that process fire

Linux:

kill -9 248

Windows:

taskkill /f /pid 248

it will kill that process

A Small Intro for Software Testing

2013-05-17T02:36:00.003-07:00

What is software testing ?

It is the process of evolution a software item to detect difference between given input and expected output , also to assess the feature of a software system.
Testing assesses the quality of the product.
It should be done in development phase.
It is a verification and validation process.

Verification :

It is the process to make sure the product satisfies the conditions imposed at start of the development phase.
To make sure the product behaves the way we want.

Validation :

It is the process to make sure the product satisfies the specified requirements at end of the development phase.
To make sure the product is built as per customer requirement.

There are two basics of software testing

1. Blackbox Testing :

It is a testing technique that ignores internal mechanism of the system and focusses on the output generated against any input and execution of the system.
It is often used for Validation.

2. Whitebox Testing :

It is a testing technique that takes into account the internal mechanism of the system.
It is often used for Verification.

Types:

There are many types of testing like as below

Unit Testing :

It is the testing of an individual unit or group of related units.
It is done by programmer to test that the unit he has implemented is producing expected output against input.
It falls under class of whitebox testing.

Integration Testing:

It is testing in which the group of components are combined to produce the output.
It is also interaction between hardware and software is tested if hardware and software components have any relation.
It may fall both blockbox and whitebox testing.

Functional Testing:

It is the testing to ensure that the specified fuctionalities required in the system requirements works.
It falls under class of Blackbox testing.

System Testing:

It is the testing to ensure that by putting the software in different environments (diff OS) it still works.
It is done with full system implementation and environments.
It falls under class of Blackbox testing.

Performance Testing:

It is the testing to assess the speed and effectiveness of the system and to make sure it's generating results in
specified time as an in performance requirements.
It falls under class of Blackbox testing.

Usability Testing:

It is performed to the perspective of the client , to evaluate how the GUI is user-friendly .How easily can the client learn? After learning how to use, how proficiently can the client perform? How pleasing is it to use its design?
It falls under class of Blackbox testing.

Acceptance Testing

It is often done by the customer to ensure that the delivered product meets the requirements and works as the customer expected.
It falls under the class of black box testing.

Regression Testing

It is the testing after modification of a system, component, or a group of related units to ensure that the modification is working correctly and is not damaging or imposing other modules to produce unexpected results.
It falls under the class of black box testing.

Beta Testing

It is the testing which is done by end users, a team outside development, or publicly releasing full pre-version of the product which is known as beta version. The aim of beta testing is to cover unexpected errors.
It falls under the class of black box testing.

AutoCompletionTestFieldDemo using Java

2013-04-25T22:59:00.003-07:00

import java.awt.*;
import java.awt.event.*;
import java.util.*;

import javax.swing.*;
import javax.swing.event.*;
/**
* Example for AutoCompletionTestFieldDemo
* @author R.Amirtharaj
*/
public class AutoCompletionTestFieldDemo {

    public static void main(String[] args) throws Exception {
        UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
        JFrame frame = new JFrame();
        frame.setTitle("Auto Completion Test");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setBounds(200, 200, 500, 400);

        ArrayList items = new ArrayList();
        // To get Locale
        Locale[] locales = Locale.getAvailableLocales();
        for (int i = 0; i < locales.length; i++) {
            String item = locales[i].getDisplayName();
            items.add(item);
        }
        JTextField txtInput = new JTextField();

        // set autocmplete
        setAutoComplete(txtInput, items);
        txtInput.setColumns(30);
        frame.getContentPane().setLayout(new FlowLayout());
        frame.getContentPane().add(txtInput, BorderLayout.NORTH);
        frame.setVisible(true);
    }

    private static boolean isAdjusting(JComboBox cbInput) {
        if (cbInput.getClientProperty("is_adjusting") instanceof Boolean) {
            return (Boolean) cbInput.getClientProperty("is_adjusting");
        }
        return false;
    }

    private static void setAdjusting(JComboBox cbInput, boolean adjusting) {
        cbInput.putClientProperty("is_adjusting", adjusting);
    }

    public static void setAutoComplete(final JTextField txtInput, final ArrayList items) {
        final DefaultComboBoxModel model = new DefaultComboBoxModel();
        final JComboBox cbInput = new JComboBox(model) {
            public Dimension getPreferredSize() {
                return new Dimension(super.getPreferredSize().width, 0);
            }
        };
        setAdjusting(cbInput, false);
        for (String item : items) {
            model.addElement(item);
        }
        cbInput.setSelectedItem(null);
        cbInput.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (!isAdjusting(cbInput)) {
                    if (cbInput.getSelectedItem() != null) {
                        txtInput.setText(cbInput.getSelectedItem().toString());
                    }
                }
            }
        });

        txtInput.addKeyListener(new KeyAdapter() {

            @Override
            public void keyPressed(KeyEvent e) {
                setAdjusting(cbInput, true);
                if (e.getKeyCode() == KeyEvent.VK_SPACE) {
                    if (cbInput.isPopupVisible()) {
                        e.setKeyCode(KeyEvent.VK_ENTER);
                    }
                }
                if (e.getKeyCode() == KeyEvent.VK_ENTER || e.getKeyCode() == KeyEvent.VK_UP || e.getKeyCode() == KeyEvent.VK_DOWN) {
                    e.setSource(cbInput);
                    cbInput.dispatchEvent(e);
                    if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                        // User may enter Other than list
                        try {
                            txtInput.setText(cbInput.getSelectedItem().toString());
                        }
                        catch(Exception ex)
                        {
                        }
                        cbInput.setPopupVisible(false);
                    }
                }
                if (e.getKeyCode() == KeyEvent.VK_ESCAPE) {
                    cbInput.setPopupVisible(false);
                }
                setAdjusting(cbInput, false);
            }
        });

        txtInput.getDocument().addDocumentListener(new DocumentListener() {
            public void insertUpdate(DocumentEvent e) {
                updateList();
            }

            public void removeUpdate(DocumentEvent e) {
                updateList();
            }

            public void changedUpdate(DocumentEvent e) {
                updateList();
            }

            private void updateList() {
                setAdjusting(cbInput, true);
                model.removeAllElements();
                String input = txtInput.getText();
                if (!input.isEmpty()) {
                    for (String item : items) {
                        if (item.toLowerCase().startsWith(input.toLowerCase())) {
                            model.addElement(item);
                        }
                    }
                }
                cbInput.hidePopup();
                cbInput.setPopupVisible(model.getSize() > 0);
                setAdjusting(cbInput, false);
            }
        });
        txtInput.setLayout(new BorderLayout());
        txtInput.add(cbInput, BorderLayout.SOUTH);
    }
}

The Seven Phases of the Systems Development Life Cycle (SDLC):

2013-04-22T23:37:00.002-07:00

The Seven Phases of the Systems Development Life Cycle :

1. Information Gathering : In this phase Bussiness Analyst will gather all the information from customer requirement and prepare BRS/CRS/URS(Buiseness/Customer/User Requirement Specification) document. Mainly this done by Buisness Anlayst as they are the one who are completely involved in SDLC.

2. Analysis : In this phase Senior Business Analyst will prepare SRS(Software Requirement Specification). The Features and functions are put in the project are determined.

3. Design : Actual flow of the project is done here. Deciding upto logical functionality, ER Diagram , Flow chart etc are made. Cheif Architect will prepare HLD and LLD(High Level Document and Low Level Document)

HLD : Defines the overall Hierarchy of the function.Example : Login into Net Banking. From the root level to the least level is defines in HLD.
LLD: Internal logic of the project is defined. Focuses on the internal functionality of the program. Each and every module logic is defined.

4. Code : Based on the design document , small-small modules are prepared . All the modules are summed together to form a .exe. Unit testing , integration testing & white box testing comes in this phase.

5. Testing : Actuall system testing take place here.

6. Implementation : All sr.department will release the product .

7. Maintenance : In maintenance the maintenance team will change the software if necessary.

Java Collection loop throw elements

2013-04-18T05:12:00.003-07:00

import java.util.*;

/**
*
* @author Amirtharaj
*/
public class CollectionLoopThroDemo {

    public static void main(String arg[]) {
        CollectionLoopThroDemo cd = new CollectionLoopThroDemo();

        List al = new ArrayList();
        al.add("C");
        al.add("A");
        al.add("B");
        cd.iterateList(al);

        Set setDet = new HashSet();
        setDet.add("B");
        setDet.add("A");
        setDet.add("C");
        cd.iterateSet(setDet);

        Map mapDet = new HashMap();
        mapDet.put("B", 2.0);
        mapDet.put("A", 1.0);
        mapDet.put("C", 3.0);
        cd.iterateMap(mapDet);

    }

    public void iterateList(List al) {
        //access via Iterator
        Iterator iterator = al.iterator();
        while (iterator.hasNext()) {
            String str = (String) iterator.next();
            System.out.println(str);
        }
        //access via new for-loop
        for (String str : al) {
            System.out.println(str);
        }
    }

    public void iterateSet(Set setDet) {

        //access via Iterator
        Iterator iterator = setDet.iterator();
        while (iterator.hasNext()) {
            String str = (String) iterator.next();
            System.out.println(str);
        }

        //access via new for-loop
        for (String str : setDet) {
            System.out.println(str);
        }
    }

    public void iterateMap(Map mapDet) {
        //access via Iterator
        Iterator iterator = mapDet.keySet().iterator();
        while (iterator.hasNext()) {
            String key = (String) iterator.next();
            Double value = (Double) mapDet.get(key);
            System.out.println(key + "," + value);
        }

        //access via new for-loop
        for (String key : mapDet.keySet()) {
            Double value = mapDet.get(key);
            System.out.println(key + "," + value);
        }

    }
}

To get Motherboard serial number, Hard disk serial number, IP Address and MAC Address from Java

2013-04-02T05:14:00.002-07:00

import java.io.File;
import java.io.FileWriter;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.InetAddress;
import java.net.NetworkInterface;

public class MyPC {

    public static String getMotherBoardSerialNumber() {
        String result = "";
        try {
            File file = File.createTempFile("realhowto", ".vbs");
            file.deleteOnExit();
            FileWriter fw = new java.io.FileWriter(file);
            String vbs =
                    "Set objWMIService = GetObject(\"winmgmts:\\\\.\\root\\cimv2\")\n"
                    + "Set colItems = objWMIService.ExecQuery _ \n"
                    + "   (\"Select * from Win32_BaseBoard\") \n"
                    + "For Each objItem in colItems \n"
                    + "    Wscript.Echo objItem.SerialNumber \n"
                    + "    exit for ' do the first cpu only! \n"
                    + "Next \n";

            fw.write(vbs);
            fw.close();
            Process p = Runtime.getRuntime().exec("cscript //NoLogo " + file.getPath());
            BufferedReader input =
                    new BufferedReader(new InputStreamReader(p.getInputStream()));
            String line;
            while ((line = input.readLine()) != null) {
                result += line;
            }
            input.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result.trim();
    }

    public static String getHardDiskSerialNumber(String drive) {
        String result = "";
        try {
            File file = File.createTempFile("realhowto", ".vbs");
            file.deleteOnExit();
            FileWriter fw = new java.io.FileWriter(file);

            String vbs = "Set objFSO = CreateObject(\"Scripting.FileSystemObject\")\n"
                    + "Set colDrives = objFSO.Drives\n"
                    + "Set objDrive = colDrives.item(\"" + drive + "\")\n"
                    + "Wscript.Echo objDrive.SerialNumber"; // see note
            fw.write(vbs);
            fw.close();
            Process p = Runtime.getRuntime().exec("cscript //NoLogo " + file.getPath());
            BufferedReader input =
                    new BufferedReader(new InputStreamReader(p.getInputStream()));
            String line;
            while ((line = input.readLine()) != null) {
                result += line;
            }
            input.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result.trim();
    }

    public static String getIPAddress() {
        String strIP = "127.0.0.1";
        try {
            InetAddress ip = InetAddress.getLocalHost();
            strIP = ip.getHostAddress();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return strIP;
    }

    public static String getMACAddress() {
        String strMAC = "127.0.0.1";
        try {
            InetAddress ip = InetAddress.getLocalHost();
            NetworkInterface network = NetworkInterface.getByInetAddress(ip);
            byte[] mac = network.getHardwareAddress();
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < mac.length; i++) {
                sb.append(String.format("%02X%s", mac[i], (i < mac.length - 1) ? "-" : ""));
            }
            strMAC = sb.toString();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return strMAC;
    }

    public static void main(String[] args) {
        System.out.println("Motherboard serial number : " + MyPC.getMotherBoardSerialNumber());
        System.out.println("Hard disk serial number : " + MyPC.getHardDiskSerialNumber("C"));
        System.out.println("IP Address : " + MyPC.getIPAddress());
        System.out.println("MAC Address : " + MyPC.getMACAddress());
    }
}

Hibernate and Oracle sequence

2013-03-26T00:34:00.002-07:00

For Hibernate beginners using orcale db doing some examples then they will be confused over mapping file with auto increment . So for my experience I gave sample code as below to avoid

1. Use Sequence increment in mapping File :

Create Tabele :

CREATE TABLE EMPLOYEE (
ID          NUMBER        NOT NULL,
FIRST_NAME VARCHAR2 (20),
LAST_NAME   VARCHAR2 (20),
SALARY      NUMBER        DEFAULT null,
CONSTRAINT EMPLOYEE_PK
PRIMARY KEY ( ID ) ) ;

create sequence EMPLOYEE_ID_SEQ;

In Mapping File :

Employee.hbm.xml

2. Mapping with Database trigger on sequence

Create table as like above

For trigger :

create sequence EMPLOYEE_ID_SEQ;

CREATE OR REPLACE TRIGGER EMPLOYEE_insert
before insert on EMPLOYEE
for each row
begin
    select EMPLOYEE_ID_SEQ.nextval into :new.id from dual;
end;
/

In Mapping File :

Employee.hbm.xml

Difference between EnumMap and HashMap in Java

2013-03-25T03:07:00.000-07:00

S No	EnumMap	HashMap
1	EnumMap is optimized for enum keys	HashMap is a general purpose Map implementation similar to Hashtable
2	you can not use any type other than Enum as key in EnumMap	you can use both Enum and any other Object as key in HashMap
3	Due to specialized optimization done for Enum keys, EnumMap is likely to perform better than HashMap when using enum as key object	-
4	Since Enum is internally maintain as array and they are stored in there natural order using ordinal(), as shown in following code which is taken from put() method of EnumMap int index = ((Enum)key).ordinal(); Object oldValue = vals[index]; vals[index] = maskNull(value);	-

These were some notable difference between EnumMap and HashMap in Java. In short EnumMap is best suited for enum keys, for which it has optimized and perform better than HashMap in Java. Use EnumMap whenever you can use enum as keys.

Introduction about Hibernate

2013-03-21T23:47:00.001-07:00

Hibernate is an Object/Relational Mapping solution for Java Environments.
It takes care of the mapping from Java calsses to database tables and provides
data query and retrival facility.

Why choose Hibernate over the others?

Popular Open Source Persistence Frameworks in Java

1. Hibernate – http://www.hibernate.org/
2. EJB3 – http://java.sun.com/products/ejb/index.jsp
3. Oracle Top Links – http://www.oracle.com/technology/products/ias/toplink/index.html
4. Cayenne – http://cayenne.apache.org/
5. Open JPA – http://openjpa.apache.org/
6. IBATIS- http://ibatis.apache.org/javadownloads.cgi
7. JPOX – http://www.jpox.org/

Reason of choosing Hibernate
1. Productivity, Maintainability, Portability
Hibernate provides all above O/R benefits. (Productivity, Maintainability, Portability).
2. Free – Cost Effective
Hibernate is free and open source – Cost Effective
3. Learning curve is short
Since we all have working experience in using Hibernate, and Hibernate is totally object orientated concept, it will shorted our learning curve.
4. Code generation tool
Hibernate tools provided by community helps developer generate or develop hibernate application very fast and easy. (Eclipse’s Plugin & Code generation tools)
5. Popular
Hibernate is popular, when we goes wrong with Hibernate, we can easily find the answer from Google. In addition, there are many books, communities and forums on Hibernate.
6) Market demand it
Java Market need Hibernate developer, demand of Hibernate developer is in decent growth and compare to the other tools. Hibernate working experience definitely add advantages for my next jump.

Why hibernate is used?

Hibernate makes the application development process easy
   1. Hibernate saves the development time
   2. Hibernate allows to map the Java objects to the relational database
   3. Hibernate provides HQL for performing selective search
   4. Hibernate also supports SQL Queries (Native Query)
   5. Hibernate provides primary and secondary level caching support
   6. Can be used in both console and web based applications
   7. Developers can use the components from the Hibernate framework selectively.
   8. Hibernate can be used with JPA
   9. It supports both xml file and annotations as metadata

Finally why we are using hibernate means
    To make the application developemnt more productive. its saves development time and also mainly it deals with Objects(POJO)
and .xml file is nothing but mapping between database column and POJO variable.
you can easily switch the database like MySql to Oracle you need not to change any of your code...
just you can change a simple dylect in cfg file of hibernate to oracle it works with no error.
Addition to that we have visual paradigm tool which helps to create the object model.

Using Java , How to escape a string from regular expression?

2013-03-20T04:27:00.003-07:00

import org.apache.commons.lang.StringEscapeUtils;
 
public class testEscapeHTML{
 
 public static void main(String args[]){
 
  String testStr = "< > \" &";
 
  System.out.println("Original : " + testStr);
 
  System.out.println("Escaped : " + StringEscapeUtils.escapeHtml(testStr));
 
 } 
}

or

This asks the regular expression parser to ignore any special characters in the string.
This is also very simple as the first method.
All you have to do is to put “\Q” in front of the string and “\E” at the end of the string.

Example : " Some Special characters (!@#$%^&*()?":;)" =>
"\Q Some Special characters (!@#$%^&*()?":;)\E"

This is however already available as a function in java

String escapedString=java.util.regex.Pattern.quote(myStringToEscape)

You can use this method to make parts of a string escape as a regular expression.

Java Program : Open Excel File

2013-03-06T21:58:00.002-08:00

Below Program is used to open Excel File :
import java.awt.Desktop;
import java.io.*;

public class OpenExcel {

    /**
     * @param args
     */
    public static void main(String[] args) {
        if (Desktop.isDesktopSupported()) {
            try {
                Desktop.getDesktop().open(new File("File.xls"));
            } catch (IOException e) {
                e.printStackTrace();
            }
        } else {
            try {
                Process p = Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " + new File("File.xls"));
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}

Dynamically Adding Panel Based on Tree items in JTabbedPane

2013-03-04T23:07:00.003-08:00

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package jtabbedpanedemo;

import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.HashMap;
import javax.swing.*;
import javax.swing.event.TreeSelectionEvent;
import javax.swing.event.TreeSelectionListener;
import javax.swing.tree.DefaultMutableTreeNode;
import javax.swing.tree.DefaultTreeModel;
import javax.swing.tree.TreeSelectionModel;

/**
*
* @author R.Amirtharaj
*/
public class MainFrame {

    private JTabbedPane tabbedPane;
    private static final Icon CLOSE_TAB_ICON = new ImageIcon("Image location");
    // Key as Panel Name and Value as Panel index
    static final HashMap hmPanel = new HashMap();
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTree jTree1;

    public static void main(String[] args) {
        //Schedule a job for the event-dispatching thread:
        //creating and showing this application's GUI.
        SwingUtilities.invokeLater(new Runnable() {

            public void run() {
                createAndShowGUI();
            }
        });
    }

    /**
     * Create Tree . Panel1 an Panel2 under Root
     */
    public void createTreeComponents() {
        DefaultMutableTreeNode top = new DefaultMutableTreeNode("Root");
        DefaultMutableTreeNode tp1 = new DefaultMutableTreeNode("Panel1");
        DefaultMutableTreeNode tp2 = new DefaultMutableTreeNode("Panel2");
        top.add(tp1);
        top.add(tp2);

        // Create a new tree control
        DefaultTreeModel treeModel = new DefaultTreeModel(top);
        jTree1.setModel(treeModel);

        jTree1.getSelectionModel().setSelectionMode(TreeSelectionModel.SINGLE_TREE_SELECTION);
        jTree1.addTreeSelectionListener(new TSL());
    }

    // Tree Selection Listioner
    public class TSL implements TreeSelectionListener {

        public void valueChanged(TreeSelectionEvent e) {
            DefaultMutableTreeNode node = (DefaultMutableTreeNode) jTree1.getLastSelectedPathComponent();

            if (node == null) //Nothing is selected.
            {
                return;
            }

            Object nodeInfo = node.getUserObject();
            if (node.isLeaf()) {
                if (node.toString().equals("Panel1")) {
                    if (!hmPanel.containsKey("Panel1")) {
                        int index = hmPanel.size();
                        hmPanel.put("Panel1", index);
                        JPanel pan = new JPanel();
                        pan.add(new JLabel("Panel1"));
                        pan.setToolTipText("Panel1");
                        addClosableTab(tabbedPane, pan, "Panel1", null);
                    } else {
                        //System.out.println(hmPanel.get("Panel1"));
                        tabbedPane.setSelectedIndex(hmPanel.get("Panel1"));
                    }

                } else if (node.toString().equals("Panel2")) {
                    if (!hmPanel.containsKey("Panel2")) {
                        int index = hmPanel.size();
                        hmPanel.put("Panel2", index);
                        JPanel pan = new JPanel();
                        pan.add(new JLabel("Panel2"));
                        pan.setToolTipText("Panel2");
                        addClosableTab(tabbedPane, pan, "Panel2", null);
                    } else {
                        //System.out.println(hmPanel.get("Panel2"));
                        tabbedPane.setSelectedIndex(hmPanel.get("Panel2"));
                    }
                }

            } else {
            }
        }
    }

    private static void createAndShowGUI() {
        //Create and set up the frame.
        //The string passed as an argument will be displayed
        //as the title.

        JFrame.setDefaultLookAndFeelDecorated(true);
        JFrame frame = new JFrame("[=] JTabbedPane Demo [=]");

        //Create and set up the content pane.
        MainFrame demo = new MainFrame();
        demo.addContentPane(frame.getContentPane());

        // The other bits and pieces that make our program a bit more stable.
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setSize(400, 400);
        frame.setVisible(true);
    }

    public void addContentPane(Container container) {
        tabbedPane = new javax.swing.JTabbedPane();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTree1 = new javax.swing.JTree();
        createTreeComponents();

        container.add(tabbedPane, java.awt.BorderLayout.CENTER);

        jScrollPane1.setViewportView(jTree1);
        container.add(jScrollPane1, java.awt.BorderLayout.WEST);
    }

    /**
     * Adds a component to a JTabbedPane with a little "close tab" button on the
     * right side of the tab.
     * @param tabbedPane the JTabbedPane
     * @param c any JPanel
     * @param title the title for the tab
     * @param icon the icon for the tab, if desired
     */
    public static void addClosableTab(final JTabbedPane tabbedPane, final JPanel c, final String title,
            final Icon icon) {
        // Add the tab to the pane without any label
        tabbedPane.addTab(null, c);
        int pos = tabbedPane.indexOfComponent(c);

        // Create a FlowLayout that will space things 5px apart
        FlowLayout f = new FlowLayout(FlowLayout.CENTER, 5, 0);

        // Make a small JPanel with the layout and make it non-opaque
        JPanel pnlTab = new JPanel(f);
        pnlTab.setOpaque(false);

        // Add a JLabel with title and the left-side tab icon
        JLabel lblTitle = new JLabel(title);
        lblTitle.setIcon(icon);

        // Create a JButton for the close tab button
        JButton btnClose = new JButton();
        btnClose.setOpaque(false);

        // Configure icon and rollover icon for button
        btnClose.setIcon(new ImageIcon("D:\\def.png"));

        // Set border null so the button doesn't make the tab too big
        btnClose.setBorder(null);

        // Make sure the button can't get focus, otherwise it looks funny
        btnClose.setFocusable(false);

        // Put the panel together
        pnlTab.add(lblTitle);
        pnlTab.add(btnClose);

        // Add a thin border to keep the image below the top edge of the tab
        // when the tab is selected
        pnlTab.setBorder(BorderFactory.createEmptyBorder(2, 0, 0, 0));

        // Now assign the component for the tab
        tabbedPane.setTabComponentAt(pos, pnlTab);

        // Add the listener that removes the tab
        ActionListener listener = new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                // The component parameter must be declared "final" so that it can be
                // referenced in the anonymous listener class like this.

                hmPanel.remove(c.getToolTipText());
                tabbedPane.remove(c);
            }
        };
        btnClose.addActionListener(listener);

        // Optionally bring the new tab to the front
        tabbedPane.setSelectedComponent(c);

        //-------------------------------------------------------------
        // Bonus: Adding a keystroke binding to close the tab
        //-------------------------------------------------------------
        AbstractAction closeTabAction = new AbstractAction() {

            @Override
            public void actionPerformed(ActionEvent e) {
                tabbedPane.remove(c);
            }
        };

        // Create a keystroke
        KeyStroke controlW = KeyStroke.getKeyStroke("control W");

        // Get the appropriate input map using the JComponent constants.
        // This one works well when the component is a container.
        InputMap inputMap = c.getInputMap(JComponent.WHEN_ANCESTOR_OF_FOCUSED_COMPONENT);

        // Add the key binding for the keystroke to the action name
        inputMap.put(controlW, "closeTab");

        // Now add a single binding for the action name to the anonymous action
        c.getActionMap().put("closeTab", closeTabAction);
    }
}

Dynamically Adding Panel to JTabbedpane

2013-03-04T22:58:00.003-08:00

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package jtabbedpanedemo;

import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;

/**
*
* @author R.Amirtharaj
*/
public class MainFrame {

    private JTabbedPane tabbedPane;
    private javax.swing.JPanel buttonPanel;
    private javax.swing.JButton createTabButton;
    private static final Icon CLOSE_TAB_ICON = new ImageIcon("Image Location");
    private int tabCount = 0;

    public static void main(String[] args) {
        //Schedule a job for the event-dispatching thread:
        //creating and showing this application's GUI.
        SwingUtilities.invokeLater(new Runnable() {

            public void run() {
                createAndShowGUI();
            }
        });
    }

    private static void createAndShowGUI() {
        //Create and set up the frame.
        //The string passed as an argument will be displayed
        //as the title.

        JFrame.setDefaultLookAndFeelDecorated(true);
        JFrame frame = new JFrame("[=] JTabbedPane Demo [=]");

        //Create and set up the content pane.
        MainFrame demo = new MainFrame();
        demo.addContainer(frame.getContentPane());

        // The other bits and pieces that make our program a bit more stable.
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setSize(400, 400);
        frame.setVisible(true);
    }

    public void addContainer(Container container) {
        tabbedPane = new javax.swing.JTabbedPane();
        buttonPanel = new javax.swing.JPanel();

        container.add(tabbedPane, java.awt.BorderLayout.CENTER);

        createTabButton = new javax.swing.JButton();

        createTabButton.setText("Add New Tab");
        createTabButton.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {
                createTabButtonActionPerformed(evt);
            }
        });
        buttonPanel.add(createTabButton);

        container.add(buttonPanel, java.awt.BorderLayout.SOUTH);

    }

    private void createTabButtonActionPerformed(java.awt.event.ActionEvent evt) {
        tabCount++;
        JScrollPane scrollPane = new JScrollPane(new JTextArea("New tab number " + tabCount));
        addClosableTab(tabbedPane, scrollPane, "Tab " + tabCount);
    }

    /**
     * Adds a component to a JTabbedPane with a little "close tab" button on the
     * right side of the tab.
     * @param tabbedPane the JTabbedPane
     * @param c any JComponent
     * @param title the title for the tab
     */
    public static void addClosableTab(final JTabbedPane tabbedPane, final JComponent c, final String title
            ) {
        // Add the tab to the pane without any label
        tabbedPane.addTab(null, c);
        int pos = tabbedPane.indexOfComponent(c);

        // Create a FlowLayout that will space things 5px apart
        FlowLayout f = new FlowLayout(FlowLayout.CENTER, 5, 0);

        // Make a small JPanel with the layout and make it non-opaque
        JPanel pnlTab = new JPanel(f);
        pnlTab.setOpaque(false);

        // Add a JLabel with title and the left-side tab icon
        JLabel lblTitle = new JLabel(title);

        // Create a JButton for the close tab button
        JButton btnClose = new JButton();
        btnClose.setOpaque(false);

        // Configure icon and rollover icon for button
        btnClose.setIcon(CLOSE_TAB_ICON);

        // Set border null so the button doesn't make the tab too big
        btnClose.setBorder(null);

        // Make sure the button can't get focus, otherwise it looks funny
        btnClose.setFocusable(false);

        // Put the panel together
        pnlTab.add(lblTitle);
        pnlTab.add(btnClose);

        // Add a thin border to keep the image below the top edge of the tab
        // when the tab is selected
        pnlTab.setBorder(BorderFactory.createEmptyBorder(2, 0, 0, 0));

        // Now assign the component for the tab
        tabbedPane.setTabComponentAt(pos, pnlTab);

        // Add the listener that removes the tab
        ActionListener listener = new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                // The component parameter must be declared "final" so that it can be
                // referenced in the anonymous listener class like this.
                tabbedPane.remove(c);
            }
        };
        btnClose.addActionListener(listener);

        // Optionally bring the new tab to the front
        tabbedPane.setSelectedComponent(c);

        //-------------------------------------------------------------
        // Bonus: Adding a keystroke binding to close the tab
        //-------------------------------------------------------------
        AbstractAction closeTabAction = new AbstractAction() {

            @Override
            public void actionPerformed(ActionEvent e) {
                tabbedPane.remove(c);
            }
        };

        // Create a keystroke
        KeyStroke controlW = KeyStroke.getKeyStroke("control W");

        // Get the appropriate input map using the JComponent constants.
        // This one works well when the component is a container.
        InputMap inputMap = c.getInputMap(JComponent.WHEN_ANCESTOR_OF_FOCUSED_COMPONENT);

        // Add the key binding for the keystroke to the action name
        inputMap.put(controlW, "closeTab");

        // Now add a single binding for the action name to the anonymous action
        c.getActionMap().put("closeTab", closeTabAction);
    }
}

Solution for Oracle 11g import export problem

2013-01-02T20:46:00.000-08:00

If any table contain blank data export won't be proper in Oracle 11g.
Solution is Before Export we need to allocate extent to empty table.
Need to execute below query

select 'alter table '||table_name||' allocate extent;' from user_tables where segment_created = 'NO'

     above query will give list of query to allocate extent to empty table like below

    alter table ELTRIX_TAG_MASTER allocate extent;
    alter table ELTRIX_TREND_CONFIG allocate extent;
    ...etc

   Then need to execute above list of queries , after that as usual exp and imp commands will work without any issue.

How to find Query Execution Time in Oracle database?

2013-01-01T23:05:00.002-08:00

select * from v$sql;

You will notice that you can further filter on lot of useful stuff.

For example:
Lets say you want to see only those queries coming via a JDBC Thin Driver, you can do:

select LAST_LOAD_TIME, ELAPSED_TIME, MODULE, SQL_TEXT elasped from v$sql WHERE MODULE='JDBC Thin Client' ORDER BY LAST_LOAD_TIME DESC

To see all the columns in this table:
desc v$sql

Finding open Cursor in particular user :

select sql_text, count(*) as "OPEN CURSORS", user_name from v$open_cursor where user_name='XXXXX' group by sql_text, user_name order by count(*) desc;

Marker Interface in java

2012-12-31T23:07:00.004-08:00

Marker Interface in java :

Interfcaes with no methods are known as Marker interface.

Java Marker Interface Examples :
    java.lang.Cloneable
    java.io.Serializable
    java.util.EventListener

Suppose you need to persist(save) the object then need to implement the
java.io.Serializable interface otherwise compiler will throw exception.
We can take another example we need to clone any object that class neither
implemented java.lang.Cloneable interface nor that superclass implemented .
Otherwise while calling clone() method will throw error.

For Spliting a String based on given length

2012-12-13T03:56:00.001-08:00

// For Spliting a String based on given length and return as a String array
public static String[] splitByLength(String s, int chunkSize) {
    int arraySize = (int) Math.ceil(s.length() / chunkSize);
    if (s.length() % chunkSize != 0) {
        arraySize += 1;
    }
    String[] returnArray = new String[arraySize];
    for (int i = 0; i < returnArray.length; i++) {
        int beginindex = i * chunkSize;
        int endindex = beginindex + chunkSize;
        if (endindex > s.length()) {
            endindex = s.length();
        }
        returnArray[i] = s.substring(beginindex, endindex);
    }
    return returnArray;
}

Command Pattern

2012-12-13T03:45:00.000-08:00

Command Pattern :
    It is used to encapsulate request as an object and pass to an invoker, wherein the invoker
doesnot knows how the service the request but uses the encapsulated command to perform an action.

Key Terms:
Command : It is an interfcae with excecute method . It is core of contract.
Command Implementation :its instance creates a binding between receiver and an action.
Client : Its creates an instance of Command implementation and associates with a receiver.
Invoker : It instructs command to an action.
Receiver: It knows the actual steps to perform an action.

When to use:
1. A History of requests needed.
2. Need Callback functionality.
3. Requests need to handled at varient time or varient orders.
4. A invoker should be decupled from the object handling the invocation.

Example:

Take an Example of Light process .

1. Create Command interface have execute method

public interface Command {
    public void execute();
}

2. Create Receiver Class , it's knows actual steps to perform an action

public class Light {
    boolean on;
    public void switchOn()   {
       on = true;
       System.out.println("Light is on");
   }
   public void switchOff() {
       on = false;
       System.out.println("Light is off");
   }
}

3. Create a Command Implemention associated with receiver

// For On
public class LightOnCommand implements Command{
    // associated receiver
    Light light;
    public LightOnCommand(Light light) {
        this.light = light;
    }
    public void execute() {
        light.switchOn();
    }
}

// Similarly for Off
public class LightOffCommand implements Command {
    // associated receiver
    Light light;
    public LightOffCommand(Light light)   {
        this.light = light;
    }
    public void execute() {
        light.switchOff();
    }
}

4. Create Inoker class ,it's instructs the command to an action

public class RemoteControl {
    private Command cmd;
    public void setCommand(Command cmd)
    {
        this.cmd = cmd;
    }
    public void pressButton()
    {
        cmd.execute();
    }
}

5. Finally a Client class, Its creates an instance of Command implementation and associates with a receiver

public class Client {

    public static void main(String arg[])
    {
        RemoteControl rc = new RemoteControl();
        // Receiver
        Light light = new Light();

        // creates an instance of Command implementation
        Command lightOn = new LightOnCommand(light);
        Command lightOff = new LightOffCommand(light);

        // For Switch on
        rc.setCommand(lightOn);
        rc.pressButton();

        // For Switch off
        rc.setCommand(lightOff);
        rc.pressButton();
    }
}

Oracle Qrery for get time and update time

2012-08-10T04:42:00.002-07:00

// Select

select to_char(COL_NAME,'MM/DD/YYYY HH:MI:SS AM') from TABLE_NAME

// Update
update TABLE_NAME set COL_NAME=to_date('2012-07-30 11:13:39','MM/DD/YYYY HH:MI:SS AM')

To get coming Start of the day in java

2012-08-10T00:35:00.002-07:00

public Date getComingStartoftheDay()
    {
        java.util.GregorianCalendar today = (GregorianCalendar) Calendar.getInstance();
        today.set(Calendar.HOUR_OF_DAY, 0);
        today.set(Calendar.MINUTE, 0);
        today.set(Calendar.SECOND, 0);
        today.set(Calendar.MILLISECOND, 0);

        Timestamp ts = new Timestamp(today.getTime().getTime()+86400000);
        Date date = new Date(ts.getTime());
        System.out.println(date);
        return date;
    }

Disable annoying Java Update notification

2012-03-13T22:34:00.000-07:00

Disable annoying Java Update notification

If you’re sick of getting prompted to update Java, or if you have some web application like Banner that requires a particular version, you can use a simple registry hack to disable notification of available updates.

Open the Registry Editor by going to the Start button and typing in regedt32.
Navigate through to the following key: HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Update\Policy
Change the value of EnableAutoUpdateCheck to 0 and the value of EnableJavaUpdate to 0.

Java should no longer prompt you for the annoying updates.

Read Excel file using poi-3.0.1-FINAL-20070705.jar

2011-10-10T00:13:00.000-07:00

Read Excel file using poi-3.0.1-FINAL-20070705.jar code as below

import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.HashMap;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

/**
*
* @author user
*/
public class Demo {

public static void main(String arg[]) {
Demo demo = new Demo();
String[][] strCom = {{"A", "String"}, {"B", "String"}, {"E", "String"}};
ArrayList alRTags = demo.readExcelValue("C:\\Documents and Settings\\user\\Desktop\\def.xls", 5, strCom);
for (int i = 0; i < alRTags.size(); i++) {
//int uid = vIAObj.getOPCTagMasterUniqueID();
System.out.println(alRTags.get(i));
}
}

public ArrayList readExcelValue(String strFileName, int len, String[][] strCom) {
ArrayList alRTags = null;
try {
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(strFileName));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = null;
HSSFCell cell = null;
int rows = sheet.getPhysicalNumberOfRows();
row = sheet.getRow(0);
String strTagName = "";

HashMap hmRC = new HashMap();
HashMap hmRCN = new HashMap();
for (int i = 0; i < strCom.length; i++) {
hmRC.put(strCom[i][0], strCom[i][1]);
}

String heading = "";

for (int j = 0; j <= len; j++) //for (int j = 0; j <= 5; j++) //
{
if (row != null) {
cell = row.getCell((short) j);
if (cell != null) {
String strH = String.valueOf(cell.getStringCellValue());
if (hmRC.containsKey(strH)) {
hmRCN.put(j, hmRC.get(strH));
}
heading += strH + ",";
}
}
}

if (heading == null) {
heading = "NoData";
} else if (heading.trim().equals("")) {
heading = "NoData";
}
System.out.println("heading " + heading);

alRTags = new ArrayList();
for (int r = 1; r <= rows; r++) {
row = sheet.getRow(r);
if (row != null) {
for (int i = 0; i < len; i++) {
strTagName = "NA";

if (hmRCN.containsKey(i)) {
cell = row.getCell((short) i);
try {
if (hmRCN.get(i).equals("String")) {
strTagName = String.valueOf(cell.getStringCellValue());
} else {
strTagName = String.valueOf(cell.getNumericCellValue());
}
} catch (Exception e) {
}
alRTags.add(strTagName);
}
}
}
}

} catch (Exception e) {
e.printStackTrace();
}
return alRTags;
}
}

How to unistall oracle 10g Completely

2011-08-17T19:54:00.000-07:00

I tried for uninstalling Oracle,
First I removed from Add/Remove Programs.. But its not removed entirely..
When I reinstall again ...It's installing on another location...
So really its irritated like anything...

Then I followed below steps then its worked fine...

# Stop any Oracle services that have been left running.
Start->Settings->Control Panel->Services
Look for any services with names starting with 'Oracle' and stop them.

# Run regedit and delete the following keys (some may have slightly different names in your registry):
HKEY_CURRENT_USER\SOFTWARE\ORACLE
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\EventLog\Application\Oracle.oracle
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\OracleDBConsole
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Oracle10g_home
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\OraclService

Note that the services control panel will still show the old services until you reboot.

# Delete the Oracle home directory
C:\Oracle

# Delete the Oracle Program Files directory:
C:\Program Files\Oracle

Note: For above steps , while deleting may be some dll files makes some problem
like cant delete access denied ... For that rename and move that specfied dll then restart the m/c then delete

# Delete the Oracle Start Menu shortcuts directory:
C:\Documents and Settings\All Users\Start Menu\Programs\Oracle*
Where * indicates the name of your install. Look for and remove all Oracle directories from that location.

# Remove Oracle refereces from the path. To edit your path go to:
Start->Settings->Control Panel->System->Advanced->Environment Variables
Edit both of the environment variables user PATH and system PATH. Remove any Oracle references in them.

# Remove Oracle.DataAccess and any Polic.Oracle files from the GAC which is at:
C:\Windows\assembly\

Your system is Oracle free after this. So go ahead and now install a new instance of Oracle.

How do I get process id of a Java application?2011-07-14T01:49:00.000-07:00
import java.lang.management.RuntimeMXBean;
public class GetProcessID {
    public static void main(String[] args) {
        RuntimeMXBean bean = ManagementFactory.getRuntimeMXBean();

 
        //
        // Get name representing the running Java virtual machine.
        // It returns something like 6460@AURORA. Where the value
        // before the @ symbol is the PID.
        //
        String jvmName = bean.getName();
        System.out.println("Name = " + jvmName);

 
        //
        // Extract the PID by splitting the string returned by the
        // bean.getName() method.
        //
        long pid = Long.valueOf(jvmName.split("@")[0]);
        System.out.println("PID  = " + pid);
    }


Note :
Killing process based on Processid
Process p = Runtime.getRuntime().exec("taskkill /pid PROCESSID /f");

OpenPDFUsingJava

2011-06-14T03:18:00.000-07:00

import java.awt.Desktop;
import java.io.File;

/**
*
* @author R.Amirtharaj
*/
public class OpenPDFUsingJava {

public static void main(String[] args) {

try {

File pdfFile = new File("C:"+File.separator+"MyFile.pdf");
if (pdfFile.exists()) {

if (Desktop.isDesktopSupported()) {
Desktop.getDesktop().open(pdfFile);
} else {
System.out.println("Awt Desktop is not supported!");
}

} else {
System.out.println("File is not exists!");
}

System.out.println("Done");

} catch (Exception ex) {
ex.printStackTrace();
}

}

}