title: invalid number exception while reading csv using java
body: <p>i am reading csv file and storing into oracle database using java
  my database structure is :</p>
  
  <pre><code>Name          Null Type          
  ------------- ---- ------------- 
  DATE_D             VARCHAR2(800) 
  DESCRIPTION        VARCHAR2(800) 
  TRANSACTIONID      VARCHAR2(800) 
  CREDIT_AMOUNT      NUMBER(8,2)   
  DEBIT_AMOUNT       NUMBER(8,2)   
  REMAINING          NUMBER(8,2)   
  ODAMOUNT           NUMBER(8,2)   
  ENTEREDBY          VARCHAR2(800) 
  REMARKS            VARCHAR2(800)
  </code></pre>
  
  <p>till 300 records program inserting the records properly without exception
  the 300th record is :</p>
  
  <pre><code>30/01/2017 17:36:19 ICCDMR AGENT COMMISSION OLKB9O  0.17    0   2744.63 0  INHYD03904375S   ICCDMR AGENT COMMISSION - 9550681786
  </code></pre>
  
  <p>301 record is this :</p>
  
  <pre><code>30/01/2017 17:33:49 ICCDMR AGENT COMMISSION OLKB24  0.08    0   2744.46 0   INHYD03904375S  ICCDMR AGENT COMMISSION - 7097545406
  </code></pre>
  
  <p>i am wondering that what is the deference here that i am getting invalid number exception.
  here is my java code:</p>
  
  <pre><code>while ((line = br.readLine()) != null) {
          linecount++;
          String[] value = line.split(",");
          if (linecount != 1) {
              value1 = value[0].split(" ");
              System.out.println(value1[0]);
              System.out.println(value1[1]);
              String sql = "insert into HARMS( date_d,time_t,Description ,TransactionId,"
                          + "Credit_Amount,Debit_Amount ,Remaining,OdAmount ,EnteredBy,Remarks)"
                          + "values('" + value1[0] + "','" + value1[1] + "','" + value[1] + "','" 
                          + value[2] + "','" + value[3] + "','" + value[4] + "','" + value[5] + "','" 
                          + value[6] + "','" + value[7] + "','" + value[8] + "')";
              ps = cn.prepareStatement(sql);
              int c = ps.executeUpdate();
         }
  }
  </code></pre>
  
  <p>please get me out of this.</p>