java.net.BindException: Address already in use

I am trying to do one program which copy data from sap to mysql.Data is in bulk quantity.

when i run the program i am getting exception of

java.net.BindException: Address already in use
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.Socket.bind(Socket.java:553)
        at java.net.Socket.<init>(Socket.java:363)
        at java.net.Socket.<init>(Socket.java:178)
        at org.gjt.mm.mysql.MysqlIO.<init>(MysqlIO.java:114)
        at org.gjt.mm.mysql.Connection.<init>(Connection.java:229)
        at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at mySAP.mysqlBean.getConnection(mysqlBean.java:52)
        at mySAP.mysqlBean.getRecordCount(mysqlBean.java:96)
        at zpoviewDataRetriever.chkRecordExist(zpoviewDataRetriever.java:80)

The exception line in the program is
      try {
                  Class.forName(DbDriver).newInstance();
                  con = DriverManager.getConnection(url + DbName + "?user=" + DbUser
                              + "&password=" + DbPassword);
                  stmt = con.createStatement();
                  
            } catch (Exception e) {
                  System.out.println("error in connction to sql in check record exist" + e);
            }
            
            
            
            try
            {
             rec_count = mysql.getRecordCount("sapMaterialMaster",
                        "Select count(*) from zpoview where EBELN='"+chk_ebeln+"' and EBELP='"+chk_ebelp+"' and ETENR ='"+chk_etenr+"'");
             stmt.close();
             con.close();
             
            } catch (Exception e) {
                  System.out.println("in record count" + e);
                  
            }

I am calling the above function,before inserting data into table i will check whether data is already there in table or not..most of time it is working fine with out exception but some times i am getting the above exception

server is linux based one.


any hints


Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

try {
			Class.forName(DbDriver).newInstance();
			con = DriverManager.getConnection(url + DbName + "?user=" + DbUser
					+ "&password=" + DbPassword);
			stmt = con.createStatement();
			
		} catch (Exception e) {
			System.out.println("error in connction to sql in check record exist" + e);
		}
		
		
		
		try
		{
		 rec_count = mysql.getRecordCount("sapMaterialMaster",
				"Select count(*) from zpoview where EBELN='"+chk_ebeln+"' and EBELP='"+chk_ebelp+"' and ETENR ='"+chk_etenr+"'");
		 stmt.close();
		 con.close();
		 
		} catch (Exception e) {
			System.out.println("in record count" + e);
			
		}