How to know TCP/IP port listening or free in UNIX / Linux?

Use netstat command in linux / unix and grep for a port number

>netstat -anp | grep <port_number>

How to export and import mysql dump ?

To take export / backup of mysql DB, use following command

>mysqldump -u <db_username> -p<db_password> -h<db_host> db_name  > db_name_backup.sql

To take export / backup of table in mysql DB, use following command
 
>mysqldump -u <db_username> -p<db_password> -h<db_host> table_name > table_name_backup.sql

Similarly To import or dump the data into mysql database use following command
 
>mysql -u <db_username> -p<db_password> -h<db_host> db_name < ~/db_name_backup.sql (ensure db_name_backup.sql present in home directory)

How to kill Some Java Process without Input PID?

To extract the PID use awk command and send the argument to xargs command.

ex: To kill activemq process use the below command

ps -ef | grep $USER | grep java | grep activemq | awk '{print $2}' | xargs kill -9

How to analyze how much time a program spends in each part of the code?

    To do this analysis use -prof option, like below.

F:\JavaSamples>java -prof Test
Hello World!
Dumping CPU usage in old prof format ... done.

F:\JavaSamples>dir

After running java application, The JVM dumps the each part of code / api calls into a seperate file named  java.prof

java.prof:
count callee caller time
1375 java.lang.AbstractStringBuilder.ensureCapacityInternal(I)V java.lang.AbstractStringBuilder.append(C)Ljava/lang/AbstractStringBuilder; 0
1306 java.lang.String.charAt(I)C java.lang.String$CaseInsensitiveComparator.compare(Ljava/lang/String;Ljava/lang/String;)I 15
759 java.io.WinNTFileSystem.isSlash(C)Z java.io.WinNTFileSystem.normalize(Ljava/lang/String;II)Ljava/lang/String; 0
759 java.lang.String.charAt(I)C java.io.WinNTFileSystem.normalize(Ljava/lang/String;II)Ljava/lang/String; 0
755 java.lang.CharacterDataLatin1.getProperties(I)I java.lang.CharacterDataLatin1.toLowerCase(I)I 0
755 java.lang.CharacterDataLatin1.toLowerCase(I)I java.lang.Character.toLowerCase(I)I 0
..

How to compile and run java code in EditPlus?

Run EditPlus,

Navigate to Tools --> Configure User Tools -->

1. Change GroupName to javac
2. Add Tool like below

and also for java

finally use the user tools from tool bar
That all..

How to start learning java?

   To start learning java, you need JDK (Java Development Kit) and some text editor like EditPlus or power full IDE like Eclipse

Download the JDK from Oracle site and install it.

Set Environment variable PATH and CLASSPATH

Write a sample java program with the text editor and compile with javac compiler

and run the class with java tool / JVM

MainClass.java :

public class MainClass {

    public static void main(String[] args) {

        System.out.println("Java");

    }

}

>javac MainClass.java

>java MainClass

You may get compile time or runtime error if you not properly set Environment variables

PATH must point to bin directory of JDK like C:\Program Files\Java\jdk1.8.0_45\bin

CLASSPATH must point to lib directory of JDK / JRE like C:\Program Files\Java\jdk1.8.0_45\jre\lib or C:\Program Files\Java\jre1.8.0_51\lib

choose JDK's JRE for better compatibility 

hsqldb + Exception in thread "main" org.hibernate.exception.JDBCConnectionException: Could not open connection

Exception in thread "main" org.hibernate.exception.JDBCConnectionException: Could not open connection
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:131)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
    at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:304)
    at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:169)
    at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
    at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)
    at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1263)
    at com.subbu.test.HibernateTest.main(HibernateTest.java:17)
Caused by: java.sql.SQLException: Connection is broken: java.io.EOFException
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
    at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
    at org.hsqldb.jdbcDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:173)
    at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:276)
    at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)
    ... 5 more
Bcz of the below dependency, the above exception thrown.
        <dependency>
            <groupId>hsqldb</groupId>
            <artifactId>hsqldb</artifactId>
            <version>1.8.0.10</version>
        </dependency>



use same version jar!!!

<dependency>
    <groupId>org.hsqldb</groupId>
    <artifactId>hsqldb</artifactId>
    <version>2.3.2</version>
</dependency>